Data Integrations Developer, Senior

Acentra Health exists to empower better health outcomes through technology, services, and clinical expertise. Our mission is to innovate health solutions that deliver maximum value and impact.

Lead the Way is our rallying cry at Acentra Health. Think of it as an open invitation to embrace the mission of the company; to actively engage in problem-solving; and to take ownership of your work every day. Acentra Health offers you unparalleled opportunities. In fact, you have all you need to take charge of your career and accelerate better outcomes - making this a great time to join our team of passionate individuals dedicated to being a vital partner for health solutions in the public sector.

Acentra seeks a Senior Data Integrations Developer to join our growing team.

Job Summary:

As a Senior DataStage Data Integration Developer, you will work on a team responsible for the analysis, design, development of conversion programs, Data Warehouse, and unit/ integration testing of the developed programs satisfying the project requirements and business rules for large MMIS (Medicaid Management Information System) systems.

Job Responsibilities:

• Collaborate w/technical teams and functional leads for all aspects of data conversion requirements to develop conversion blueprint(s), data migration plan, data design, facilitate development, testing, and execution
• Develop and modify complex database applications based on requirements using specific Extract Transform & Load (ETL) integration tools (Infosphere Datastage)
• Design programs and systems that match the complex Medicaid business requirements and record all the specifications that are involved in the development and coding process
• Create models and process flow diagrams after analyzing business/user needs in the design specification document
• Capture key business requirements and specifications for each module of the application and develop pseudocodes accordingly
• Use Dimensional Modeling Techniques (Star Schema and Snow Flake Schema) to create and identify Dimensions, Cubes and Fact tables.
• Work on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions) Type 1 and Type 2
• Support the data conversion team in data analysis leveraging legacy data sets and provide the results of the analysis to the client / internal teams and other teams as needed
• Accelerate legacy data corrections and/or formalization of business rules for effective data migration
• Create and maintain artifacts as needed by the project
• Participate in technical / functional reviews and ensure the conversion artifacts comply with Acentra data conversion standards and practices
• Assist conversion / migration team to perform thorough unit testing of conversion artifacts and ensure smooth transition to system test, user acceptance test, and implementation
• Conducting the conversion sessions with business owners and technical teams, reviewing the corresponding conversion mapping rules, and documenting the resolutions.
• Experience in DataStage Server setup (Installation and upgrade), configuration, administration, migration, Conversion code backup and maintaining the versions.
• Experience in conversion sprint planning based on the conversion/Data warehouse scope and creating the stories and Tasks in the JIRA. Tracking and maintaining by daily scrum and weekly sprint meetings.
• Conducting the code review meetings with conversion/Data Warehouse Team members.
• Responsible for tracking conversion/ Data Warehouse development and resolving any roadblocks for developers.
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules.

Required Qualifications/Experience:

• Bachelor's degree with a minimum of 7+ years of relevant work experience; preferred majors: Computer Science, Information Systems, or a closely related field
• 6+ years of hands-on experience performing data migrations of mainframe and relational data, including identifying and analyzing source data, transforming source data into the required format, loading the transformed data into the target system, and validating all source data is tracked and transformed
• 5+ years hands on experience with IBM DataStage tool for data migrations
• 3+ years demonstrated skills working with Oracle SQL, PL/SQL and Shell scripting and relational database concepts
• 2+ years' government MMIS (Medicaid Management Information system) implementations experience
• Proven track record in conversion development and cut over experience across all stages of software development life cycle (SDLC) and software testing life cycle (STLC)
• Demonstrates analytical skills and thinking to resolve technical issues in conversion

Why us?

We are a team of experienced and caring leaders, clinicians, pioneering technologists, and industry professionals who come together to redefine expectations for the healthcare industry. State and federal healthcare agencies, providers, and employers turn to us as their vital partner to ensure better healthcare and improve health outcomes.

We do this through our people.

You will have meaningful work that genuinely improves people's lives across the country. We are a company that cares about our employees, and we give you the tools and encouragement you need to achieve the finest work of your career.

Benefits

Benefits are a key component of your rewards package. Our benefits are designed to provide you with additional protection, security, and support for both your career and your life away from work. Our benefits include comprehensive health plans, paid time off, retirement savings, corporate wellness, educational assistance, corporate discounts, and more.

Thank You!

We know your time is valuable and we thank you for applying for this position. Due to the high volume of applicants, only those who are chosen to advance in our interview process will be contacted. We sincerely appreciate your interest in Acentra Health and invite you to apply to future openings that may be of interest. Best of luck in your search!

~ The Acentra Health Talent Acquisition Team

Visit us at https://careers.acentra.com/jobs

EEO AA M/F/Vet/Disability

Acentra Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability, status as a protected veteran or any other status protected by applicable Federal, State or Local law.

Compensation

The pay for this position is listed below.

"Based on our compensation philosophy, an applicant's position placement in the pay range will depend on various considerations, such as years of applicable experience and skill level."