Sr. ETL Developer (ONSITE, IN)

The purpose of the Senior Extract Transform Load (ETL) Developer position is to design, develop, unit test, document, and perform ongoing support for the ETL and SQL code. Additionally, the Senior ETL Developer needs to understand ETL to and from common databases and file formats. This person is expected to be a subject matter expert that other team members can use as a reference for business knowledge, ETL, SQL, data discovery / design, and programming. The Senior ETL Developer is expected to mentor and train ETL Developers on processes and tools. The Senior ETL Developer may also have supervisory responsibilities.

Job Duties and Responsibilities :

Data Integration Development / Administration (75%)

• Develop workflows and mappings to integrate data from and into various systems and data stores
• Unit test workflows and mappings
• Troubleshooting and correcting existing ETL solutions
• Create and unit test SQL as scripts or to be used within workflows / mappings
• Understanding the data warehouse and data mart models as well as being familiar with the business information contained in each
• Migrate or assist with migrating code by creating migration worksheets
• Validate production code once it’s been migrated to the production environment
• Perform code reviews
• Support daily job process and nightly batch cycles to ensure data is loaded within SLA for business systems and reporting
• Attend meetings in support of development / project efforts
• Assist with software product version updates and patches
• Assist with creating and maintain best practices
• Assist in creating automations that will help the team be more efficient and move faster

Discovery, Design and Documentation (15%)

Enhance Skillsets (10%)

Knowledge of data integration design patterns and database best practices (Kimball, Inmon, Dims, Facts, etc ...)

Qualifications (Education, Experience, Certifications & KSA) :

#LI_ID1

#LI_HYBRID

We offer our employees a robust compensation package! Our comprehensive benefits include : medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.

All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.