Data Warehouse Developer

Job Description:

10+ years of experience in Business Intelligence, Data Warehousing, SQL, and Data Modeling.
Strong understanding of ETL processes, OLAP concepts, SQL programming, and Repo rting.
Expertise in ETL (SSIS/Pentaho Data Integration/Informatica) and DBMS (SQL Server/PostgreSQL).
Experience in SQL Server Reporting Services (SSRS), PowerBI or Tableau.
Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions; solid communication, interpersonal, leadership, and collaborative skills and a demonstrated ability for creative problem solving.
Experience in Microsoft Azure (Azure Data Factory, Azure Data Lake), and Databricks. Experience in migrating on-premises data/process to Microsoft Azure using Azure Data Factory.

Roles and Responsibilities:

Design robust Logical Data Models and stewarding the data design of the asset and ensuring alignment with the larger roadmap goals.
Work closely with business users to determine business requirements, lead requirements gathering meetings, propose future enhancements, resolve user queries or any issues.
Develop and define application scope and objectives. Prepare specifications for development of data pipelines for migrating data in both OLTP and Data Warehouse environments.
Design, develop, debug, and support complex data integration interfaces and processes (including stored procedure and complex queries) using various tools and technologies including Pentaho/SSIS/Informatica, Powerbi, SQL, and PostgreSQL/SQL Server.
Create database tables, procedures, views, functions, indexes using SQL programming.
Impact analysis on upstream data/process changes to Data Warehouse and Reporting systems.
Design database objects as necessary to meet new business requirements for reporting.
Conduct technical design and code reviews.
Establish, enhance, implement, enforce, and maintain ETL best practices. Own the change request process and coordinate with other teams as necessary.

Skills :