Azure Data Architect (remote US)

Azure Data Architect (remote US) Job Locations US Category Systems Overview We are seeking a skilled Azure Data Architect & Engineer to lead the design and implementation of our modern data platform.

In this dual-capacity role, you will define the architectural roadmap for our cloud data estate while remaining hands-on in building scalable pipelines, optimizing Spark performance, and migrating legacy workloads into Microsoft Fabric and Azure Synapse .

Responsibilities Architectural Leadership: Design and implement scalable, secure, and resilient cloud data architectures using the Medallion (Bronze/Silver/Gold) architecture pattern.

Data Pipeline Engineering: Build and maintain complex ETL/ELT workflows using Azure Data Factory (ADF) and Microsoft Fabric Data Factory. Advanced Analytics & Spark: Develop high-performance data processing logic using PySpark, Spark SQL, and Python on Azure Databricks or Fabric Spark Notebooks.

Migration & Modernization: Lead hands-on migrations of on-premises data warehouses to Azure, ensuring minimal downtime and data integrity. Performance Tuning: Perform deep code-level analysis of Spark core internals and Delta Lake logs to troubleshoot and optimize large-scale data processing.

Unified Analytics: Integrate Power BI with OneLake and Lakehouse architectures, ensuring seamless "Direct Lake" connectivity and optimized reporting.

Security & Governance: Implement robust security frameworks, including Row-Level Security (RLS), data masking, and compliance with global privacy regulations DevOps & Best Practices: Champion CI/CD for data (DataOps) using Azure DevOps/GitHub, ensuring code modularity, version control, and comprehensive documentation.

Qualifications Core Experience 3–5+ years of experience in Data Warehousing, BI, and Cloud Data Engineering. Proven track record of designing end-to-end data solutions on Microsoft Azure .

The Azure Stack - Azure Data Lake Storage (ADLS Gen2), Azure SQL DB, and Synapse Analytics, ADF, Fabric ecosystem Data Modeling & Visualization Expertise in Dimensional Modeling (Star/Snowflake schemas).

Advanced Power BI skills, including DAX, RLS implementation, and performance tuning for large datasets. Programming & Infrastructure Strong proficiency in Python (PySpark) and SQL.

Understanding of Infrastructure as Code (ARM templates, Terraform, or Bicep) and hybrid cloud integration. Preferred Certifications DP-203: Azure Data Engineer Associate DP-600: Fabric Analytics Engineer Associate DP-700: Fabric Data Engineer Associate (New/Beta) HarperCollins Publishers is a company full of people who are passionate about books.

When you apply for a position, we want to know why you want to work here, and why you are interested in the job. That’s why cover letters are strongly preferred.

The salary range for this position is $110,000-$135,000. We recognize that attracting the best talent is key to our strategy and success as a company.