1) Work with business and technical teams to gather requirements and translate them into technical solutions.
2) Design and develop ETL/ELT pipelines using SQL Server Integration Services (SSIS) and SQL.
3) Build and maintain SSAS Tabular semantic models, including relationships, measures, calculated columns, and hierarchies.
4) Develop reports and dashboards using Power BI / Power BI Report Server.
5) Develop complex T-SQL queries, stored procedures, views, and functions.
6) Ability to identify opportunities where AI can automate or improve existing data and BI processes.
Requirements
1) 2+ years of experience in Data Engineering, BI Development, or a similar role.
2) Strong knowledge of Microsoft SQL Server and T-SQL, SSIS, and ETL development.
3) Strong experience with Power BI, including DAX, Power Query, data modeling, and report development.
4) Experience designing data warehouses, including staging, fact, and dimension structures.
5) Experience with SSAS Tabular and semantic data modeling.