Advanced Systems Design is seeking an Analytics Developer to provide technical and production support for applications and integrations using the Microsoft SQL Server platform, involving business intelligence, data analysis, reporting, and implementing solutions through a structured SDLC.
Requirements
- 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
- Ability to write and optimize complex SQL queries
Responsibilities
- Develop applications and integrations using the Microsoft SQL Server platform
- Provide technical and production support
- 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
- Develop and maintain interactive dashboards and reports using Power BI
Other
- This position is on-site in Montgomery, AL, and requires in-person availability starting day 1.
- Master's degree in computer science, Information Systems or other related field. Or equivalent work
- Excellent communication and collaboration skills.
- Preferred experience in health care, Medicaid, or health insurance
- background investigation
- drug screening
