To be successful in this role, you :
- Hold bachelor's degree in computer science, Management Information Systems or an equivalent combination of education and highly relevant experiences required.
- Have a minimum of five (5) years of experience with dimensional data warehouse design for healthcare data, preferably with managed care organizations (MCOs) or / and commercial payers.
- Have a minimum of three (3) years of experience years with database modeling, data pipeline development and cloud data warehouse development, preferably within healthcare data domain.
- Have a minimum of three (3) years of experience with Master Data Management and relevant experience with Data Fabric and / or Data Mesh architectures.
- Have a minimum of three (3) years of experience with metadata and data governance practices.
Essential functions and Roles and Responsibilities :
Leads and oversees Data analysts, Business Analysts and Data Product managers responsible to write and maintain documentation of the ETL processes via process flow diagrams, data profiling and source to target mappings adhering to best practices.Acts as a liaison between business units, program management, analysts and developers, supporting various data ingestion projects, data management, data product enhancements, and self-service Data Hub initiativesMonitors deliverables and coordinate resource requirements to ensure timely completion of projects by promoting best practices, guide the team toward continuous improvement, and act as a consultative resource for internal business and technical staff.Applies approved Data warehouse architecture and design practices to translate business requirements into functional requirements and mapping design documents to build data pipelines moving data and metadata into Enterprise Data Warehouse and other Integrated managed data repositories.Performs Snowflake data modeling, with hands on experience in implementing data frameworks including ingestion, transformation, data quality checks, master data management, monitoring, alerts, notifications etc.Collaborates with vendors, data providers and business stake holders on new data acquisitions to ingest data by defining formats, filling data gaps, adjusting source-system data structures to facilitate integration with other organizational data.Educates end users of the warehouse by providing data warehouse design / schema information via educational sessions, in-person discussions, or instructional documents.Promotes the use of the warehouse by working with data stewards, data analysts, business solution analysts, and governance analysts to help end users understands data definitions, lineage, storage locations and access.Participates in data governance activities and ensure data security working closely with Database Administrators, Information security and Infrastructure teams.Leads and / or participates in design and code reviews.Provides application and operational support, fulfills assigned On-call duties.Provides mentorship, coaching and technical leadership to less experienced team members.Other duties as assigned. Essential functions listed are not necessarily exhaustive and may be revised by the employer, at its sole discretion.Knowledge, Skills, and Abilities :
Advanced knowledge of relational database concepts, dimensional data warehouse models, data warehousing methodologies, and major database management systems such as SQL Server, Snowflake, Azure SQL, AWS Redshift, GCP, Oracle, etc.In-depth understanding of enterprise data management concepts (Data Governance, Data Engineering, Data Lake, Data Warehouse, Data Sharing, Data Science and Data Applications)Ability to architect solutions for data ingest processes and pipelines using ETLWorks, SSIS, Qlik Compose, or other data integration tools such as Snowpipe, Fivetran, Azure Data Factory, AWS Glue and StreamSetsAbility to communicate effectively at all levels of the organization including senior level staff, external vendors, and external clinic staffAbility to create process documentation to include process flow charts, data modeling diagrams, architecture roadmaps and integrated solutionsStrong knowledge of different data architecture frameworks within both cloud and on-prem platformsIn depth working knowledge of cloud computing, preferably with Snowflake and AzureGood understanding of business operations, organization process workflows, and business prioritiesExperience in the use of agile or iterative-type software development lifecycles and techniques.Ability to organize tasks, timelines, and delivery schedules.As part of our hiring process, the following criteria must be met :
Complete and successfully pass a criminal background check.Criminal History : includes review of criminal convictions and probation. CHPW does not automatically or categorically exclude persons with a criminal background from employment. The applicant's criminal history will be reviewed on a case-by-case basis considering the risk to the business, members, and / employees.
Has not been sanctioned or excluded from participation in federal or state healthcare programs by a federal or state law enforcement, regulatory, or licensing agency.Vaccination requirement (CHPW offers a process for medical or religious exemptions)Candidates whose disabilities make them unable to meet these requirements are considered fully qualified if they can perform the essential functions of the job with reasonable accommodation.Compensation and Benefits :
The position is FLSA Exempt and is not eligible for overtime. Based on market data, this position grade is 71E and has a 10% annual incentive target based on company, department, and individual performance goals. Salary determined at offer will be based on labor market data and a candidate's years of relevant work experience and skills relevant to the position.
CHPW offers the following benefits for Full and Part-time employees and their dependents :
Medical, Prescription, Dental, and VisionTelehealth appFlexible Spending Accounts, Health Savings AccountsBasic Life AD&D, Short and Long-Term DisabilityVoluntary Life, Critical Care, and Long-Term Care Insurance401(k) Retirement and generous employer matchEmployee Assistance Program and Mental Fitness appFinancial Coaching, Identity Theft ProtectionTime off including PTO accrual starting at 17 days per year.40 hours Community Service volunteer time10 standard holidays, 2 floating holidaysCompassion time off, jury duty pay.Sensory / Physical / Mental Requirements :
Sensory
Speaking, hearing, near vision, far vision, depth perception, peripheral vision, touch, smell, and balance.Physical
Extended periods of sitting, computer use, talking and possibly standing.Simple grasp, firm grasp, fine manipulation, pinch, finger dexterity, supination / pronation, wrist flexion.Frequent torso / back static position; occasional stooping, bending, and twisting.Some kneeling, pushing, pulling, lifting, and carrying (not over 25 pounds), twisting, and reaching.Frequent kneeling, pushing, pulling, lifting, and carrying (not over 25 pounds), twisting, and reaching.Mental :
Ability to learn and prioritize multiple tasks at a given time and have the capability of handling demanding situations. Analytical / problem solving / critical thinking ability.Work Environment :
Office environment Employees who frequently work in front of computer monitors are at risk for environmental exposure to low-grade radiation.
Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
