Azure Data Engineer

Our Company

Explore how you can contribute at AmeriLife.

For over 50 years, AmeriLife has been a leader in the development, marketing and distribution of annuity, life and health insurance solutions for those planning for and living in retirement.

Associates get satisfaction from knowing they provide agents, marketers and carrier partners the support needed to succeed in a rapidly evolving industry.

Job Summary

We’re looking for a highly skilled Data Engineer to design, build, and run robust data pipelines that power enterprise-wide analytics and reporting. You’ll own ETL development and operational excellence across SQL Server, SSIS, Azure Data Factory (ADF), and Databricks, ensuring data reliability, scalability, and performance in a fast-paced environment.

Job Description

Responsibilities

• Analyze, troubleshoot, and resolve operational support tickets across BI, ETL processes, and data pipelines. 
• Maintain, enhance, and deploy SSIS packages with strong logging, error handling, and recoverability. 
• Develop, optimize, and troubleshoot complex T-SQL (queries, stored procedures, views, functions). 
• Build and orchestrate ADF pipelines (triggers, activities, linked services, IRs) with parameterization and environment promotion. 
• Ensure data accuracy and integrity in production; define validation checks and monitoring. 
• Perform root-cause analysis of failures and implement permanent fixes to prevent recurrences. 
• Document runbooks, operational processes, and known fixes for knowledge transfer. 
• Collaborate with BI developers, data engineers, and business analysts to translate user requests into durable solutions. 
• Proactively identify and deliver performance improvements (partitioning, indexing, parallelization, caching). 
• Contribute to reliability practices (alerting, retries, idempotent reruns, SLAs) and on-call readiness. 

 Required Qualifications:

• 5+ years of hands-on ETL development and production support. 
• Expert-level SQL Server (T-SQL), including performance tuning and query plan analysis. 
• Strong SSIS development, deployment, and troubleshooting experience in production. 
• Solid Azure Data Factory experience for data pipeline orchestration and monitoring. 
• Proven ability to analyze complex data issues and deliver timely, stable solutions. 
• Strong analytical and problem-solving skills with keen attention to detail. 
• Excellent communication skills and a collaborative, ownership-oriented work style. 

Preferred Qualifications:

• Exposure to SQL Server Analysis Services. 
• Experience with Power BI or other data visualization tools. 
• The ability to Shape model-ready datasets (clean dims/facts outputs, SCD outputs, RLS helper columns) with semantic modelers. 
• Azure Data Lake (ADLS): permissions, folder design, and security best practices. 
• Exposure to Databricks stack i.e. PySpark/Spark SQL, Delta Lake, Jobs; Unity Catalog a plus. 
• Python for automation and lightweight transforms 
• Familiarity with GitHub/Azure DevOps (CI/CD, releases, environment configuration). 

Equal Employment Opportunity Statement

We are an Equal Opportunity Employer and value diversity at all levels of the organization. All employment decisions are made without regard to race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), sexual orientation, gender identity or expression, age, national origin, ancestry, disability, genetic information, marital status, veteran or military status, or any other protected characteristic under applicable federal, state, or local law. We are committed to providing an inclusive, equitable, and respectful workplace where all employees can thrive.

Americans with Disabilities Act (ADA) Statement

We are committed to full compliance with the Americans with Disabilities Act (ADA) and all applicable state and local disability laws. Reasonable accommodations are available to qualified applicants and employees with disabilities throughout the application and employment process. Requests for accommodation will be handled confidentially. If you require assistance or accommodation during the application process, please contact us at [email protected].

Pay Transparency Statement

We are committed to pay transparency and equity, in accordance with applicable federal, state, and local laws. Compensation for this role will be determined based on skills, qualifications, experience, and market factors. Where required by law, the pay range for this position will be disclosed in the job posting or provided upon request. Additional compensation information, such as benefits, bonuses, and commissions, will be provided as required by law. We do not discriminate or retaliate against employees or applicants for inquiring about, discussing, or disclosing their pay or the pay of another employee or applicant, as protected under applicable law. Pay ranges are available upon request.

Background Screening Statement

Employment offers are contingent upon the successful completion of a background screening, which may include employment verification, education verification, criminal history check, and other job-related inquiries, as permitted by law. All screenings are conducted in accordance with applicable federal, state, and local laws, and information collected will be kept confidential. If any adverse decision is made based on the results, applicants will be notified and given an opportunity to respond.