Senior ETL Developer

Job Title: Senior ETL Developer (Data Warehouse) Job Type: Contract Location: Remote This candidate will be part of a 45+ person team made up of Project Managers, Teradata and Web Developers, Data Modelers, DBAs, Business Analysts and Report Analysts. Must be able to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector. Job Duties: Manage batch job migration and conversion activities for the State of Michigan Health Services Data Warehouse and participating systems/users Learn a homegrown batch processing environment (MDHHS Common Batch Framework) from State of Michigan documentation and on the job exposure Learn the operational protocols and best practices of the MDHHS Common Batch Framework Review existing batch jobs to understand their current function, including Linux shell scripts and Teradata utility scripts for BTEQ, TPT, Multiload, Fastload, and FastExport Convert existing batch jobs into the MDHHS Common Batch Framework, ensuring they follow the operational protocols and best practices Test batch job conversions for accuracy, quality, and adherence to standards Become proficient with the State of Michigan Helix ticket system and the promotion process for production Lead other developers in the conversion of existing batch jobs Mentor other developers in the creation of new batch processes Follow a cohesive approach for achieving conversion milestones Analyze and recommend process improvements Must be able to work independently Required: 5+ Years of Teradata Experience (V16/17) and Teradata Utilities 5+ Years' Experience with SQL Assistant 5+ Years' Experience performing Data Extracts, Data Transformations & Data Loads (ETL) 5+ Years' Experience with Linux/Unix shell scripting 5+ Years' Experience with Data Migration 5+ Years' Experience with all phases of SDLC 5+ Years' Experience working on projects employing Agile methodology Preferred: Bachelor's degree or equivalent technical study 1+ Years' Experience with State Government/Public Health business areas Experience working with business partners to proactively identify value add solutions Experience with Report Development