Job Details

Analytics Developer

Job Summary: We are seeking an SQL Server Developer with strong expertise in SQL Server, ETL processes, and Power BI. This role will focus on application development, analytics support, and business intelligence reporting, ensuring robust data solutions that support health systems, finance, and Medicaid operations. The position requires 100% onsite work in Montgomery, AL.

Key Responsibilities:

Analytics & Support (5+ years)

• Provide analytics support for Health Systems, Finance, and the Analytics Division.
• Collaborate with project managers, team leads, analysts, and other agency staff.

Report & ETL Development (3+ years)

• Design, build, and maintain ETL packages using Microsoft SQL Server Integration Services (SSIS).

Application Development (3+ years)

• Lead the development and implementation of applications related to budgeting, STARRS, and other accounting systems.

SQL Development (8+ years)

• Write and optimize complex SQL queries for quality measures across multiple databases.
• Develop and maintain stored procedures, triggers, functions, and views.
• Create scripts for database objects and deploy SQL patches.

Database Management (3+ years)

• Support schema design, query optimization, and code reviews.
• Manage schema upgrades and data quality improvements.

Power BI Reporting (3+ years)

• Build and maintain interactive dashboards and reports using Power BI.

Required Skills & Qualifications:

• Masters degree in Computer Science, Information Systems, or related field (or equivalent work experience).
• Proven expertise in Microsoft SQL Server, SSIS, and Power BI.
• Strong knowledge of relational databases and data modeling.
• Experience with the SDLC and agile methodologies.
• Excellent communication and collaboration skills.

Preferred Skills:

• Experience in healthcare, Medicaid, or health insurance environments.