Azure Data Warehouse Architect

Intersources Inc.
New York, NY, United States
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
$22,000.0
Working hours
Regular working hours

Tech stack

JavaScript (Programming Language) Application Programming Interfaces (APIs) Agile Methodology Data Analysis Computing Platforms Systems Engineering Microsoft Azure C Sharp (Programming Language) Software as a Service Code Review Cyber Security System Configuration
+20 more
Data Architecture Data Warehousing Software Debugging Software Design Patterns DevOps Infrastructure as a Service (IaaS) Platform as a Service (PAAS) Power BI SQL Databases Enterprise Data Management Cloud Platform System Performance Testing Azure Data Factory Togaf Data Lakes AngularJS Information Technology Data Analytics Databricks Microservices

Job description

Hudson Insurance Group is currently recruiting for an Azure Data Warehouse Architect. The ideal candidate will also possess the following skill sets. The Azure Data Warehouse Architect will work with the Hudson IT Team, Business & Technology Partners to lead the solution architecture design and delivery of strategic business projects for Hudson Insurance Group. · The ideal candidate will have strong experience with core Azure services related to data and analytics - examples: Synapse (DW), Data Lake, Databricks, Data Factory, Power BI. · A background in data modeling; also designs, implements, and documents data architecture and data modeling solutions is preferred · Experience in Insurance Industry strongly preferred Responsibilities

  • Readiness, provisioning, security and governance relating to cloud platforms;
  • Conduct hands-on development, configuration, or system setup for early stage POCs/POVs.
  • Develop flexible, adaptable, modular and reusable solution architecture designs in collaboration with business stakeholders and the IT development team that align with Enterprise Architecture standards.
  • Work with project managers, developers & technical specialists to ensure alignment of program deliverables to defined solution.
  • Review high-level designs with the technical lead and developers, review code, enforce best practices, debug critical issues, and conduct performance testing to deliver efficient and performant applications.
  • Responsible for identifying technology risk and corresponding mitigation strategies.
  • Implement appropriate solution architecture governance processes and tools while maintaining a key focus on design patterns and technology standards.
  • Act as an enabler of Agile and DevOps practices in collaboration with product delivery and operation support teams.
  • Explore, evaluate and promote technology innovation within the enterprise.
  • Evaluate, learn and assist teams with deploying cloud native technology solutions
  • Drive the strategy and direction for the modernization of Hudson IT Tech portfolio.

Requirements

  • Bachelor’s Degree, Computer Science or Engineering degrees preferred.
  • Hands on architect who is comfortable working with engineers at code/detailed design level.
  • Coding experiences and skills preferred in C#, JavaScript, Angular, SQL and Azure.
  • Experience designing and implementing Enterprise Data Warehouses (EDW) and related technologies;
  • A background in data modeler designs; implements, and documents data architecture and data modeling solutions
  • Experience with core Azure services related to data and analytics - examples: Synapse (DW), Data Lake, Databricks, Data Factory, Power BI;
  • Conduct assessments and define enterprise roadmaps for enabling a data-driven Analytics organization;
  • Provide thought leadership around modern analytics tools and platforms for mid-sized companies to Fortune 500s;
  • Manages facilitated working sessions with technical executives and experts;
  • Aware of approaches and challenges for an Analytics organization at varying maturities;
  • Ability to guide and mentor development teams on sound design and coding principles, best practices in API based, Micro Services and Cloud environments.
  • Ability to work with development teams closely together to review code, debug issues, and conduct performance testing to build efficient and performant applications.
  • Experience in application modularization and adoption of Micro Service Architecture models.
  • Experience in Integration Architectures from Service Bus to API Mediation & Event Bus
  • Ability to abstract-up to harvest patterns and articulate design decisions with non-tech audience
  • Knowledge and experience of insurance underwriting platform architectures is a plus.
  • Experience in Information Security and Risk Management
  • Experience in cloud solution design and implementation of IaaS, PaaS and SaaS
  • Understanding of platform design and technology considerations to build out an ecosystem for internal and external customers., * Ability to effectively communicate complex topics, both written and verbally, with senior leadership.
  • Strong business acumen, ability to quickly understand business needs and develop appropriate solutions.
  • Proven record of accomplishment of high achievement in a team-based culture and in relationship-building and driving change
  • Demonstrated passion and ability to leverage technology to evolve and meet business needs.
  • Exceptional analytical and critical thinking skills, with thorough attention to detail.
  • Excellent planning, documentation and problem-solving skills.

Relevant Experience 10 or more years of experience in one or more of the following architecture domains: Application/Systems; Technology/Infrastructure. 3 or more years of experience as an enterprise architect, technical architect, or senior systems engineer. 2 or more years of experience as a team lead or experience leading projects. Education: Required Bachelor’s Degree OR 4 years relevant experience, OR a combination of college education and relevant experience equivalent to 4 years. TOGAF certification preferred

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www2.jobdiva.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:17 min

Mapping the maturity roadmap for scaled devops adoption

Dominik Krichbaum Dominik Krichbaum · WWC Europe 2026

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

3:46 min

Navigating a career in cloud transformation consulting

Piet Van Dongen · LIVE

3:18 min

Scaling global network engineering through DevOps culture

Stuart Clark · LIVE

Videos

See all

Related articles

See all