Analytics Developer,

The Analytics Developer is responsible for developing applications and integrations using the Microsoft SQL Server platform, while also providing technical and production support. This role involves business intelligence, data analysis, reporting, requirements gathering, testing, monitoring, and implementing solutions through a structured Software Development Life Cycle (SDLC). The developer will provide analytics support, build and maintain ETL packages, lead software development related to budgeting and accounting systems, write SQL code, develop database objects, assist with schema design, and create Power BI dashboards.

Location: Alabama, N/A, United States,

Responsibilities:

- Provide analytics support to Health Systems, Finance, and the Analytics Division.
- Participate in meetings with project managers, team leads, analysts, and other agency staff.
- Build and maintain ETL packages using Microsoft SQL Server Integration Services (SSIS).
- Lead development and implementation of software related to budgeting, STARRS, and other accounting systems.
- Write accurate SQL code for quality measures with a strong understanding of various databases.
- Develop and maintain stored procedures, functions, packages, triggers, and views.
- Create scripts to build new database objects and deploy SQL patches.
- Assist with schema design, code reviews, and SQL query optimization.
- Support application schema upgrades and data improvements.
- Develop and maintain interactive dashboards and reports using Power BI.

Required Skills & Certifications:

- Master's degree in computer science, Information Systems or other related field or equivalent work experience.
- 5 years' experience in Analytics & Support
- 3 years' experience in Report & ETL Development
- 3 years' experience in Application Development
- 8 years' experience in SQL Development
- 3 years' experience in Database Management
- 3 years' experience in Power BI Reporting
- Proven experience with Microsoft SQL Server, SSIS, and Power BI.
- Strong understanding of relational databases and data modeling.
- Ability to write and optimize complex SQL queries.
- Experience with software development lifecycle and agile methodologies.
- Excellent communication and collaboration skills.

Preferred Skills & Certifications:

- Experience in health care, Medicaid, or health insurance

Special Considerations:

- Candidate will work 100% in Montgomery AL Main Office.
- No remote work allowed.
- Candidates must be eligible to work in the United States without the need for sponsorship.
- This role does not offer sponsorship.
- No expense reimbursements will be approved.

Scheduling:
- Not specified.