ASGN - Dearborn, MI

posted 3 months ago

Full-time
Dearborn, MI
Administrative and Support Services

About the position

The Data Architect will be an integral part of the Information/Data Architecture Practice, supporting significant initiatives across Marketing, Sales, Service, and Portfolio sectors. This role demands a seasoned architect with a robust understanding of data architecture, hands-on experience in data model design, and a solid grasp of data quality analysis. The Data Architect will collaborate closely with enterprise architects, solution architects, business units, and product teams to formulate strategies, design data models, and establish information flows. Additionally, the role involves performing data quality analyses, setting standards and best practices, and guiding product teams in the implementation of these designs. In this position, the Data Architect will lead design discussions, create conceptual and logical data models, and maintain comprehensive data dictionaries. The architect will also define reporting strategies and identify data sources for reporting purposes. A critical aspect of the role is to perform data quality analysis, pinpoint issues, and propose effective solutions. The Data Architect will guide product teams in creating physical data model designs and ensure adherence to established standards and guidelines. Furthermore, the architect will facilitate discussions to understand data sources, establish systems of record, and create both current and future state data flows. The role requires the creation of an information architecture roadmap that outlines the immediate, near-term, and long-term views of data architecture. The Data Architect will be expected to work collaboratively with various teams, ensuring that the data architecture aligns with the overall business strategy and objectives.

Responsibilities

  • Lead design discussions and create conceptual data models, logical data models, and data dictionaries.
  • Manage and maintain data models effectively.
  • Define reporting strategy and identify sources for reporting data.
  • Perform data quality analysis, identify issues, and propose solutions to resolve them.
  • Guide product teams in creating physical data model designs and data dictionaries.
  • Review design adherence and ensure standards, guidelines, and best practices are followed.
  • Consult and guide product teams through design and implementation processes.
  • Create an information architecture roadmap with immediate, near, and far views.
  • Facilitate discussions to understand data sources, establish systems of record, and 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.

Benefits

  • Comprehensive benefits package including quality career resources, training, certifications, and development opportunities.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service