Data Architect

Description

1. 5 years experience as a data architect for multiterabyte data warehouse projects
2. 5 years experience with ERwin Enterprise Data Modeler Suite OR equivalent.
3. 5 years experience in logical data modeling relational and dimensional.
4. 3 years experience in data governance analysis
5. Understanding of industry best practices in data warehousing design and development
6. Strong preference for someone with Healthcare/Human Services/Government industry Job Description As IBM Watson builds out their team they need a Data Architect to join the team. This person will be responsible for the following responsibilities for the first 6 months Participating in requirements session with the BA resources and client to help identify key data requirements
Meeting with the data source vendors to clarify the data exchange interfaces
Developing data models, data dictionaries and design documentation to meet the solution requirements needs and project deliverables
Working with the ETL team resources to design the load workflows
Overall Responsibilities Designs relational databases and develops strategies for data warehouse implementations following industry best practices (e.g., Inmon, Kimball). Evaluates new data sources to assess quality and determine integration approach. Conducts data risk assessments, identify and document data mappings/lifecycle, and helps build an enterprise data governance model, policies and programs.
Essential Responsibilities Conducts data requirements assessment and design sessions with customers.
Works with analysts to establish clearly defined business requirements.
Works with data suppliers to establish input and interface specifications.
Performs data analysis for source system data.
Creates conceptual, logical and physical models for healthcare data warehouse implementations.
Designs and manages data models in data modeling product.
Develops third normal form and dimensional models that adhere to data warehouse best practices.
Designs timevariant models that support both pointintime (historical) and current state analysis.
Generates DDL from model for RDBMS (Oracle, Teradata, ).
Provides professional documentation describing data architecture.
Represents the EDW team and collaborates with the customer and other agencies to conduct data risk assessments, document data mappings/lifecycle, and help build a data governance model, policies and programs.
Represents the EDW team and collaborate with ongoing customer enterprise wide MDM and metadata projects.
Understands customers Data Management program and environment and identifies the next generation of processes and products to refine and extend the lifecycle of the program. Develops the approach for the implementation of Data Management lifecycle components (examples include master data management, conformance with reference architecture, metadata strategy, data warehousing strategy, data classification programs, data quality,) Collaborates across the organization to understand the value of these components and obtains alignment in the approach and benefits.
Acts in a consulting capacity, in the implementation of the data management lifecycle components.
Designs solutions with regard to data architecture, working with software development teams and enterprise and application architects to ensure consistency and coherence with the enterprise architecture. Based on knowledge of data centric technology trends in the marketplaces, determines their applicability to the customer; evaluates and recommends data related technology products based on Truvens overall directional goals. Demonstrates an ability to quickly identify the most likely problem area in a complex, integrated data environment
REQUIRED Skills and Experience
5 years experience as a data architect for multiterabyte data warehouse projects
5 years experience with ERwin Enterprise Data Modeler Suite OR equivalent.
5 years experience in logical data modeling relational and dimensional.
3 years experience in data governance analysis
Understanding of industry best practices in data warehousing design and development.
Ability to express complex technical information in a userfriendly language and style; present information effectively in oneonone, 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 HIPAA Protected Health Information (PHI).
Ability to lead/mentor less experienced data modeler(s).
PREFERRED Skills and Experience
Healthcare related data modeling experience.
Oracle DBMS experience.
Exposure to Business Intelligence platforms (e.g., Cognos, Business Objects).