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.
Data Warehousing and Business Intelligence
Required
5
Years
BI development leveraging the Microsoft SQL Server 2014+. Needs to be an expert in T-SQL
Required
5
Years
SSIS and use of Stored Procedures
Required
5
Years
Azure Data Factory, SQL VMs, build and maintain ETL
Required
2
Years
Azure Data Warehouse (Synapse)
Highly desired
2
Years
Power BI
Required
2
Years
Bachelor's degree