Job Description: We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong ETL developer 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
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)
Implementing change data capture (CDC)
Testing and debugging ETL
ETL job scheduling
Management of multiple ETL tools
Experience with data quality tools and frameworks
Loading data warehouses using ETL tools
Developing complex SQL (6 years)
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