Job Title: Senior Database Programmer

Location: Raleigh, NC (100% Remote)

Duration: 12+ Months Contract

Note: ****This is a remote position. The equipment can be shipped if the candidate is not local.

Responsibilities and Skills:

Job ID: 717164

Location: Raleigh, NC (NCDHHS-CIO)

Duration: 11 months

Skills:

Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum Nice to have
Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment Nice to have
Hands-on experiences with databases e.g., SQL, MYSQL, Oracle, etc. Nice to have
Strong technical experience, knowledge, and understanding of micro-services architecture Nice to have
Experience with enterprise level cloud-based development, deployment, and auditing, including: PAAS, IAAS, and SAAS. (preferred) Required 7 Years
Bachelor’s degree in Computer Science, Computer Information Systems, Computer Engineering, or other related technical degree Required 4 Years
Experience in managing and implementing data or system integration projects. Required 8 Years
Data architecture and data modeling experience including best practices and impact analysis. Required 5 Years
Excellent problem-solving and analytical skills. Required 7 Years
Experience in data mining, structuring, and analyzing information. Required 7 Years
Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. Required 7 Years
Ability to manage multiple priorities and work in a fast-paced environment. Required 7 Years
Programming experience in SQL (Ideally PostgreSQL) Required 5 Years
Detail-oriented with a focus on delivering high-quality work. Required 7 Years
Familiarity with healthcare or social services systems and/or programs is a plus Nice to have
Knowledge of data warehousing/architecture. Detail-oriented with a focus on delivering high-quality work Nice to have
Ability to directly interact with key internal customers effectively Nice to have

Description:

In 2021, the USDA ranked North Carolina 17th nationally in food insecurity. The USDA estimated that 10.9% of North Carolina’s residents are food insecure. To help respond to this challenge, North Carolina’s Department of Health and Human Services (NC DHHS) started an initiative known as Cross-Program Enrollment. The Cross-Program Enrollment project aimed to identify individuals currently enrolled in NC DHHS programs that are likely eligible for more food related benefits.

Once these populations are identified, NC DHHS conducts various outreach efforts to encourage these individuals to apply for the additional benefits they may be eligible for. The primary goal of this effort is to grow enrollment in the Women, Infants, and Children (WIC) program as well as the Food and Nutritional Services (FNS) and consequently provide more food benefits to food insecure residents across North Carolina.

Job Summary:

The NC DHHS Information Technology Division is seeking a Cross-Enrollment Programmer to manage the development and maintenance of the cross-enrollment data solution within the department. This role will collaborate with various stakeholders to design, develop, test, and implement changes and upgrades to the cross-enrollment solution including the integration of new data sources across the different health and human services programs.

The candidate will coordinate across business, IT and data teams to manage all technical aspects of the work in collaboration with the Data Office, Programmatic Technical Teams, Programmatic Business Leads and the Project Manager. This role will work with a range of stakeholders including developers, data architects, business intelligence dashboard developers, business stakeholders, subject matter experts and end-users.

This role will contribute towards improving the efficiency and effectiveness of providing critical services such as SNAP, WIC and Medicaid to the residents of North Carolina.

Key Responsibilities:

• Collaborate with cross-functional teams, including business analysts, project managers, and other programmers, to gather requirements.

• Develop, test, debug, and maintain software code to ensure smooth operation and functionality of cross-enrollment data solution.

• Validate cross-enrollment analysis model results on a regular basis and de-bug when needed in close coordination with the dashboard team.

• Serve as the cross-enrollment analysis model subject matter expert in business and design discussions.

• Integrate and interface existing systems and databases with system applications, ensuring data integrity and security.

• Participate in system and database design discussions, offering technical expertise and insights to optimize performance and scalability.

• Develop and execute test plans, conduct system testing, and troubleshoot issues to ensure high-quality deliverables.

• Perform code reviews and provide constructive feedback to maintain code quality and adherence to coding standards.

• Collaborate with stakeholders to identify and resolve technical issues and provide ongoing support for cross-enrollment systems.

• Document technical specifications, system configurations, and user manuals to support effective system maintenance and knowledge transfer.

• Adhere to established development methodologies, coding standards, and quality assurance processes.

Position Requirements:

• 8 years of relevant work experience in managing and implementing data or system integration projects.

• Bachelor’s degree in computer science, information systems, or a related field. Relevant work experience may be considered in lieu of a degree.

• 5 years of programming experience in SQL (Ideally PostgreSQL)

• 5 years of data architecture and data modeling experience including best practices and impact analysis.

• Excellent problem-solving and analytical skills.

• Experience in data mining, structuring, and analyzing information.

• Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.

• Detail-oriented with a focus on delivering high-quality work.

• Ability to manage multiple priorities and work in a fast-paced environment.

Additional Requirements:

• Familiarity with healthcare or social services systems and/or programs is a plus.

• Knowledge of data warehousing/architecture.

• Experience with Amazon Redshift development

• Ability to directly interact with key internal customers effectively.

Skills

Skill Required/Desired Amount of Experience

Experience managing and implementing data/system integration projects. Required 8 years

In-depth understanding of data warehouse structures and relational databases. Required 5 years

Experience with the Software Development Life Cycle (SDLC). Required 5 years

Programming experience in SQL (ideally PostgreSQL), SAS, etc. Required 5 Years

Expert knowledge of data management and data modeling Required 5 years

Highly detail-oriented with excellent communication skills (written and verbal), problem-solving abilities, and strength in understanding and analyzing requirements to deliver solutions. Required 8 Years

Kind Regards.