JD:
· 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.
· Guides the DW team on how to performs data analysis for source system data.
· Directs the design of conceptual, logical and physical models for healthcare data warehouse implementations.
· Leads the team on best practices when designing and managing data models in data modelling product.
· Directs and performs the development of third normal form and dimensional models that adhere to data warehouse best practices.
· Facilitates the design of time-variant models that support both point-in-time (historical) and current state analysis.
· Reviews DDL from model for RDBMS (Oracle, Teradata, …).
· Provides professional documentation describing data architecture.
· Represents DW 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.
· 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 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 client’s overall directional goals.
· Demonstrates an ability to quickly identify the most likely problem area in a complex, integrated data environment
Skills and Experience:
· 8+ yrs hands on experience in ETL Informatica 10.x, DW technical development; data architecture, data integration, business intelligence and data analysis tools
· 5+ yrs developing technical architecture and leading implementation teams
· Healthcare related data modelling experience
· Strong ETL Informatica experience
· Oracle DBMS experience
· Exposure to Business Intelligence platforms (e.g., Cognos,)
· Excellent Communication Interpersonal skills
· Complete understanding of the different integration points of Healthcare transactions
· Success as a DW technical lead, delivering solutions for large projects integrating diverse technologies and products
· In-depth understanding of DW implementation and application development best practices
· Excellent documentation skills, ability to produce diagrams and schematics that visualize technical solutions
· In-depth understanding of RDBMS applications as well as relational & dimensional data modelling practices
· In-depth understanding of data integration best practices, leading industry applications & features such as master data management, entity resolution, data quality assessment, metadata management
· In-depth understanding of security models and methods to protect information in the DW solution