Data Architect at CYNET SYSTEMS Inc. (Boston, MA)

Job Description

Job Description:

• 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 time-variant models that support both point-in-time (historical) and current state analysis.
• Generates DDL from model for RDBMS (Oracle, Teradata).
• Provides professional documentation describing data architecture.
• Represent the EDW team and collaborate 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.
• Represent the EDW team and collaborate with ongoing customer enterprise wide MDM and metadata projects
• Understands customer's 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
• Leads project teams, or acts in a consulting capacity, in the implementation of the data management lifecycle components
• Provides direction and reviews 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 Truven's overall directional goals.
• Demonstrates an ability to quickly identify the most likely problem area in a complex, integrated data environment

Job Requirements:

REQUIRED Skills and Experience:

• 10 years' experience as a data architect for multi-terabyte data warehouse projects
• 10 years' experience with ERwin Enterprise Data Modeler Suite OR equivalent.
• 10 years' experience in logical data modeling - relational and dimensional.
• 5 years' experience in data governance analysis
• Insurance-related data modeling experience.
• Understanding of industry best practices in data warehousing design and development.
• 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 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.

Education / Certifications:

• Bachelor's degree AND 10 years' experience in a data warehouse, data modeling OR equivalent experience.

by via developer jobs - Stack Overflow