Data Modeler / Architect

Data Modeler/Architect

6 month contact

Westerville, OH (hybrid)

Requirements

* Experience data modeling based on a certain set of data attributes

* Experience data modeling for data warehousing with a star schema / snowflake schema (dimensional modeling)

* Experience data modeling for Azure SQL database, Azure Synapse, SQL Server platforms

* Experience defining and implenting data warehousing best practices

Roles/ Responsibilites

:Data Architecture

* Experience playing a leadership role in enterprise-wide Data Quality Management, Data Resource Management, Data Stewardship and/or Data Administration programs at a large company similar to BMS

* Familiarity with process improvement frameworks such as the SEI CMMI

* Master Data Hub architecture, data design and implementation

* Data Quality Management and Data Architecture standardization

* Metadata management, design and integration

* Data Warehouse architecture, data design and implementation

* ERP Data Architecture

* Proven analytical skills to properly evaluate and interpret cross-functional data standardization requirements

* Ability to resolve complex issues relate to enterprise wide data architecture concerns

* Ability to architect data management enterprise solutions that are in alignment with strategic technology roadmap and emerging industry trends

* Experience in Computer Systems Validation and Software Quality Assurance

* Management style that exhibits high energy, strategic thinking, collaboration, direct communication and results orientation

* Effective in matrix management and team building

* Poise, maturity and communication skills necessary to represent the data architecture group internally and externally

* Strong presentation, verbal and written communications skills

Provide leadership in defining an enterprise information architecture including:

o Data Architecture Process Standards

o Metadata Management Infrastructure Strategy

o Master Data Hub Technology Architecture

o Architectural Deliverables associated with Portfolio Management and SDLC

o Develops value-added, strategic solutions and sharing of best practices throughout the organization and the architectural community

o Collaborate with Global Shared Service Governance teams to institutionalize policy, standards and project related architectural deliverables.

o Facilitates agreement of Enterprise Architecture definitions with Global Shared Service partners o Provides leadership and direction for the definition of an enterprise data architecture that supports the business information needs

o Communicate with team members and other stakeholders in a timely and effective manner in order to keep them apprised of data architecture status and relevant issues of interest to, and impact on, the clients and their business areas.

Technical qualifications will include:

* Data Modeling

* Physical database design and database tuning expertise

* RDBMS skills

* SQL and PL/SQL experience

* Tool(s) proficiency such as ERWin, ETL (Informatica PowerCenter), Data Profiling, etc. (3-5 years experience)