Senior Data Warehouse Engineer

ARCHER Transnational Systems Pvt. Ltd; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

An established industry player is on the lookout for a Senior Data Warehouse Engineer to lead the charge in data management and optimization. This role is pivotal in transforming raw data into insightful business intelligence, ensuring that data integrity is maintained across all platforms. You will engage with cross-functional teams, developing robust ETL processes and dimensional models while mentoring junior members. If you thrive in a collaborative environment and have a passion for data-driven decision-making, this opportunity is perfect for you. Join a team where your expertise will drive significant impact in a forward-thinking organization.

Qualifications

• 7+ years of experience in SQL Server and Data Warehouse development.
• Expertise in ETL processes using SSIS and Python.

Responsibilities

• Manage a single version of truth for data and develop ETL processes.
• Collaborate with teams to integrate data from various sources.

Skills

SQL Server

Data Warehouse

Dimensional Modeling

SSIS

Python

Power BI

Git

JIRA

Problem-solving

Analytical Skills

Education

Bachelor's degree in Computer Science

Master's degree in Information Technology

Tools

Microsoft SSIS

Azure SQL

Azure Data Factory

Azure Databricks

Snowflake

Job description

Job Summary

We are seeking a highly skilled Senior Data Warehouse Engineer to manage a single version of the truth of data, convert business entities into facts and dimensions, and integrate data from various sources. The role involves developing ETL processes, optimizing performance, and collaborating with cross-functional teams to support business analysis and decision-making.

Key Responsibilities

• Data Warehouse Development: Responsible for managing a single version of the truth and turning data into critical information and knowledge that can be used to make sound business decisions.
• Dimensional Modeling: Convert business entities into facts and dimensions to provide a structured and efficient data model that supports accurate and insightful business analysis.
• Data Integration: Collaborate with cross-functional teams to integrate data from various source systems such as Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, and Excel files.
• Data Transformation: Develop and maintain ETL processes using Microsoft SSIS, Python or similar ETL tools to load data into the data warehouse.
• Performance Optimization: Optimize queries, indexes, and database structures to improve efficiency.
• Requirement Analysis: Work closely with key users and business stakeholders to define requirements.
• Documentation: Maintain comprehensive technical documentation for data warehouse processes, data integration, and configurations.
• Team Collaboration: Mentor and guide junior team members, fostering a collaborative environment.

Required Skills & Qualifications

• Must have
• Bachelors or Masters degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience with Microsoft SQL Server.
• Expertise in building Data Warehouse using SQL Server.
• Hands-on experience Dimensional Modeling using Facts and Dimensions.
• Expertise in SSIS and Python for ETL development.
• Strong experience in Power BI for reporting and data visualization.
• Strong understanding of relational database design, indexing, and performance tuning.
• Ability to write complex SQL scripts, stored procedures and views.
• Experience with Git and JIRA.
• Problem-solving mindset and analytical skills.
• Excellent communication and documentation abilities.

• Nice to Have
• Experience with cloud-based SQL databases (e.g., Azure SQL, Azure Synapse).
• Experience with cloud-based ETL solutions (Azure Data Factory, Azure Databricks).
• Familiarity with CI/CD for database deployments and automation tools.
• Knowledge of big data technologies like Snowflake