Stefanini - Dearborn, MI

posted 3 months ago

Full-time - Mid Level
Dearborn, MI
251-500 employees
Professional, Scientific, and Technical Services

About the position

The Data Architect position at Stefanini Group is a pivotal role within the Information/Data Architecture Practice, focusing on supporting major initiatives in Marketing, Sales, Service, and Portfolio management. The ideal candidate will possess a robust architectural background, with extensive knowledge in data architecture, hands-on experience in data model design, and a solid understanding of data analytics architecture. This role requires collaboration with enterprise architects, solution architects, business teams, and product teams to develop strategies, design data models, and establish information flows. The Data Architect will also be responsible for performing data quality analysis, setting standards and best practices, and guiding product teams in the implementation of these designs. In this role, the Data Architect will lead design discussions, create conceptual and logical data models, and maintain data dictionaries. They will define reporting strategies and identify data sources for reporting purposes. The candidate will also conduct data quality analyses to identify issues and propose effective solutions. Furthermore, the Data Architect will guide product teams in creating physical data model designs and ensure adherence to established standards and guidelines. The position also involves creating an information architecture roadmap that outlines current, near-term, and long-term views of data architecture, facilitating discussions to understand data sources, and establishing systems of record while creating current and future state data flows.

Responsibilities

  • Lead design discussions and create conceptual data models, logical data models, and data dictionaries.
  • Manage and maintain data models and define reporting strategies.
  • Identify sources for reporting data and perform data quality analysis.
  • Identify data quality issues and propose solutions to resolve them.
  • Guide product teams in creating physical data model designs and data dictionaries.
  • Review design adherence to ensure standards, guidelines, and best practices are followed.
  • Consult and guide product teams through design and implementation processes.
  • Create an information architecture roadmap with current, near, and far views.
  • Facilitate discussions to understand data sources and establish systems of record.
  • Create current and future state data flows.

Requirements

  • 7+ years of data modeling experience with expertise in relational and/or dimensional analysis.
  • 5+ years of experience in data warehouse database design.
  • Deep understanding of data modeling principles and architecture concepts.
  • Extensive experience designing databases that support complex business processes.
  • Experience with database technologies such as Oracle, DB2, Teradata, Hadoop, MS SQL Server, PostgreSQL, and Google Cloud Platform Big Query.
  • Knowledge of data analytics and Google Cloud technologies.

Nice-to-haves

  • Good collaborative and communication skills.
  • Experience with data modeling in enterprise tools such as Power Designer or ERWIN.
  • Ability to work well individually and as a team member.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service