Truven Health Analytics delivers unbiased information, analytic tools, benchmarks, and services to the healthcare industry. Hospitals, government agencies, employers, health plans, clinicians, and pharmaceutical and medical device companies have relied on us for more than 30 years.
Truven Health Analytics, formerly the Healthcare business of Thomson Reuters, delivers unbiased information, analytic tools, benchmarks and services to the healthcare industry. Hospitals, government agencies, employers, health plans, clinicians, and pharmaceutical companies have relied on our solutions for over 30 years. Truven Health Analytics combines deep clinical, financial and healthcare management expertise with innovative technology platforms and information assets to make healthcare better, collaborating with customers to uncover and realize opportunities for improving quality, efficiency, and outcomes. Truven Health Analytics employs approximately 2,200 people worldwide and has principal offices in Ann Arbor, Chicago and Denver. For more information, please visit http://www.truvenhealth.com/.
Designs relational databases following industry best practice. Develops strategies for data warehouse implementation following industry best practice (Inmon or Kimball). Evaluate new data sources to assess quality and determine integration approach.
Requires a bachelor's degree in area of specialty or equivalent experience. Demonstrates expertise in a variety of the data warehouse concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. May provide consultation on complex projects and is considered to be the top level contributor/specialist. Has the ability to design comprehensive and creative solutions to complex and diverse business requirements. Typically reports to a manager, head of a unit/department or lead architect.
- Conduct requirements gathering and design sessions with customers.
- Works with analysts to establish clearly define business requirements that follow a business process model.
- Works with data suppliers to establish input and interface specifications.
- Perform data analysis for source system data.
- Create conceptual, logical and physical models for healthcare data warehouse implementations.
- Design and manage data models in data modeling product.
- Develop third normal form and dimensional models that adhere to data warehouse best practices.
- Design time variant models that support both point in time (historical) and current state analysis.
- Generate DDL from model for RDBMS (Teradata, Oracle).
- Develop Source to Target Mappings from data models as data integration (ETL) specifications.
- Provides professional documentation of data architecture.
5 years experience as data architect for multi-terabyte data warehouse projects (healthcare preferred).
5 years experience with ERwin Enterprise Data Modeler Suite.
5 years experience in logical data modeling - relational and dimensional.
Understanding of data warehousing design and development best practices.
Understanding of ETL design and development best practices.
Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization. Ability to express complex technical information in a user-friendly language and style; present information effectively in one-on-one, and small group settings, including executive management.
Ability to communicate clearly in writing to document data requirements and translate into technical solutions.
Understands the importance of maintaining the physical and technical security and privacy of protected health information (PHI).
Desired Skills and Experience
Education / Certifications Required
Bachelors’ degree and 5 years experience in a data warehouse data modeling or equivalent experience.
We seek talented, qualified employees in all our operations regardless of race, gender, national origin, religion, sexual orientation, disability, age, or any other protected classification under country or local law. Truven Health Analytics is an Equal Employment Opportunity/Affirmative Action Employer.
According to the U.S. Citizenship and Immigration Services (USCIS), the H-1B visa cap has been met for the 2013 fiscal year (October 1, 2012-September 30, 2013).
Please refer to the Job Description for the qualifications.
Truven Health Analytics delivers unbiased information, analytic tools, benchmarks, and services to the healthcare industry. Hospitals, government agencies, employers, health plans, clinicians, and pharmaceutical and medical device companies have relied on us for more than 30 years. We combine our deep clinical, financial, and healthcare management expertise with innovative technology platforms and information assets to make healthcare better by collaborating with our customers to uncover and realize opportunities for improving quality, efficiency, and outcomes.