Business Intelligence Developer – Medicaid, Level I

This is a fully remote position, open to applicants in Arizona.

📋 Description

• Design, develop, and manage reporting and data analysis for financial or clinical outcomes, network performance, care management, claims processing, operations, medical costs, utilization, authorization, risk adjustment, and claims data.

• Create sustainable reporting solutions and analytical insights that enhance efficiency, foster innovation, and support data-driven decision-making within the Medicaid segment.

• Design and code foundational queries and datasets utilizing structured programming techniques, reporting platforms, and relevant programming languages.

• Monitor, maintain, update, and distribute regularly scheduled standard reports and data extracts.

• Engage in small projects of basic complexity.

• Collaborate with business partners and subject matter experts to gather requirements under mentorship.

• Design, develop, and maintain dashboard visualizations using Tableau, Qlik Sense, Power BI, and other BI applications.

• Develop work plans, implement unit test plans, and track and resolve processing issues with guidance.

• Review code and reporting/analysis for design standards, accuracy, content, functionality, and compliance.

• Generate documentation to support reporting and analysis activities.

• Participate in the Systems Development Life Cycle (SDLC), corporate quality initiatives, and data governance programs.

• Adhere to source control versioning policies and procedures.

• Implement and uphold operational and disaster-recovery procedures.

• Communicate work status effectively to stakeholders and management.

• Stay updated on technology-related developments.

• Report to a lead, supervisor, or manager while receiving general supervision.

⛳️ Requirements

• 2 years of experience in data, report development, and analysis in a professional environment.

• 1 year of experience in query design and effective reporting design structure.

• High School Diploma or GED in a relevant field of study.

• Intermediate proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and Redgate.

• Intermediate knowledge of Microsoft SQL Server, SQL databases, table/view/stored procedure development, query optimization, enterprise data modeling, data normalization, and schema management.

• Familiarity with decision support systems, business intelligence, programming, and data analysis software.

• Knowledge of Qlik Sense, Qlik View, Tableau, and Power BI.

• Intermediate proficiency in Microsoft Excel, Power Pivot, external connections, DAX/MDX, and Visual Basic.

• Intermediate proficiency in Microsoft Office Suite, including Outlook, Teams, Excel, Word, Access, and PowerPoint.

• Functional proficiency in requirements analysis and gathering, scoping, and project management.

• Basic proficiency in data mining, preferably in a healthcare context.

• Basic proficiency in general data analysis.

• Functional proficiency with the Systems Development Life Cycle (SDLC).

• Functional proficiency in documenting project requirements, development, and status tracking in an IS environment.

• Excellent written and verbal communication skills.

• Strong critical thinking, problem-solving, and analytical abilities.

• Capability to complete tasks with minimal supervision, manage substantial workloads, and prioritize multiple projects under deadlines.

• Ability to write and present business intelligence documentation.

• Knowledge of business requirements development and user acceptance testing.

• Ability to maintain confidentiality and privacy.

• Residency and work performed within the State of Arizona.

🏝️ Benefits

• Remote work opportunity available within the State of Arizona.

• Flexible work arrangements through AZ Blue’s Workability workforce strategy.

• Full-time employment schedule of at least 40 hours per week.

• Health insurance products and services provided by AZ Blue.

• Opportunities for mentorship and professional development through training and peer review.