> Markdown version of [/jobs/ext/1247899-data-warehouse-architect](https://www.wearedevelopers.com/jobs/ext/1247899-data-warehouse-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Architect - **Company:** Virtualan Software LLC - **Location:** New York, NY, United States - **Experience:** Expert - **Salary:** $110,000.0 - $120,000.0 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Microsoft Azure, C Sharp (Programming Language), Code Review, Information Systems, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Systems, Data Warehousing, DevOps, Dimensional Modeling, Python (Programming Language), Metadata, Meta-Data Management, SQL Azure, Performance Tuning, Power BI, Cloud Services, Azure Data Lake, SQL Databases, Tableau (Software), Data Processing, Cloud Platform System, Azure Data Factory, Snowflake, Apache Spark, Data Lakes, Pyspark, Semi-structured Data, Information Technology, Data Lineage, Collibra, Data Management, Tools for Reporting, Azure Synapse Analytics, Data Pipelines, Databricks - **Published:** July 12, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=7cf961188cdaacb2 ## About the Role * 10+ years of experience in Data Engineering, Data Warehouse Architecture, or related roles. * Strong hands-on experience with Azure Databricks. * Expertise in Python, PySpark, Apache Spark, and SQL. * Experience with Azure Data Services, including Azure Data Factory (ADF), Azure Synapse Analytics, Azure Data Lake Storage (ADLS Gen2), Azure SQL, or similar services. * Strong knowledge of data warehouse architecture, dimensional modeling, ETL/ELT frameworks, and performance tuning. * Experience designing scalable cloud-native data platforms. * Hands-on experience with Delta Lake and modern data lakehouse architectures. * Strong understanding of data governance, metadata management, lineage, and data quality frameworks. * Experience working within Banking, Financial Services, Capital Markets, Investment Banking, or Risk Management environments. * Excellent communication and stakeholder management skills. * Bachelor's degree in Computer Science, Information Systems, or a related field., * Microsoft Azure certifications (Azure Data Engineer Associate, Azure Solutions Architect, or Azure Data Scientist). * Experience with Snowflake or other cloud data warehouse platforms. * Knowledge of Microsoft Purview, Collibra, or similar governance tools. * Experience with CI/CD pipelines and DevOps practices for data engineering. * Familiarity with Scala, Java, or C#. * Experience with BI and reporting tools such as Power BI or Tableau. ## Description We are seeking an experienced Data Warehouse Architect to design, build, and modernize enterprise-scale data warehouse solutions supporting critical business and regulatory reporting initiatives. The ideal candidate will have strong hands-on expertise in Azure Databricks, Python, Spark, SQL, and Azure Data Services, along with experience in the banking, financial services, or capital markets domain. This role involves architecting scalable cloud-based data platforms, developing high-performance ETL/ELT pipelines, implementing data governance best practices, and partnering with business and technology stakeholders to deliver reliable, secure, and compliant data solutions., * Design, develop, and optimize scalable enterprise data warehouse architectures using Azure cloud technologies. * Build and maintain high-performance ETL/ELT pipelines using Azure Databricks, Python, PySpark, and SQL. * Design robust data models to support analytics, reporting, and regulatory requirements. * Migrate legacy data platforms and ETL processes to modern cloud-based architectures. * Develop scalable data pipelines that process large volumes of structured and semi-structured data. * Optimize data processing performance, storage, and query execution for enterprise workloads. * Collaborate with business users, product owners, architects, and engineering teams to translate business requirements into technical solutions. * Monitor, troubleshoot, and improve data pipeline reliability and performance. * Provide technical leadership through architecture reviews, code reviews, mentoring, and best-practice guidance. * Produce technical documentation, architecture diagrams, and implementation standards. Data Governance & Compliance * Design and implement enterprise data governance frameworks covering data ownership, stewardship, lineage, metadata, and data quality. * Implement automated data lineage and audit capabilities to support regulatory and compliance requirements. * Establish data quality standards and monitoring processes for completeness, accuracy, consistency, and timeliness. * Support enterprise data cataloging and metadata management initiatives. * Ensure compliance with financial industry regulations, security policies, and data privacy standards. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)