Description

The NC Department of Health and Human Services is seeking a contractor to assist with the implementation and maintenance of data extracts, ETL batch jobs, and reports for NC Families Accessing Services through Technology (NC FAST) using the Cúram Software product and Oracle. The selected candidate will analyze and identify reporting requirements for the NC FAST Case Management System and implement recommendations to effectively report data of mid to high-level complexity. This role involves designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, while also enhancing existing data extracts and reports to meet ongoing business needs.

Company Culture and Environment

While specific cultural aspects are not explicitly mentioned, the role requires strong collaboration and partnership development with customers, indicating a team-oriented and responsive work environment.

Career Growth and Development Opportunities

There are opportunities for the selected candidate to lead and mentor the team, suggesting potential for professional development and leadership growth within the organization.

Detailed Benefits and Perks

The job description does not explicitly outline benefits and perks; however, the opportunity to work within a significant government department suggests potential job stability and public service benefits.

Compensation and Benefits

• Competitive compensation based on experience
• Potential for benefits related to public service work (not explicitly detailed in the description)

Why you should apply for this position today

This role offers a chance to make a meaningful impact on public service through data management and analysis, providing vital services to families in North Carolina. Working with advanced technologies and methodologies, you will be part of a mission-driven team.

Skills

• Experience in using Oracle, Oracle Utilities, and ETL tools
• Proficiency in PL/SQL scripting and Relational Database modeling
• Familiarity with structured system development methodologies
• Strong relationship-building skills with a sense of urgency to meet customer needs
• Ability to organize, prioritize, and follow detailed technical procedures
• Experience with Business Intelligence tools such as Business Objects or BIRT
• Knowledge of Agile development methodologies (Scrum, Kanban, or SAFe)
• Data Warehouse experience
• Proficiency in developing dashboards with Power BI and Azure Synapse
• Leadership and mentoring abilities
• Familiarity with Amazon RedShift and Tableau
• Experience with Dell Boomi

Responsibilities

• Analyze and implement reporting requirements for NC FAST Case Management System
• Develop complex queries against large tables storing CLOBS/XML
• Document requirements for new and existing data extracts and reports
• Write effective SQL queries for optimal performance
• Analyze existing queries and reports to fix issues and ensure data integrity
• Develop and analyze operational performance metrics and reports
• Provide 24x7 on-call support/rotation

Qualifications

• Proven experience in data management and reporting
• Strong understanding of data source interpretation and operational issue analysis
• Ability to work independently and collaboratively within a team

Education Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field (preferred but not explicitly stated)

Education Requirements Credential Category

• Bachelor’s degree (not explicitly mentioned but inferred as educational background)

Experience Requirements

• Relevant experience with Oracle and ETL tools, PL/SQL scripting, and Business Intelligence tools
• Experience with Agile methodologies
• Familiarity with data warehousing and dashboard development

Why work in Raleigh, NC

Raleigh, NC offers a vibrant community with a rich cultural scene, excellent educational institutions, and a growing technology sector. The city provides a welcoming environment for professionals, along with access to numerous recreational and outdoor activities, enhancing both personal and professional lifestyles.