About the Role
We are looking for a highly proficient Data Warehouse Architect to lead the design and implementation of our enterprise data solutions. The ideal candidate will possess strong expertise in Azure Databricks, Python, and have a deep understanding of the financial or capital markets domain to support our data-driven initiatives and strategic insights.
Responsibilities
- Design, develop, and optimize scalable data warehouse architectures leveraging Azure cloud services.
- Build and maintain robust data pipelines and workflows using Azure Databricks and Python.
- Collaborate with business teams to understand data requirements and translate them into effective technical solutions.
- Ensure high data quality, security, and compliance with industry standards and regulations.
- Lead efforts to migrate legacy data systems to modern cloud-based architectures.
- Develop data models, ETL/ELT processes, and performance tuning strategies.
- Provide technical leadership, mentorship, and guidance to data engineering teams.
- Monitor data pipelines for reliability and troubleshoot issues as they arise.
- Stay current with emerging technologies, tools, and best practices in big data, cloud computing, and financial data management.
- Define and operationalize the Data Governance framework covering data ownership, stewardship, classification, lineage, and quality SLAs in collaboration with the CDO and Compliance teams.
- Implement automated end-to-end data lineage capabilities to support audit trails and regulatory examinations.
- Establish and monitor data quality dimensions such as completeness, accuracy, consistency, and timeliness with automated profiling and alerting for critical financial datasets.
- Drive data cataloguing initiatives, business glossary management, and metadata enrichment to improve enterprise-wide data democratization.
- Ensure adherence to financial industry governance, security, privacy, and regulatory requirements.
- Act as a trusted technical advisor to senior stakeholders on enterprise data strategy and platform capabilities.
- Lead and mentor a team of data engineers through architectural guidance, code reviews, and technical coaching.
- Partner with Enterprise Architecture and Infrastructure teams to ensure alignment with bank-wide technology standards.
- Produce clear technical documentation, architecture diagrams, and executive-level presentations for technical and non-technical audiences.
Requirements
- Proven experience as a Data Warehouse Architect or in a similar senior data engineering role.
- Hands-on experience with Azure Databricks, Python, and related Azure Data Services.
- Strong proficiency in SQL and data modeling techniques.
- Experience developing data pipelines, ETL/ELT workflows, and working with big data technologies such as Spark.
- Deep domain knowledge of the financial or capital markets industry, including financial instruments, trading, risk management, and regulatory compliance.
- Familiarity with data governance, security, and regulatory requirements.
- Excellent communication skills with the ability to collaborate effectively across cross-functional teams and executive stakeholders.
Skills
- Azure Databricks
- Python
- SQL
- Data Modeling
- ETL/ELT
- Spark
- Data Governance
- Scala
- Java
- C#
- BI tools
- Reporting platforms
Location
- New York City, NY
Work Type
- Full-time
Experience Level
- Senior
Education Level
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Master’s degree preferred
About the Company
- Synechron Inc
