West Suburban Medical Center Developer Consultant in Frisco, Texas

Developer Consultant (Job Number: 1605050223)


As a part of the Tenet and Catholic Health Initiatives family, Conifer Health Solutions is a leading healthcare business process management services provider working to improve operational performance for more than 600 clients so they can support financial improvement, enhance the patient experience, and drive value-based performance. Through our revenue cycle management, patient communications, and value-based care solutions, we empower healthcare decision makers—hospitals, health systems, physicians, self-insured employers, and payers—to better connect every point of care and wellness management.  Are you ready to be part of our solutions?  Welcome to the company that gives you the resources and incentives to redefine healthcare services, with a competitive benefits package and leadership to take your career to the next step!
The Data Warehouse Developer IV (Lead/Consultant) will be a critical team member for the build out of both enterprise data capabilities and the delivery of key customer commitments surrounding Conifer Value Based Care’s Population Health, Clinical Informatics & Financial Risk Management data sets.
The Data Warehouse Developer IV (Lead/Consultant) will be primarily responsible for hands on technical delivery of 1) Reference, Master, Metadata and Modeling competencies 2) Database Warehouse Development and Integration & secondarily be an active participant in the build out of Conifer Value Based Care’s 4) Data Security, 5) Data Quality competencies.
Primary Competencies
As a part of a team, the Data Warehouse Developer IV (Lead/Consultant) will be primarily focused on the following two areas:
Reference, Master, Metadata Management & Modeling
  • Develop a unified approach for managing Master data and developing associated solutions
  • Engage business owners to define Reference, Master, and Metadata (e.g., dictionary, data architecture, standards)
  • Ensure the development of capabilities to enable easy access to high quality, integrated Reference, Master and Metadata
  • Assist the business with operational data definitions (e.g., data modeling, table & index design, DB design)
  • Support the business by leading analytical data designs (e.g., dimensional modeling, DW table & index design, DW database design)
  • Design physical data constructs (e.g., converting ERD/dimensional models to table design, indexing, physical storage constructs, DDLs)
  • Build Data Modeling competency to document data content from numerous enterprise sources. Includes clearly document data mappings across disparate systems, source and target data models. Define tools, processes and competencies required to store, update and provision.
  • Manages the flow of information between departments through the use of relational databases.
  • Maintains data integrity by working to eliminate redundancy. Stays informed of the ways the organization uses its data. 
  • Must have deep, practical experience with building data models that support all facets of IT disciplines with a focus on Data Warehousing and Business Intelligence.  This resource must be able to communicate with various levels of personnel (both technical and business) and have a deep understanding of the data required to support the Conifer business.  This person should be continually evaluating emerging data modeling best practices and integrate these within Conifer.
Data Warehouse Development and Integration
  • Define and develop a data warehousing architecture strategy, design and incremental roadmap that overcomes current challenges and appropriately meets current and future analytic needs.
  • Develop and implement a comprehensive data repository and storage architecture including solutions for data sourcing, data integration & staging, data hub (data warehouses, stores, marts, lakes, etc.), data privacy, reporting/analytics/views, data quality & governance.
  • Design, implement, and maintain data repositories as defined.
  • Define and implement clear guiding principles and an integration reference model to enable agile, secure and timely integration of data.
  • Develop programs that integrate data sources into the ecosystem.  This person uses ETL (extract, transform, load) and ELT (extract, load, transform) techniques to move data from various sources systems.  They should have expertise in one or more of the data integration tools in use at Conifer (SSIS, Alteryx).  They should have hands-on experience in loading data to different structures including Hadoop, relational and star-schema.  
  • Have the ability to design and build complex data integrations across a number of technologies and database platforms.  They should be continually researching emerging trends and best practices relating to data integration and integrate these into the organization. 
  • This person will set the overall standards for data integration solutions that will be followed by all other data integration engineers.
  • Design and build data services to support business requirements, and adhere to comprehensive, standardized, flexible and scalable data integration architectural models.
  • Ensure data services align to an established overarching integration strategy and data services model, and enable a Service Oriented Architecture where appropriate.
Secondary Competencies
As a secondary competency, the Data Warehouse Developer IV (Lead/Consultant) will work with a team to:
Data Security
  • Define the roadmap for and implement enterprise tools and processes to provide consistent authentication, authorization, access and auditing of data access across applications.
  • Create a comprehensive inventory of PHI or confidential information
  • Define & implement a strategy, tools and technology roadmap for:


  • Event Logging for Data Asset Management
  • User Authorization, Authentication, Access and Audit, including standard role definition – Identity Management
  • Vulnerability Scanning and Monitoring
  • Rollout and support data masking across non production and production environments.


Data Quality
Develop and execute standard data quality processes for audit, validation, standardization, enrichment and cleansing of data
Ensure continuous and incremental improvement of data quality over time
Validate and ensure adherence to corporate data security policies
Include the following. Others may be assigned.
  • Reference, Master, Metadata Management & Modeling 40%
  • Data Warehouse Development and Integration 40%
  • Data Security 10%
  • Data Quality 10%
If direct report positions are listed below, the following responsibilities will be performed in accordance with guidelines, policies and procedures and applicable laws. Supervisory responsibilities include interviewing, hiring, and training employees; planning, assigning and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems.
  • Direct Reports N/A
  • Indirect Reports N/A


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Successful background as an architect and/or technical lead on an Enterprise Data Warehouse or Enterprise Information Management team
  • Full life cycle experience creating, maintaining and enhancing physical database structures.
  • Deep understanding of relational theory.
  • Extensive experience working with relational or OLAP database: Oracle, SQL Server, DB2, Teradata, Netezza
  • Extensive knowledge of Relational Database Design, Dimensional Database Design, Semantic Web Design, and Cloud data storage and analytics
  • Strong Data Modeling and data analysis skills (Erwin, ER Studio, UML, PowerDesigner, etc.). · Ability to apply modeling standards to logical and physical ERDs
  • Experience with data modeling concepts (conceptual/logical/physical/semantic, multi-dimensional models (star, snowflake), normalized/denormalized models)
  • Knowledge  of source control tools (e.g. GitHub) 
  • Extensive knowledge of ETL and Data integration techniques; SSIS and Alteryx preferred
  • Strong experience with Microsoft products (SSIS, SSRS, OLAP, OLTP and SQL Server)
  • Work independently and with Business Analysts and SMEs to gather, document and explain requirements
Include minimum education, technical training, and/or experience preferred to perform the job.
  • Bachelor’s degree in computer science, engineering or management information systems
  • 7+ years of experience as a Data Architect
  • 9+ years of DBA experience managing enterprise-level database environments.
  • 9+ years of DBA experience with SQL Server and / or Hadoop (or acceptable similar database management systems)
  • 9+ years of DBA experience with managing data warehouses, data marts, cubes and big data
  • 7+ years of experience with implementing data models to support Business Intelligence and Data Warehousing projects.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Must be able to work in sitting position, use computer and answer telephone
  • Ability to travel
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Office Work Environment
  • Approximately 25% travel may be required  
At our campus, our purpose at Conifer Health is to provide the foundation for better health – the health of our clients, the communities in which we work and serve, and most importantly each other. That is why we will be tobacco-free, meaning there will be no designated smoking areas or use of any tobacco, nicotine or smoking products on the premises.

Primary Location: TX-Frisco

Organization: Conifer Value Based Care