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), utilizing the Cúram Software product and Oracle. The selected candidate will analyze and identify reporting requirements for NC FAST Case Management System reports while effectively reporting mid to high-level complexity data. The role involves designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, in addition to enhancing existing data extracts and reports to align with ongoing business needs.

The ideal candidate must understand the underlying data sources (databases) and interpret business requirements to analyze operational issues. This includes developing diagnostic and tracking data via reports and dashboards. Duties encompass gathering and documenting requirements for new data extracts and reports as well as modifications to existing ones, developing complex queries against large tables storing CLOBS/XML, and writing efficient SQL queries. The selected candidate will also analyze existing queries, fix issues, extract data, and develop operational performance metrics to ensure quality and integrity through validation and audit strategies. This position requires 24x7 on-call support/rotation.

Company Culture and Environment

While specific cultural aspects are not explicitly mentioned, the role’s focus on collaboration with various stakeholders suggests a culture that values teamwork and effective communication.

Career Growth and Development Opportunities

This position provides an opportunity to work with advanced technologies and methodologies within the health and human services domain, which can lead to further professional development and advancement in data management and analytics roles.

Detailed Benefits and Perks

The role offers a competitive W-2 rate, and the contractor will gain experience working within government projects that can enhance one’s resume and professional network.

Compensation and Benefits

• Up to $45/hour W-2 rate
• Opportunities for skill enhancement through hands-on work and complex projects
• Experience with government data solutions

Why you should apply for this position today

This is a unique opportunity to contribute to meaningful projects that directly impact public services. Working with the NC Department of Health and Human Services allows you to be a part of a team that plays a vital role in improving access to services for families in North Carolina.

Skills

• Strong proficiency in SQL and database management
• Experience with ETL processes and data extracts
• Knowledge of Cúram Software and Oracle
• Ability to analyze and document reporting requirements
• Proficiency in developing complex queries against large datasets
• Strong problem-solving skills and attention to detail

Responsibilities

• Assist with the implementation and maintenance of data extracts and ETL batch jobs
• Analyze and identify reporting requirements for NC FAST
• Design, code, test, debug, and document data interfaces and reporting solutions
• Enhance existing data extracts and reports
• Gather and document requirements for new and existing reports
• Develop and analyze operational performance metrics and reports
• Provide 24x7 on-call support/rotation

Qualifications

• Proven experience in data analysis and reporting
• Familiarity with ETL processes and SQL querying
• Ability to work collaboratively with diverse stakeholders
• Strong analytical and problem-solving capabilities
• Excellent documentation and communication skills

Education Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field

Education Requirements Credential Category

• Bachelor’s degree or equivalent work experience in data management or IT

Experience Requirements

• Minimum of 3 years of experience in data processing and reporting
• Experience working with large datasets and complex queries

Why work in Durham County, NC

Durham County, NC, is known for its rich history, vibrant community, and strong educational institutions, including Duke University. The area offers a unique blend of cultural experiences, outdoor activities, and a growing tech scene, making it an excellent location for both personal and professional growth.