Tek Tree LLC · 12 hours ago
Azure Data Integration Architect with Data Mart
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.
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
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.
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 StageLeadership Team
Company data provided by crunchbase