Job Details

Email to Friend Save Back

Data Architect

ROLLING MEADOWS-60008, IL, US
07/09/2018

-

Required Skills

Microsoft stack

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

Data Architect

Collaborate with customers and stakeholders, understand and translates business use cases and/or requirements and provide data analysis and translate into data models.

Collaborate with the Data Integration and BI Development teams to create optimal data models for data ingestion and Analytics reports/dashboards.

Identify data sources, develop and maintain data architectures, construct data catalog and data decomposition diagrams, provide data context/flow diagrams and document the process.

Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts and publish for internal consumption.

Document the business definitions of data elements and publish the same for internal and client consumption.

Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

Establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

Create a cadence for regularly cleaning up tables not necessary in Development, Test,
Stage and Production environments.

Pursue continuous improvement of data quality, standardization of processes, and quality of service

Requirements

7+ years of experience in functioning as a Data Architect in an environment containing data in the TBs.

8+ years experience in designing, and deploying data solutions. Extensive knowledge of dimensional modeling, logical and physical.

5+ years experience within the Microsoft stack; experience in a MPP environment is a plus.

Strong understanding of SQL tuning, indexes and space management.

Solid experience with data modeling tools (Power Designer is considered a plus).

Requires strong analytical, conceptual and problem-solving abilities.

Insurance and risk management domain knowledge a plus

Bachelor’s degree preference in computer/information sciences or business/commerce.