Enterprise Data Architect

This job is going to be onsite 3 days a week. Must be a US Citizen or Green Card Holder. Looking with someone who is fluent in Python and SQL.

• Design and maintain an enterprise data warehouse using Microsoft Azure and Microsoft Fabric.
• Build and manage semantic data models to support reporting via Power BI and Azure Analysis Services.
• Document standards for data modeling, naming conventions, and dataset architecture.

• Define and enforce governance policies, including data definitions, rules, and access protocols.
• Implement automated data quality checks and validation.
• Collaborate with users to understand data needs and address inconsistencies.

• Serve as SME on data architecture.
• Translate business needs into scalable data models.
• Advise non-technical leaders on architecture decisions.

• Provide documentation and data dictionaries to support self-service analytics.
• Work with BI developers and business teams to ensure data meets reporting needs.

• 8+ years of experience in data architecture, engineering, or BI roles.
• Expertise in Microsoft Azure Data Services including SQL, Synapse, Data Factory, and Fabric.
• Strong SQL skills and experience optimizing queries.
• Python or R scripting knowledge
• Deep knowledge of semantic modeling in Power BI or Azure Analysis Services.
• Strong hands‑on experience with Power BI (desktop, service, DAX, Power Query)
• Experience structuring ERP (Epicor preferred) and CRM data for reporting.
• Clear grasp of end-to-end business process flows within an ERP system, including Quote-to-Cash, Accounts Receivable, Accounts Payable, and General Ledger (GL) transactions
• Understanding of enterprise data concepts and lifecycle
• Demonstrated ownership of governance and data quality
• Strong communication skills with non-technical stakeholders.

• Bachelor’s or Master’s degree in Computer Science, IS, or related field.
• Experience with modern architecture concepts like lakehouse, star-schema, or medallion models.
• Experience in operational or supply chain environments.
• Exposure to Anaplan or similar planning platforms.