Sr Datawarehouse Architect for New York City NY at Centillion Infotech LLC | New York | Rezi

Sr Datawarehouse Architect for New York City NY at Centillion Infotech LLC

Sr Datawarehouse Architect for New York City NY

Centillion Infotech LLC · New York

2 weeks ago

Sr Datawarehouse Architect for New York City NY

Centillion Infotech LLC · New York

14 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

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