skip to main content

Important Notice

It appears you are using an older version of your browser. While some functions will be available, works best with a modern browser such as the ones provided by:

Please download and install the latest version of the browser of your choice. We apologize for any inconvenience.

Watson Health - Data Modeler, KY

Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.

Job Details
Job Order Number
Company Name
Physical Address

Chicago, IL 60664
Job Description


IBM’s Industry Consultants are essential to our clients as they work to reinvent themselves for the future. Join our highly visible and highly skilled team of global consultants as we strive to accelerate sales, deliver client engagements, and build IBM’s market eminence. If you are a forward-thinker and a curious intellectual, we welcome you to apply for your next exciting career challenge!

Your Role and Responsibilities

Must be able to travel weekly to work on-site in Frankfort, Kentucky**

The successful candidate must have solid data modeling and business analyst experience and must demonstrate an affinity for working with others to create successful Enterprise Data Warehouse (DW) and Business Intelligence (BI) solutions. He/She must be an excellent communicator, both written and verbal, and have experience working with business areas to translate their business data needs and data questions into usable IT Solutions. He/she must have a solid background in Data Analysis and Data Modeling as well as on the job experience as a data modeler. This position provides the opportunity to be involved in new and/or existing BI and DW solutions and to work with many different business areas within the company. The candidate will participate in all phases of the DW/BI development life cycle and will independently and collaboratively write project/enhancement requirements and perform data modeling tasks. He/She will coordinate with technical DW/BI development staff through design, development and implementation.

Position Overview:

+ The Data Modeler will design data models following industry best practices, develop strategies for integration of data from multiple data sources / data warehouses, establish data models and standards that facilitate data integration of large and diverse data stores, and evaluate data sources, assess quality and determine integration approaches.

+ Demonstrates experience in a variety of the data warehouse concepts, practices, and procedures. Performs a variety of complicated tasks. May provide consultation on projects and works collaboratively with the Data Architect. Has the ability to design comprehensive and creative solutions to complex and diverse business requirements.

Essential Responsibilities:

+ Conducts requirements gathering and design sessions with stakeholders.

+ Works with analysts, operations teams etc. to establish clearly define business requirements that follow a business process model.

+ Works with data suppliers to establish input and interface specifications.

+ Works data consumers to establish requirements, target and interface specifications.

+ Performs data analysis of source system and target system data.

+ Works with stakeholders to determine data quality standards, management of bad data, reposting etc.

+ Designs and manages data models in data modeling product/tool.

+ Develops Source to Target Mappings from data models as data integration (ETL) specifications.

+ Provides and maintains professional documentation of data architecture.

+ Creates conceptual, logical and physical models for healthcare data warehouse implementations.

+ Determines and develop third normal form, dimensional, and other models that adhere to data warehouse best practices.

+ Designs time variant models that support both point in time (historical) and current state analysis.

+ Generates DDL from model for appropriate target (RDBMS (Oracle, Teradata), big data etc.).

Successful Candidates will possess the following:

+ Medicaid, MMIS or related experience with a state agency

+ Demonstrated experience directing multi-discipline technical teams producing Enterprise Data Warehouse (EDW) solutions

+ Demonstrated interpersonal skills and the ability to collaborate with technical teams, delivery managers, project management, client management and customer stakeholders

Required Technical and Professional Expertise

+ 3+ yrs exp as data modeler for multi-terabyte healthcare DW projects

+ 3+ yrs exp with ERwin Enterprise Data Modeler Suite or ER Studio or equivalent

+ 3+ yrs exp in logical data modeling – relational & dimensional, big data

+ Understanding of industry best practices in DW and big data design and development

+ Experience with one or more DW approaches: Data Lake or Data Vault

+ Experience with developing in accordance to Waterfall, Agile, and Hybrid SDLC methodology

+ Good communication and interpersonal skills when collaborating with developers, analysts, and business staff

+ Ability to express and present complex technical information in a user-friendly language and style one-on-one and in small group settings which include the executive level

+ Experience in enterprise level database management systems, such as Oracle or DB2

+ SQL skills with the ability to write complex queries

Preferred Technical and Professional Expertise

Preference for a candidate located in Frankfort, KY

About Business Unit

IBM Watson Health is pioneering a new partnership between humanity and technology with the goal of transforming global health and revolutionizing many aspects of the medical and pharmaceutical industries, as well as government sectors. We aspire to improve lives and give hope by delivering innovation to address the world’s most pressing health challenges through data and artificial intelligence insights.

Your Life @ IBM

What matters to you when you’re looking for your next career challenge?

Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities – where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust – where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.

Impact. Inclusion. Infinite Experiences. Do your best work ever.

About IBM

IBM’s greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.

Location Statement

IBM will not be providing visa sponsorship for this position now or in the future. Therefore, in order to be considered for this position, you must have the ability to work without a need for current or future visa sponsorship.

Being You @ IBM

IBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

To view full details and how to apply, please login or create a Job Seeker account.