Overview
Skills
Job Details
Requirements:
5+ years of experience in Data Warehousing and Business Intelligence
3+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
5+ Years in SSIS and use of Stored Procedures.
2+ Years of experience in PowerBI
Ingest and aggregate data from both internal and external data sources to build our data warehouse.
Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
Deep understanding of relational database design concepts and SQL programming
Experience guiding/mentoring developers with lesser experience.
Requires strong analytical, conceptual, and problem-solving abilities.
Strong experience with business intelligence and data warehousing design principles and industry best practices.
Bachelor's degree preference in computer/information sciences or business/commerce.
Good to have:
1-2 Years in Azure Data Warehouse (Synapse)
Recommended 1-2 Years in Azure Data Factory, SQL VMs, build and maintain ETL and Data lake.
Skills Required/Desired Amount of Experience:
Data Warehousing and Business Intelligence | Required | 5 |
BI development leveraging the Microsoft SQL Server 2014+. Needs to be an expert in T-SQL | Required | 5 |
SSIS and use of Stored Procedures | Required | 5 |
Azure Data Factory, SQL VMs, build and maintain ETL | Required | 2 |
Azure Data Warehouse (Synapse) | Highly desired | 2 |
Power BI | Required | 2 |