Azure Data Engineer

Clearwater, SC - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

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

Were looking for a highly skilled Data Engineer to design build and run robust data pipelines that power enterprise-wide analytics and reporting. Youll 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 .

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.

Our CompanyExplore 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 agen...