Data Architect with Erwin

Title: Data Architect with Erwin

Location: Chicago, IL (Onsite)

Duration: Long Term

Job Description:

Lead data architecture and modeling initiatives, applying dimensional and relational techniques to ensure optimal data delivery across projects.

Translate complex business requirements through analysis sessions into clear, complete, and correct logical and physical database designs.

Design and implement operational and dimensional models for Data Marts, Data Warehouse, and Azure cloud solutions using modeling tools (e.g., Erwin).

Orchestrate and manage large, complex data sets for both on-prem (MS SQL Server 2016+) and cloud (Azure/Snowflake) environments.

Define and implement best practices in data architecture, data warehousing, ETL/data integration, and advanced analytics.

Create and communicate Source-to-Target mapping across staging, integration, and presentation layers for BI/DW/Data Engineering projects.

Conduct detailed Data Analysis and Profiling using SQL/T-SQL to identify and resolve data quality issues (duplicates, non-conformed data, etc.).

Collaborate effectively with Executive, Product, Data, and Design teams to support diverse data acquisition needs and resolve technical issues.

Demonstrate strong proficiency in MS SQL Server technologies and excellent knowledge of relational and multi-dimensional database architectures.

VDart Group, a global leader in technology, product, and talent management, empowers businesses with comprehensive solutions through our four distinct, industry-leading business units. With a diverse team of over 4,000 professionals across 13 countries, we deliver strong esults across various industries, including Fortune 500 companies.

Leveraging our deep expertise as a global provider of resources and solutions, we serve a wide range of industry verticals, including BFSI, Automotive, Healthcare, Mobility, Energy, Life Sciences, Manufacturing, Consumer Industries, and Technology.

With over 16 years of experience, VDart has evolved to meet the needs of leading technology brands, placing and training more than 20,000 professionals and shaping the industry's future.

Our continuous reinvention, providing resources for IT solutions and unique digital solutions, has positioned us as a top growth leader in digital talent management and technology consulting.

Committed to "People, Purpose, Planet," we prioritize social responsibility and sustainability, as evidenced by our EcoVadis Bronze Medal Certification and participation in the UN Global Compact.

Our dedication to delivering strong results has earned us recognition as a trusted advisor for businesses seeking to drive innovation and growth, including many Fortune 500 companies.

Join our network! Partner with VDart Group to leverage our global network, industry expertise, and proven track record with a diverse clientele.