BI Developer

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

The BI Developer will be responsible for designing, developing and administering BI analytic solutions using the Microsoft platform and tool stack. This will include reporting, dash boarding, and warehousing tasks and other related administrative and development tasks. In addition to strong technical and project management skills, this position will also be business facing and require excellent customer relationship management.

Job Description

Responsibilities:

• Design and develop enterprise and departmental BI Reporting and Analytics solutions
• Partner with senior management to understand and deliver performance insights and key analytics solutions.
• Lead, schedule, and troubleshoot technical implementations, from data definitions to models to end user reporting
• Build, mentor, and guide business intelligence team to provide BI technical solutions as well as actionable information.
• Write complex SQL (DAX) code and stored procedures to be utilized by applications, ETL and reports
• Develop and implement standard reporting using advanced SQL to manipulate large datasets
• Develop interactive analytics dashboards and visualizations using tools like Power BI and SSRS (Tableau nice to have)
• Work with a variety of data sources – SQL Server, Oracle, Flat files etc
• Gain subject matter expertise level knowledge in the company’s data and business processes
• Gather and document reporting requirements from customer meetings regarding report development and ad hoc requests
• Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment
  
  
  

Requirements:

Core analytics & data

• 6+ years hands-on with SQL and data modeling for analytics (star schema, SCD concepts).
• Power BI (primary) building enterprise-grade models and reports; Tableau experience nice to have.
• DAX proficiency and solid understanding of SSAS Tabular concepts (preferred).
  
  
  

Azure platform

• Azure Data Factory — expected: pipelines, data flows, parameterization, monitoring.
• Azure Synapse — expected: ELT patterns, SQL pools/Serverless, performance tuning.
• Experience with Azure Data Lake (ADLS) sources and secure access patterns.
  
  
  

Ecosystem & practices

• Familiarity with Agile/Scrum, Jira/Azure Boards; strong communication with product and business.
• Git/Azure DevOps for branching, pull requests, and basic CI/CD.
• Python scripting nice to have (automation, data prep).
  
  
  

Legacy/other

• SSRS and SSIS: nice to have / legacy support only (not primary focus).
• Experience integrating with Salesforce/VUE or API-driven sources is a plus.