ETL Data Engineer

CDPHP and its family of companies are mission-driven organizations that support the health and well-being of our customers and the communities we are proud to serve. CDPHP was founded in Albany in 1984 as a physician-guided not-for-profit, and currently offers health plans in 29 counties in New York state. The company values integrity, diversity, and innovation, and its corporate culture supports those values wholeheartedly. At CDPHP, the employees have a voice and are encouraged to make an impact at both the company and community levels through engagement and volunteer opportunities. CDPHP invests in employees who share these values and invites you to be a part of that experience.

The ETL Data Engineer works as part of the Data Management team. ETL Data Engineer will develop data pipelines and ETL solutions; from data sources or endpoints of acquisition, to integrate or consume for specific use cases. These data pipelines are to be created, maintained and optimized as workloads, to move from development to production. Creating, building, and maintaining data pipelines will be the primary responsibility of the ETL Data Engineer. The ETL Data Engineer will collaborate with enterprise architects, data architects, cloud platform engineers, data scientists, and others involved in the product lifecycle to help refine data requirements and to ensure the most appropriate data pipelines and ETL logic are developed.

The ETL Data Engineer will be responsible for using innovative and modern tools, techniques and architectures to enable automation of the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity. The ETL Data Engineer will work with the Analysis team to define and estimate technical solutions, document functional specifications, and prepare test plans/scripts for application testing. In addition, will manage the deployment/CICD process and ensure successful implementation of business functionality being developed. The ETL Data Engineer will be responsible to develop and harden reusable and repeatable patterns and frameworks that can be transferred to and supported by the Operations team. They will also participate in on-call duties through a regular rotation schedule. They must be available 24/7 by cell phone for team support of critical production issues. The ETL Data Engineer will assist with peer code reviews, maintain standards and encourage use of best practices.

QUALIFICATIONS:

• Bachelor's degree required in an Information Management, Information Technology, Engineering or a related field, plus (3) years' experience or 5 years relevant experience may be substituted for degree.
• Minimum of three (3) or more years' hands-on experience with ETL/BI tools and relational database (normalized and dimensional) within a MS SQL Server or Oracle environment required.
• Minimum of one (1) years' experience with Non-relational data structures or Unstructured Data, Cloud or Big Data related technologies required.
• Minimum of three (3) or more years' experience in developing and/or maintaining enterprise level applications required.
• Proficient in ETL tools such as Informatica Powercenter/Cloud, writing stored procedures or creating AWS Lambda functions. Familiar with upcoming ETL variants such as AWS Glue.
• Familiarity with AWS cli, Powershell, Shell scripts
• Familiarity with AWS technologies like EMR/Lambda/S3/KMS/DynamoDB
• Familiarity in version control systems such as BitBucket/git
• Can work seamlessly in multiple flavors of OS such as Windows/Linux
• Familiarity with Informatica Cloud, Mulesoft Anypoint Platform or any hybrid integration tool
• Strong knowledge of systems analysis and writing program specifications required.
• Ensure team SLAs are being met and SDLC is followed.
• Ability to work with IT and business to formulate business and data requirements.
• Oracle, SQL Server, PL/SQL, Linux experience preferred.
• A good understanding of Data Warehouse concepts (including star schema) required.
• Demonstrated analytical experience and critical thinking skills.
• Effectively handles competing priorities.
• Knowledge of healthcare processes, rules, regulations, enrollment/eligibility guidelines and reporting requirements for HMO, PPO, ASO, Medicare, Medicaid, Family Health Plus and Child Health Plus preferred.

Annual salary range: $86,000 - $110,000

CDPHP salary ranges are designed to be competitive with room for professional and financial growth. Individual compensation is based on several factors unique to each candidate, such as work experience, qualifications, and skills. In addition to cash compensation, CDPHP employees may be eligible for an incentive payment, a discretionary cash reward based on employee and company performance. Some roles may also be eligible for overtime pay.

CDPHP compensation packages go far beyond just salary. The company offers a comprehensive total rewards package that includes award-winning health care coverage, health care dollars, a generous paid time off allowance, employee assistance programs, flexible work environment, and much more. Learn about all CDPHP employee benefits .

As an Equal Opportunity / Affirmative Action Employer, CDPHP will not discriminate in its employment practices on the basis of race, color, creed, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, transgender status, age, national origin, marital status, citizenship, disability, criminal record, genetic information, predisposition or carrier status, status with respect to receiving public assistance, domestic violence victim status, protected veterans status, or any other characteristics protected under applicable law. To that end, all qualified applicants will receive consideration for employment without regard to any such protected status.

CDPHP and its family of companies include subsidiaries Acuitas Health LLC, Strategic Solutions Management Consultants (SSMC), Practice Support Services (PSS), and ConnectRX Services, LLC.