Design, develop, and maintain Medicaid reporting solutions.
Requirements
- 5+ years’ experience with Oracle PL/SQL, SQL scripting, and relational database modeling.
- 5+ years’ experience with Oracle Utilities, OWB, or ODI.
- 5+ years’ experience designing large-scale web-based distributed systems.
- Demonstrated experience with Azure Synapse Analytics (SQL pools, pipelines, Spark pools).
- Experience with Python, PySpark, and SparkSQL on Azure Cloud.
- Experience configuring, designing, and testing Power BI dashboards.
- Strong SQL skills and experience optimizing queries for large datasets.
Responsibilities
- Design, develop, and maintain Oracle PL/SQL scripts and data warehouses for Medicaid reporting.
- Develop and maintain BIRT or other BI reports, leveraging IBM Curam framework data structures.
- Build analytics solutions using Azure Synapse, including serverless SQL pools, Synapse pipelines, and Spark pools.
- Utilize Python, PySpark, and SparkSQL on Azure Cloud for data processing and analytics.
- Configure, design, develop, and test Power BI dashboards for reporting and decision support.
- Lead and mentor other reporting developers on ETL design, error handling, and integration best practices.
- Troubleshoot defects and implement enhancements based on business backlog.
Other
- This is a 6month contract hrybrid role
- Follow structured system development methodologies and technical procedures.
- Collaborate with business teams to understand requirements and provide technical guidance.
- 5+ years’ experience with structured system development methodologies.
- Strong ability to organize, prioritize, and follow complex technical procedures.
