Job#: 3014424

Job Description:

JOB TITLE: Data Engineer II

DURATION: 5 MONTHS

LOCATION: ONSITE IN SEATTLE. WA

PAY RATE: $57 - $67 HOURLY

Job Description:

Our mission is to eliminate operational bottlenecks through automation and AI, creating the technical foundation that enables breakthrough sustainability innovations essential for net zero.

Responsibilities

As a Data Engineer on the team, you will be working with business-critical sustainability data pipelines. You will be responsible for migrating production ETL jobs from legacy data platforms to modern infrastructure, ensuring zero disruption to operations that drive corporate carbon footprinting, quarterly business reviews, and customer-facing sustainability communications.

You will establish the technical foundation for our data infrastructure by setting up workflow orchestration platforms in new accounts. You will translate existing data workflows into scalable pipelines, implementing robust validation to ensure data consistency and quality throughout the migration.

You will work across multiple critical data domains including sales data, active device telemetry, transportation carbon emissions, energy consumption metrics, sustainability badging workflows, and executive reporting dashboards. You will partner with Science team members who own carbon calculation methodologies and program teams who depend on these pipelines for daily operations, understanding their requirements and ensuring migrated solutions support their analytical and operational needs.

You will coordinate with upstream data owners to secure access permissions, collaborate with platform teams to troubleshoot integration issues, and communicate migration progress and risks to stakeholders across the organization. Clear communication will be essential as you navigate dependencies across multiple teams and ensure alignment on migration timelines and success criteria.

You will be responsible for comprehensive documentation of the new architecture, including data lineage, dependencies, monitoring strategies, and operational runbooks. This documentation will enable the team to maintain and evolve the infrastructure after your engagement completes. You will implement data quality checks and alerting to proactively identify issues before they impact downstream consumers.

Required Skills & Experience

3-6 years building and maintaining production data pipelines in complex enterprise environments

Strong SQL skills for writing complex transformations, optimizing query performance, and troubleshooting data quality issues across large datasets

Hands-on experience with AWS data services including Redshift, S3, Glue, and IAM for data access management

Deep understanding of ETL best practices including data validation, error handling, idempotency, and lineage tracking

Experience with Python or Spark for implementing data transformation logic

Strong analytical skills and ability to work with large, complex datasets spanning multiple source systems

Excellent communication and stakeholder management skills, with ability to coordinate across multiple technical teams and translate technical concepts for non-technical audiences

Ability to partner directly with technical stakeholders to understand requirements and deliver solutions that meet operational needs

Proven track record managing data migrations or large-scale infrastructure transitions with minimal business disruption

Preferred Qualifications

Experience with workflow orchestration platforms

QuickSight experience for dashboard development

Background in large-scale data migrations

Familiarity with sustainability data, carbon accounting, or environmental metrics

Experience setting up monitoring and alerting for production data pipelines

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.