Data Engineer II – ETL/ELT

This is a fully remote position, open to applicants in Arizona, +3 more states.

📋 Description

• Design, develop, and maintain data pipelines for both real-time and batch processing.

• Implement and enhance ETL processes for extracting, loading, transforming, and integrating data from diverse sources.

• Improve data flows and storage solutions to boost performance.

• Create and implement data warehouse architectures.

• Ensure data quality and consistency within the data warehouse environment.

• Utilize data modeling techniques for efficient data storage and retrieval.

• Establish data governance policies, procedures, quality frameworks, standards, and documentation.

• Ensure adherence to relevant data regulations and standards.

• Implement measures for data security and access controls.

• Maintain protocols for data protection.

• Analyze and enhance system performance for large-scale data operations.

• Troubleshoot data-related issues and implement effective solutions.

• Develop unit test cases and verify data integrity and consistency requirements.

• Adopt automated data pipelines utilizing GitLab, GitHub, and CI/CD tools.

• Implement release management processes for code deployment to production, disaster recovery, and other environments.

• Collaborate with data scientists, analysts, and other teams to fulfill data requirements.

• Engage in cross-functional projects that support data-driven initiatives.

⛳️ Requirements

• Bachelor's Degree with 2 years of experience in data engineering, data technologies, or cloud platforms, OR a High School Diploma or GED with 6 years of experience in the same fields.

• Practical experience in constructing data pipelines using Medallion Architecture patterns.

• Experience with Qlik Replicate for snapshot, CDC, and batch data ingestion.

• Proficiency in Python development for data pipeline components.

• Experience with dbt Cloud transformations, testing, and SQL development.

• Familiarity with Snowflake ingestion and processing, including Snowpipe, Tasks, and Stored Procedures.

• Understanding of RBAC and data masking concepts in Snowflake.

• Experience in cloud-native development on AWS or equivalent Azure platforms.

• Proficient with CI/CD pipelines such as GitLab and GitHub Actions.

• Experience with observability and monitoring tools like Splunk or Dynatrace.

• Background in regulated or governance-heavy environments.

• Relevant cloud or data platform certifications are preferred.

• Candidates must be located in North Carolina, Texas, Arizona, or Florida.

🏝️ Benefits

• A competitive, thoughtfully designed, and high-quality benefits program.

• Benefits information is accessible through the employer’s benefits program.