DMV IT Service
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 .
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 .