Gathering requirements and developing technical specifications for ETL - 6 years
Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 years
Implementing change data capture (CDC) - 4 years
Testing and debugging ETL - 6 years
Developing complex SQL - 6 years
ETL job scheduling - 2 years
Loading data warehouses using ETL tools - 2 years
Nice To Have
Management of multiple ETL tools
Experience with data quality tools and frameworks - preferred
Using source code version control software - preferred
Interview Process: 1-2 rounds via Microsoft Teams.
Onsite or Remote? This position can work 100% remote or in the office.
Job Description
We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.
Desired Experience
Gathering requirements and developing technical specifications for ETL - 6 years
Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 years
Implementing change data capture (CDC) - 4 years
Testing and debugging ETL - 6 years
Developing complex SQL - 6 years
ETL job scheduling - 2 years
Loading data warehouses using ETL tools - 2 years
Management of multiple ETL tools
Experience with data quality tools and frameworks
Using source code version control software
Mentoring to others on ETL development
Managing multiple, concurrent projects and tasks
Having strong interpersonal skills including communication, mentoring, collaborating, and team building
ETF Technologies
Alteryx
SSIS
SSRS
SQL Server
Tableau
Semarchy
Git & github
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Steneral Consulting by 2x