A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Founded in 2005, The Michigan Data Collaborative is a data collection, enrichment and delivery team created to provide a neutral and secure location for large, longitudinal population healthcare data to be aggregated, analyzed, and reported for the purposes of supporting statewide care transformation efforts and health services quality improvement.

The Data Architect will be responsible for information architecture and data flow processes for MDC data integration and warehousing operations.  This will include data modeling, conversion, and validation, as well as overseeing and performing ETL and data extract tasks.

Design and Development:  Design overall data collection, check, and conversion process.  Define technical architecture and environment, including bringing in appropriate technologies and tools to accomplish the process requirements.  Define development plans, determine work assignments required to implement the plan, and oversee the execution of implementation and testing tasks.  Review, understand, and document the current operational and data maintenance processes to establish support for current and future analytic and reporting capabilities. Develop requirement and specification documentation for data mapping and data transformation processes.

Data Management, Build, and Maintenance:  Collect, analyze, edit check, load, maintain, refresh, and extract data into data structures (databases, data warehouses, data marts).  Create and maintain ETL workflows to create derived data fields and tables. Identify and analyze incoming data sources, assess data quality and fit for use, and define processes and procedures to load data into data structures.  Define and document input data formats and layouts.  Provide input and guidance into and schema database design.  Plan for appropriate data updates, archival and backup procedures, and extractions.  Define and execute workflow of moving data from the database into statistical and analytical systems.

Requirements Gathering:  Work closely with analysts, application developers, and customers to define and understand business needs which will be met by measures, reports, and analysis based on the data collected and loaded into data structures.  Translate the requirements into data specs and design data structures which will meet those needs.  Develop and execute procedures to ensure data needs of projects are met.

Communication:  Communicate status of work to project leadership and team members.  Contribute knowledge of industry, data, issues, and information across the team and to customers.  Participate in strategic planning for approved projects and research, and evaluate technical solutions for new development and ongoing issues.

• Bachelor's degree in Computer Science, Information Systems, or an equivalent combination of education and experience
• 3-5 years experience working with Informatica or equivalent ETL application
• 5+ years of experience in the healthcare industry, preferably in the state of Michigan, with either Payer or Provider organizations, or consulting organizations working with Payers and/or Providers
• Experience working with various healthcare data suppliers and defining data mapping for healthcare data fields
  
  5 or more years of experience in:
  • Designing, developing, and building data structures for databases, data warehouses, and/or data marts
  • Collecting and loading data into data structures, including familiarity with different storage methods for data which changes over time; expertise in defining and assessing input data formats and layouts
  • Maintaining and refreshing data loaded into data structures
  • Performing data quality analysis and edit checking, and assessing fit for use
     
• Knowledge of chronic disease definitions and research
• Experience working with healthcare data types (claims, enrollment, clinical, pharmaceutical, and others)
• Experience working with healthcare data cost/quality methodologies and measures such as Episode Groupers, Inpatient Admission build processes; risk scoring, standard costing, HEDIS and NCQA specifications, DRG/MDC classifications, and others
• Familiarity with healthcare procedure and diagnosis (ICD-9 & 10, CPT-4, HCPCS) coding systems
• Experience working with regulated healthcare data, including patient-identifiable, PHI, and data covered under HIPAA provisions
• Experience in working with analysts, end users, and customers to identify and understand healthcare information requirements and translating them into data structures which will support those needs
• Experience in establishing data structure standards, separate development/test/production environments, and a database development and release process
• Experience developing and maintaining internal documentation and specifications for data load, test, extract, maintenance, and refresh procedures and processes
• Experience with documenting and analyzing workflow and data management processes as well as creating solutions to support these processes
• Proven track record of delivering data projects on time and fit for use
• Solid and effective written, interpersonal, oral communication, and presentation skills
• Strong organizational skills with attention to detail
• Excellent analytical and problem-solving ability
• Ability to work effectively on a team
• Willingness and strong aptitude to learn new technologies and assume responsibilities
• Ability to work in a dynamic development environment and adjust to changing priorities, processes, and project plans

• Experience working with BI tools such as Tableau, Business Objects, and/or Crystal Reports
• Experience in using SQL to query Oracle databases
• Knowledge of population management, evidence-based care reporting, healthcare cost and utilization reporting, and patient centered medical home concepts
• Knowledge of the UM computing environment

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings.  Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

Job openings are posted for a minimum of seven calendar days.  The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.

The University of Michigan is an equal opportunity/affirmative action employer.