Job ID: JOB_ID_6269
Job Summary:
North Carolina Families Accessing Services through Technology (NCFAST) is seeking a highly skilled Oracle PL/SQL and Microsoft Azure Synapse developer to provide business and system analysis, modeling, design, developing and maintaining Medicaid reporting solutions and semantic models. This role will work closely with NC FAST internal business team and Medicaid team to develop new reports and maintain the reporting code for some of the enhancements based on the backlog of change requests from the business and help fix some of the defects from the backlog as well.
Key Responsibilities:
- Develop and maintain reporting solutions and semantic models.
- Work closely with NC FAST internal business team and Medicaid team.
- Develop new reports based on business requirements.
- Maintain reporting code for enhancements and fix defects.
- Provide business and system analysis, modeling, and design.
Requirements:
- Strong understanding of relational databases (including tables, views, indexes, table spaces, users, grants).
- Strong experience in design, build, and manage data warehouses.
- 5 or more years of Oracle PL/SQL.
- Strong working knowledge of Business intelligence and reporting tool (BIRT) and the understanding of the underlying data and tables in IBM Curam framework for the product delivery cases and the financial part to support all kinds of reports for case workers.
- Strong working knowledge of building data analytics solutions using Azure Synapse serverless SQL pools.
- Demonstrated experience with Azure Synapse Analytics, including Synapse pipelines, SQL pools, and Spark pools.
- 1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud.
- Experience configuring, designing, developing, and testing dashboards using Power BI.
- Lead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurations.
Skill Matrix:
- Experience programming and design of large scale web based distributed systems: Required, 5 Years
- Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI): Required, 5 Years
- Experience with SQL scripting and Relational Database modeling: Required, 5 Years
- Experience with structured system development methodologies: Required, 5 Years
- Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options: Required
- Ability to organize, prioritize, and follow complex and/or detailed technical procedures: Required
- Prefer experience with Business Intelligence tools such as Business Objects or BIRT: Highly desired, 2 Years
- Prefer Data Warehouse experience: Highly desired, 2 Years
- Experience with the Cram product: Highly desired, 4 Years
- Strong SQL Skill: Highly desired, 2 Years
Special Requirements
Onsite, Webcam interview
Compensation & Location
Salary: $70,000 – $120,000 per year (Estimated)
Location: Durham, NC
Recruiter / Company – Contact Information
Recruiter / Employer: State of NC
Email: hwaz.a@cambaycs.com
Recruiter Notice:
To remove this job posting, please send an email from
hwaz.a@cambaycs.com with the subject:
DELETE_JOB_ID_6269