Data Engineer III
Business Data Engineer (SLC, UT)
Lead the design, development, and maintenance of ETL processes using Snowflake and AWS Cloud Services. Extract structured and semi-structured commercial datasets from upstream Oracle source systems into Snowflake cloud data warehouses. Ensure smooth data extraction, transformation and loading using Fivetran. Improve business data pipelines for efficiency, performance and scalability. Use BigQuery to execute complex data transformations to meet business requirements for marketing teams. Create dashboards using Looker. Utilize custom frameworks including SFTP and APIs to handle data stored in CSV, JSON, and relational databases. Manage data codebase integrity, version control pipelines, and software deployment using Github. Create robust framework to streamline data transformations accommodating all structured and unstructured data formats and supporting automated scheduling/monitoring. Generate and troubleshoot advanced code using SQL and Python. Implement automated data quality checks and validation processes. Work with commercial product managers to ensure accurate/reliable data delivery. Document ETL processes, data models, and framework functionalities. Stay updated on emerging technologies and trends in data engineering.
Requirements: Master’s Degree in Computer Science, plus 2 years of experience in job offered, proficiency with ETL, Fivetran or Matillion, Snowflake, complex Oracle data transformations, JSON, CSV, APIs, SFTP, SQL, Python, AWS Cloud Services, Github administration, and Agile/Scrum SDLC.
Telecommute possible
#LI-KO1