Job Title : Cross-Enrollment Programmer (AWS)



Location: Raleigh NC



Duration: 11+months



Type: Contract



Job 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, The client started an initiative known as Cross-Program Enrollment. The Cross-Program Enrollment project aimed to identify individuals currently enrolled in the client programs that are likely eligible for more food related benefits.



Once these populations are identified, the client 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 Client 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 endusers.



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 crossenrollment 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.



Detailoriented 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.



Amount of Experience managing and implementing data/system integration projects.



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



Experience with the Software Development Life Cycle (SDLC).



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



Expert knowledge of data management and data modeling



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



Required:



Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum



Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment



Hands-on experiences with databases e.g., SQL, MYSQL, Oracle, etc



Strong technical experience, knowledge, and understanding of micro-services architecture



Experience with enterprise level cloud-based development, deployment, and auditing, including: PAAS, IAAS, and SAAS. (preferred)



Bachelor's degree in Computer Science, Computer Information Systems, Computer Engineering, or other related technical degree



Experience in managing and implementing data or system integration projects.



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.



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



Programming experience in SQL (Ideally PostgreSQL)



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



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



Knowledge of data warehousing/architecture. Detailoriented with a focus on delivering high-quality work



Ability to directly interact with key internal customers effectively