Data Warehouse

Data Warehouse Draper, UT Job Details $100,000

• $125,000 a year 1 day ago Benefits Commuter assistance Health insurance Dental insurance Vision insurance Pet insurance Qualifications Databricks Data lake DevOps SSRS Azure Data Factory Stakeholder management Full Job Description Role
• Data Warehouse Engineer Experience Required
• 10+ Years Must Have Technical/Functional Skills 10+ years of experience SSRS , Databricks, Data Lake Storage Gen2, Azure Analysis Services CI/CD, Git, Jenkins/GitHub/Azure DevOps pipelines Strong communication, stakeholder management, and problem-solving skills.

Roles & Responsibilities Architecture & Strategy Designing and implementing cloud-based data warehouses using Azure Synapse Analytics (formerly SQL DW) to create a single source of truth. Building pipelines with Azure Data Factory (ADF) or Azure Databricks to ingest, transform, and load data from diverse sources into the warehouse. Developing dimensional models (fact and dimension tables) within the Gold layer of the Medallion architecture to enable efficient BI reporting. Tuning SQL queries, managing indexes, partitioning, and scaling Synapse compute resources to maintain high performance. Integrating structured relational data with unstructured data from Azure Data Lake Analyze COBOL programs, copybooks, JCL workflows, CICS/IMS transactions, DB2 schemas, and VSAM files.

Base Salary Range :

$100,000 to $125,000

Per Annum TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage:

Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support:

Maternal & Parental Leaves.

Insurance Options:

Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth:

Commuter Benefits & Certification & Training Reimbursement.

Time Off:

Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance:

Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. Location Draper, UT Job Function

TECHNOLOGY

Role Engineer Job Id 407280 Desired Skills Datawarehousing Salary Range $100,000

• 125,000 a year