Location: United States (Remote / Anywhere in the US)
About the Role
The Technical Architect – Enterprise Data is a consulting role supporting one of our customers. In this position, you will be responsible for defining, governing, and delivering scalable enterprise data and integration architectures across Microsoft Fabric, Azure, and core business systems. This role provides architectural leadership, ensures alignment with enterprise standards, and guides engineering teams in implementing high-quality, secure, and performant solutions. The architect partners with business stakeholders, data teams, systems and security teams, and application owners to translate requirements into technical and functional blueprints and long-term platform roadmaps. The role reports to the IT Applications team and works closely with key IT stakeholders at the customer.
Key Responsibilities
- Define enterprise data architecture across Microsoft Fabric, Data Lake, EDW, and analytics platforms.
- Design integration patterns for ingestion, transformation, and consumption.
- Create architectural flows, reference models, and long-term platform roadmaps.
- Architect ETL/ELT pipelines that integrate diverse data sources into Azure Data Lake and EDW.
- Design continuity and disaster recovery across ERP, CRM, Data Lake, Fabric, and analytics systems so business processes remain functional during partial outages.
Governance, Standards & Security
- Establish standards for data modeling, metadata, lineage, and governance.
- Implement data validation, logging, monitoring, lineage, and role-based access control (RBAC).
- Ensure compliance with enterprise security, confidentiality, and regulatory standards.
- Enforce architectural governance and adherence to standards.
- Define the continuity strategy for all data and integration platforms and drive its implementation.
- Proactively identify architectural risks (single points of failure, dependency bottlenecks, data corruption risks).
- Ensure every solution includes DR and continuity considerations from day one.
- Ensure continuity plans meet audit and security requirements and that teams know how to recover systems and execute the plans.
Collaboration, Delivery & Quality
- Collaborate with business stakeholders and source system teams to understand data requirements.
- Translate business needs into technical specifications and architectural roadmaps.
- Review user stories and provide architectural guidance to development teams.
- Support QA and functional teams in defining testing strategies for new and existing features.
- Ensure delivered solutions align with business needs and architectural intent.
- Conduct root cause analysis for data issues and identify opportunities for improvement.
- Manage platform reliability, data quality, and governance processes.
- Drive platform cost optimization, performance tuning, and operational excellence.
AI/ML & Emerging Technologies
- Integrate AI/ML models and GenAI capabilities into data products and workflows.
- Evaluate emerging technologies and recommend adoption strategies.
- Guide teams on responsible AI usage and integration patterns.
- Set clear standards for process adherence, development methodology, documentation, and delivery timelines for all vendor-led work.
- Establish quality gates, review cycles, and acceptance criteria to ensure vendor deliverables meet architectural and coding standards.
- Conduct regular checkpoints with vendor teams to monitor progress, identify risks, and ensure alignment with enterprise architecture principles.
- Provide technical guidance to vendor engineers to ensure solutions are scalable, secure, and compliant with enterprise patterns.
Qualifications
- 10+ years in enterprise solution architecture, data engineering, and software development.
- Bachelor’s degree preferably in Computer Science, Information Technology, Management Information Systems, or a related field.
- Proven experience designing end-to-end integrations, data platforms, and automation for large enterprise environments.
- Strong hands-on expertise with Microsoft Fabric, Data Lake, Data Warehouse, Data Pipelines, and the broader Microsoft ecosystem.
- Deep experience with Power BI semantic models, datasets, dashboards, and reporting.
- Advanced proficiency in DAX, Power Query, SQL, Python, and PySpark.
- Demonstrated experience architecting ETL/ELT pipelines integrating diverse data sources into Azure Data Lake and EDW.
- Strong understanding of data modeling, normalization, metadata management, and enterprise data security.
- Exposure to AI/ML, Copilot, GenAI, LLMs, prompt engineering, and AI API integration.
- Familiarity with SDLC, software quality practices, Jira, Git, and CI/CD.
- Experience with SaaS/Cloud ERP or CRM systems (NetSuite, Salesforce, SAP S/4HANA).
- Excellent communication, stakeholder management, and problem-solving skills.