Location: Albany,NY, USA
Grounded by a compelling mission, core values, and compassion for people, CDPHP and its family of companies offer a strong foundation for a rewarding career. Established in 1984, CDPHP is a physician-founded, member-focused, and community-based not-for-profit health plan that offers high-quality affordable health insurance to members throughout New York. The company values people, quality, innovation, and community, and its corporate culture supports those values wholeheartedly. CDPHP is committed to fostering a culture of belonging and takes a wholistic approach to diversity, equity, and inclusion. 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 Data Modeler is responsible for data system structures, engineering, standards, and the evaluation/implementation of new data organization. The Data Modeler designs data solutions for teams to visualize and consume data in a framework that can be utilized by data scientist, engineers, or data analysts. The Data Modeler partners as a team member with the Platform Leaders, IT Delivery Leads, Project Managers, Application Architects, Infrastructure Architects, DBA s, Infrastructure Engineers, Infrastructure Operations and Functional Leads to support delivery of complete solutions.QUALIFICATIONS:Associates degree required or two (2) years of equivalent experience required.Relevant field of degree in Computer Science, Business, or Data ScienceMinimum of three (3) years with RDBMS metadata and SQL (PL/SQL, TSQL) required.Minimum of three (3) years with writing, debugging and performance tuning SQL required.Minimum one (1) year of data modeling experience required.Minimum one (1) year of Extract Transform Load (ETL) using Informatica preferred.Three (3) years of data modeling and use of related tools such as Erwin or Power designer preferred.Hands-on experience data modeling with cloud database systems (ex: Redshift or Snowflake) or cloud data lake/lakehouse systems is preferred.Experience in a healthcare environment preferred.Broad understanding of functional business processesGood understanding of database design and dimensional modeling principlesGood understanding of data warehouse design and modeling methodologyDemonstrated understanding of metadata management and data governanceExcellent communication, both written and verbalExcellent facilitation skillsShould be known as an agent of changeCDPHP 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 at .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 Strategic Solutions Management Consultants (SSMC), Practice Support Services (PSS), and ConnectRx Services, LLC.