This role is 3 days onsite. NO REMOTE or Relocation. Must be a US Citizen or Green Card Holder. Please do not apply if you are a EAD or H1-VIsa.
Job Description:
We are looking for a Data Architect to take ownership of designing and evolving a modern enterprise data ecosystem that supports analytics, reporting, and business decision-making. This role will focus on building and maintaining a secure, scalable data warehouse leveraging Microsoft cloud technologies such as Azure, Synapse, and Microsoft Fabric, while ensuring strong data quality, accessibility, and consistency across the organization.
This position will play a key role in establishing data standards, driving best practices in data modeling and governance, and partnering with both technical and business stakeholders. The ideal candidate is comfortable working independently and translating complex data concepts into actionable insights for non-technical audiences.
Key Responsibilities
Data Architecture & Modeling
- Design, implement, and maintain enterprise data warehouse solutions within Azure and Microsoft Fabric
- Develop and manage semantic data models to support reporting through Power BI and Azure Analysis Services
- Establish and document standards for data modeling, naming conventions, and dataset design
Data Governance & Quality
- Define and enforce data governance frameworks, including data definitions, access controls, and data policies
- Implement automated processes to monitor and improve data quality and integrity
- Partner with business users to understand requirements and resolve data inconsistencies
Technical Leadership
- Act as a subject matter expert for data architecture and enterprise data strategy
- Translate business requirements into scalable and efficient data solutions
- Provide guidance to stakeholders on data architecture decisions and trade-offs
Enablement & Collaboration
- Create documentation, data dictionaries, and standards to support self-service analytics
- Work closely with BI developers and business teams to ensure data solutions align with reporting needs
Required Qualifications
- 6+ years of experience in data architecture, data engineering, or BI-related roles
- Strong expertise with Microsoft Azure Data Services, including SQL, Synapse, Data Factory, and Fabric
- Advanced SQL skills with experience in query optimization
- Experience with Python or R for data processing and automation
- Deep understanding of semantic modeling in Power BI or Azure Analysis Services
- Hands-on experience with Power BI (Desktop, Service, DAX, Power Query)
- Experience integrating ERP (Epicor preferred) and CRM data for reporting and analytics
- Strong understanding of end-to-end ERP business processes (Quote-to-Cash, AR, AP, GL)
- Knowledge of enterprise data architecture principles and data lifecycle management
- Proven experience establishing and maintaining data governance and quality standards
- Strong communication skills with the ability to work with non-technical stakeholders
Preferred Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
- Experience with modern data architecture patterns such as lakehouse, star schema, or medallion architecture
- Background in operational or supply chain environments
- Exposure to planning tools such as Anaplan or similar platforms
