Apply on Employer Site

Tek Tree LLC · 12 hours ago

Azure Data Integration Architect with Data Mart

Boston, MA

Contract

Onsite

Senior Level

Tek Tree LLC is seeking a Senior Azure Data Integration Architect responsible for designing, developing, and optimizing enterprise data solutions. The role focuses on leveraging Azure Data Factory for data integration to support analytics, reporting, and regulatory needs.

Information Technology & Services

Growth Opportunities

H1B Sponsor Likely

Hiring Manager

Kevin Brown

Responsibilities

Design and maintain EDW, ODS, and Data Mart architectures and data models

Develop and manage Azure Data Factory (ADF) pipelines for batch and incremental data loads

Implement ETL / ELT processes from multiple source systems (on-prem, cloud, APIs)

Ensure data consistency, reconciliation, and flow across ODS, EDW, and Data Marts

Optimize pipelines and queries for performance, scalability, and cost efficiency

Apply tuning techniques such as partitioning, indexing, and parallel processing

Monitor production pipelines, troubleshoot failures, and meet SLA requirements

Implement data validation, error handling, and operational controls

Collaborate with business, analytics, and platform teams to deliver data solutions

Qualification

Azure Data FactoryEDWODSData Mart designSQLData performance tuningETL frameworksBusiness Intelligence OBIEEBusiness Intelligence Power BICloud-based data platformsAPI-based data integrationsDataOps / CI-CDInsurance domain experience

Required

Strong experience in EDW, ODS, and Data Mart design

Hands-on expertise with Azure Data Factory

Strong SQL and data performance tuning skills

Experience with enterprise data integration and ETL frameworks

Hands-on expertise on Business Intelligence (OBIEE and Power BI)

Knowledge of cloud-based data platforms (Azure preferred)

Preferred

Azure Synapse / SQL DW exposure

API-based data integrations

DataOps / CI-CD for data pipelines

Insurance domain experience

Company

Tek Tree LLC

Global Technology Services & Consulting firm focused on Technology & Professional Services.

Founded in 2005

Newark, Delaware, US

201-500 employees

http://www.tektreeinc.com

H1B Sponsorship

Tek Tree LLC has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (27)

2024 (15)

2023 (40)

2022 (60)

2021 (62)

2020 (51)

Funding

Current Stage

Growth Stage

Leadership Team

Mohsin Usman

Chief Technology Officer

Hemanth Reddy Singireddy

Sr. Manager-Client Partner and Delivery

Company data provided by crunchbase