Senior Data Architect

Job Description US Work Authorization Requirement: Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization. Job Description:  We are seeking a highly experienced Senior Data Architect to design, build, and lead enterprise-scale data architecture and business intelligence solutions. This role is responsible for defining how data is structured, integrated, governed, and consumed across the organization to enable advanced analytics, reporting, and data-driven decision making. The ideal candidate brings deep expertise in data warehousing, dimensional modeling, Azure data platforms, and Power BI, along with strong leadership skills to drive standards, governance, and best practices across teams. Key Responsibilities Data Architecture & Engineering Design and implement scalable, enterprise-wide data architectures to support analytics and reporting. Lead the transformation of transactional (normalized) data into dimensional models (facts and dimensions) using Kimball methodology. Architect, manage, and evolve the Enterprise Data Warehouse (EDW), including data lineage and parent-child relationships. Design and maintain data pipelines using Azure Data Factory and Azure Synapse pipelines. Move and optimize data flows from Azure Data Lake to Synapse Analytics. Design and implement Tabular models in Power BI Premium datasets and SSAS. Develop and maintain ETL processes using SSIS. Write and optimize T-SQL and DAX for high-performance data models and reporting. Business Intelligence & Analytics Lead the design and development of Power BI dashboards and reports that support executive and operational decision-making. Integrate external and third-party data sources into the EDW. Partner closely with business stakeholders to translate requirements into scalable data models and BI solutions. Ensure analytics solutions align with business goals and deliver measurable value. Data Governance & Standards Define and implement data governance frameworks, metadata management practices, and architectural standards. Establish and enforce data quality rules, validation processes, and design standards. Design and implement secure data access models supporting internal and external users. Ensure compliance with data privacy and regulatory requirements. Review evolving business requirements and recommend architectural improvements or system upgrades. Leadership & Collaboration Lead the full data system development lifecycle from requirements through production support. Collaborate across engineering, analytics, and business teams. Mentor and guide junior data engineers and analysts on best practices in data architecture, modeling, and governance. Required Qualifications Bachelor’s degree in Computer Science, Information Systems, or a related field. 12+ years of overall experience in data architecture, data warehousing, and business intelligence. 8+ years of hands-on experience building relational and dimensional data models using Kimball methodology. 5+ years of experience developing Power BI reports and datasets. 5+ years of experience working with Enterprise Data Warehouses and ETL processes. 2+ years of hands-on experience with Azure Synapse pipelines. Strong expertise in Microsoft SQL Server, T-SQL, SSIS, and DAX. Proven experience designing Tabular models in Power BI Premium. Solid understanding of Azure Data Lake and Azure data platform services. Excellent communication, documentation, and stakeholder-management skills. Strong ability to gather requirements, estimate effort, and deliver solutions independently. Preferred / Nice-to-Have Skills Experience with data governance frameworks such as DAMA-DMBOK. Familiarity with data catalog and metadata tools (Azure Purview, Collibra). Exposure to Databricks. Understanding of regulatory and compliance requirements such as HIPAA and GDPR. Apply Online Your Name * Your Phone Number * Your Email Address * Job id What is your current U.S. visa or immigration status? * SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa Where are you currently located at? * W2 or C2C * SelectW2C2C How many years of total experience do you have? * How many years of relevant experience do you have? * Do you require H1B sponsorship? * YesNo Do you require sponsorship? * NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship Upload Resume * Δ US Work Authorization Requirement: Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization. Job Description:  We are seeking a highly experienced Senior Data Architect to design, build, and lead enterprise-scale data architecture and business intelligence solutions. This role is responsible for defining how data is structured, integrated, governed, and consumed across the organization to enable advanced analytics, reporting, and data-driven decision making. The ideal candidate brings deep expertise in data warehousing, dimensional modeling, Azure data platforms, and Power BI, along with strong leadership skills to drive standards, governance, and best practices across teams. Key Responsibilities Data Architecture & Engineering Design and implement scalable, enterprise-wide data architectures to support analytics and reporting. Lead the transformation of transactional (normalized) data into dimensional models (facts and dimensions) using Kimball methodology. Architect, manage, and evolve the Enterprise Data Warehouse (EDW), including data lineage and parent-child relationships. Design and maintain data pipelines using Azure Data Factory and Azure Synapse pipelines. Move and optimize data flows from Azure Data Lake to Synapse Analytics. Design and implement Tabular models in Power BI Premium datasets and SSAS. Develop and maintain ETL processes using SSIS. Write and optimize T-SQL and DAX for high-performance data models and reporting. Business Intelligence & Analytics Lead the design and development of Power BI dashboards and reports that support executive and operational decision-making. Integrate external and third-party data sources into the EDW. Partner closely with business stakeholders to translate requirements into scalable data models and BI solutions. Ensure analytics solutions align with business goals and deliver measurable value. Data Governance & Standards Define and implement data governance frameworks, metadata management practices, and architectural standards. Establish and enforce data quality rules, validation processes, and design standards. Design and implement secure data access models supporting internal and external users. Ensure compliance with data privacy and regulatory requirements. Review evolving business requirements and recommend architectural improvements or system upgrades. Leadership & Collaboration Lead the full data system development lifecycle from requirements through production support. Collaborate across engineering, analytics, and business teams. Mentor and guide junior data engineers and analysts on best practices in data architecture, modeling, and governance. Required Qualifications Bachelor’s degree in Computer Science, Information Systems, or a related field. 12+ years of overall experience in data architecture, data warehousing, and business intelligence. 8+ years of hands-on experience building relational and dimensional data models using Kimball methodology. 5+ years of experience developing Power BI reports and datasets. 5+ years of experience working with Enterprise Data Warehouses and ETL processes. 2+ years of hands-on experience with Azure Synapse pipelines. Strong expertise in Microsoft SQL Server, T-SQL, SSIS, and DAX. Proven experience designing Tabular models in Power BI Premium. Solid understanding of Azure Data Lake and Azure data platform services. Excellent communication, documentation, and stakeholder-management skills. Strong ability to gather requirements, estimate effort, and deliver solutions independently. Preferred / Nice-to-Have Skills Experience with data governance frameworks such as DAMA-DMBOK. Familiarity with data catalog and metadata tools (Azure Purview, Collibra). Exposure to Databricks. Understanding of regulatory and compliance requirements such as HIPAA and GDPR. [contact-form-7 id="ac31dcc" title="Job Apply Form"]