Data Architect

Job Title: Senior Data Architect
Location: Hybrid (ONSITE – Monday and Tuesday, Remote – Other Days)
Location Address: 1 Renaissance Plaza, Oak Brook Terrace, Illinois

About Us:

DMV IT Service LLC is a trusted IT consulting firm founded in 2020. We specialize in optimizing IT infrastructure and providing expert guidance to empower businesses to achieve their technology goals. Our services span system administration, cybersecurity, networking, and IT operations. With a client-first approach, we ensure long-term success for our clients through innovative solutions and industry best practices.

Job Purpose:

We are seeking a Senior Data Architect to design, build, and oversee the deployment and operation of enterprise data architecture and business intelligence solutions. The role will be critical in defining the architecture for data systems, ensuring their seamless integration across the organization, and providing support for advanced analytics and decision-making. The architect will also be responsible for data governance, metadata management, and maintaining high standards for data quality, security, and compliance.

Requirements

• Data Architecture & Engineering:
• Design and implement scalable data architectures that support enterprise-wide analytics and reporting needs.
• Lead the transformation of transactional (normalized) data into dimensional models (facts and dimensions) using Kimball methodology.
• Architect and manage the Enterprise Data Warehouse (EDW), including parent-child relationships and data lineage.
• Develop and maintain data pipelines using Azure Data Factory and Synapse pipelines to move data from Data Lake to Synapse.
• Design and implement Tabular models within Power BI Premium datasets and SSAS environments.
• Utilize SSIS for data extraction and transformation processes.
• Write efficient and optimized T-SQL and DAX code for data modeling and reporting.
• Business Intelligence & Analytics:
• Lead the design and development of Power BI reports and dashboards to support business decision-making.
• Analyze external data sources and integrate them into the EDW.
• Collaborate with business stakeholders to translate requirements into technical specifications and data models.
• Ensure BI solutions align with business goals and deliver measurable value.
• Governance & Standards:
• Define, select, and implement data governance and metadata management tools and best practices.
• Establish and enforce design standards, data quality rules, and assurance processes to ensure compatibility and operability of data flows and storage.
• Design and implement a security infrastructure that supports internal and external access while maintaining compliance with data privacy regulations.
• Review business and product requirements and recommend system upgrades or changes to meet evolving data needs.
• Leadership & Collaboration:
• Lead the full system development life cycle from requirements gathering to implementation and support.
• Work independently and collaboratively across cross-functional teams.
• Mentor junior data engineers and analysts on best practices in data architecture and governance.

Required Qualifications:

• Education & Experience:
• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 8+ years of experience in building relational and dimensional data models using Kimball methodology.
• 5+ years of experience in Power BI reporting and dataset development.
• 5+ years of experience working with Enterprise Data Warehouses and writing ETL processes.
• 2+ years of experience with Azure Synapse pipelines.
• Strong proficiency in Microsoft SQL Server T-SQL, SSIS, and DAX.
• Experience designing and implementing Tabular models in Power BI Premium.
• Familiarity with Azure development platform and Data Lake architecture.
• Knowledge of Databricks is a plus.
• Soft Skills:
• Excellent written and verbal communication skills.
• Strong documentation and multi-tasking abilities.
• Proven ability to gather requirements and estimate work effort.
• Excellent problem-solving and analytical skills.

Preferred Qualifications:

• Industry Knowledge & Methodologies:
• Experience with data governance frameworks such as DAMA-DMBOK.
• Familiarity with data cataloging and metadata management tools (e.g., Azure Purview, Collibra).
• Understanding of regulatory compliance requirements (e.g., HIPAA, GDPR) as they relate to data architecture.