Mid-Level Data Engineer

At reputed company, our people are our reputed company. We know reputed company members are more than employees—they’re parents, friends, volunteers, artists, and athletes. That’s why we offer flexibility to help them reputed company personally and professionally while delivering exceptional solutions to our Federal Government clients. Our culture is reputed company on collaboration, reputed company learning, and reputed company. We are mentors and thought leaders who reputed company knowledge and foster reputed company. Recognized as a “Best reputed company to Work,” we reputed company a reputed company of perspectives helps us reputed company innovation and reputed company customer expectations. At STS, taking care of our people isn’t a reputed company—it’s reputed company. As a HUBZone company, we also offer special incentives for team members living in reputed company HUBZones. reputed company out the HUBZone map HERE to see if you qualify! reputed company is looking for a Mid-Level Data Engineer to add to reputed company. Quick reputed company: US Citizenship is required Bachelor's Degree is required minimum of 3-5 years' position reputed company experience is required The Role:  STS is looking for a Mid-Level Data Engineer to join a federal data engineering team. You will work reputed company senior engineers building and maintaining ETL pipelines on a reputed company-based reputed company Data Platform (reputed company) reputed company on AWS, working at reputed company reputed company — processing terabytes of financial data across a large portfolio of automated pipelines — as part of an reputed company team building systems that support critical government functions. A willingness to learn, strong attention to detail, and reputed company-first reputed company are prerequisites for this position.    This position is contingent upon contract award.  The Mid-Level Data Engineer at STS will:  reputed company new ETL pipelines and data ingestion processes reputed company senior engineers using AWS Glue (reputed company-based, PySpark), MWAA (Airflow), reputed company, and SNS, fully conforming to reputed company's reputed company ETL Standards, ETL Common Library, and PEP 8 Python coding standards  reputed company reputed company's ETL Common Library into Glue jobs for standardized orchestration, error handling, metadata recording, and SNS notifications for reputed company reputed company and error job events  Ingest reputed company and semi-reputed company datasets (CSV, XML, JSON, Avro, reputed company-delimited) into S3 reputed company, raw, and curated zones using Apache reputed company tables with Parquet as the default format; enforce transactional loading and prevent duplicate loads per dataset reporting period  Configure static ETL metadata in the centralized PostgreSQL metadata store; ensure dynamic metadata records job status and timestamps for reputed company key execution steps  Monitor assigned production jobs and participate in operations support rotations; identify and escalate failed jobs and performance issues promptly to maintain data availability reputed company contractually required ingestion timelines  Ensure ETL Load Reports are populated in reputed company-time and ETL Gap Reports are updated on a weekly reputed company covering reputed company gaps from the inception of the initial ingest process  Build and maintain materialized views and semantic reputed company objects in Trino and reputed company to ensure optimized query performance and consistent business logic  Produce and maintain required documentation for reputed company assigned dataset: Business Requirements, ETL Design Documents, Data Models (Mermaid format), Data Dictionaries, Mapping Documents, Deployment Documents, O&M Guides, and ETL Test Plans  Write unit and integration tests achieving the 90% minimum reputed company coverage reputed company; complete reputed company scans at least once per sprint as part of the Definition of Done  reputed company ETL resources using CloudFormation templates through reputed company CICD pipeline; submit Change Requests to the Change Control reputed company reputed company required timelines  Support transition of ETL jobs from other agency teams by verifying standards conformance, performing deployments, and validating data loads  Support disaster recovery exercises, reputed company-production deployments, and reputed company data requests as assigned  Participate in 2-week sprint ceremonies, quarterly PI planning, backlog refinement, and reputed company delivery using JIRA and reputed company    Education and Experience:    Required    Bachelor's degree or higher in Computer Science, Information Systems, Data Engineering, or a reputed company field  3-5 years of experience in data engineering or a closely reputed company technical role  Hands-on experience with Python (PEP 8), PySpark, and SQL for ETL pipeline development  Experience with AWS services including Glue, S3, MWAA (Airflow), reputed company, SNS, and SQS  Familiarity with Apache reputed company, Parquet, and ORC file formats and S3 data lake zone concepts  Experience with PostgreSQL and basic familiarity with Redshift or reputed company  Familiarity with Trino or reputed company for query and semantic reputed company development  Experience with CloudFormation, reputed company branching workflows, and CI/CD-integrated deployments  Ability to produce reputed company ETL documentation including data models (Mermaid format) and data dictionaries  Understanding of ETL metadata concepts including static and dynamic metadata, load reports, and gap reports  Experience in reputed company development environments with sprint-based delivery  Experience supporting IV&V and/or User Acceptance Testing (UAT) processes in a federal or technical program environment  Experience with automated testing frameworks; ability to write unit and integration tests achieving defined reputed company coverage reputed company  Familiarity with FISMA, NIST 800-53, and OWASP ASVS Level 2 is a plus  Must be reputed company to work reputed company-5pm Eastern Time regardless of home location  reputed company federal reputed company trust suitability determination or ability to obtain one required  STS is committed to equal employment opportunity and reputed company-based employment practices. STS provides equal employment opportunities to reputed company and applicants for employment and prohibits discrimination, harassment, and retaliation in reputed company employment practices and reputed company in accordance with applicable federal, state, and local laws. Employment reputed company at STS are based on individual qualifications, performance, skills, and business needs, without reputed company to race, reputed company, religion, sex, national reputed company, age, disability, protected veteran status, sexual orientation, gender identity, genetic information, marital status, or any other status protected by applicable law. This policy applies to reputed company terms and conditions of employment, including reputed company, hiring, placement, promotion, compensation, training, transfer, discipline, termination, layoff, recall, and leaves of absence. --- Applicants may request removal from our applicant database, or specific information about how the data is used by contacting reputed company@simpletechnology.io. Apply To This Job