Remote Full Time or Part Time MS Data Engineer with SSIS, SSAS, SSRS, Power BI and MS Fabric; Local candidates only
Posted 5 days ago by 1763047896
Negotiable
Outside
Remote
USA
Summary: The role of Data Engineer involves working on a project in Denver, focusing on the Microsoft BI stack, including SSIS, SSAS, SSRS, and Power BI. The engineer will collaborate with the BI team and customers to gather requirements, create/update SSIS packages, and develop tabular models and dashboards. Additionally, the role includes working with Microsoft Fabric and updating pipelines as needed. Candidates should have significant experience in Business Intelligence and Microsoft SQL Server technologies.
Key Responsibilities:
- Working with the BI team and customers to understand the requests and gather requirements
- Create or update SSIS packages to extract data from various data sources and create/update tabular model using SSAS
- Following processes and procedures, documentation requirements, and knowledge transfer of work completed
- Create tabular models and Power BI dashboards to visualize the data for the customer as needed
- Adding or updating pipelines in Microsoft Fabric using a medallion architecture (Bronze, Silver, Gold)
Key Skills:
- 3+ years of experience in Business Intelligence design and delivery
- 3+ years of experience with Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Report Services (SSRS), and Microsoft Power BI
- Strong proficiency in DAX, Power Query, and data modeling
- Ability to communicate effectively with both technical and non-technical stakeholders
- Microsoft Fabric and/or Azure integrations experience is a strong plus
Salary (Rate): undetermined
City: Denver
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
For one of our ongoing project at Denver, we are looking for a Data Engineer to assist with completing work in Microsoft BI stack (SSIS, SSAS, SSRS and Power BI). The deliverables would include:
- Working with the BI team and customers to understand the requests and gather requirements
- Create or update SSIS packages to extract data from various data sources and create/update tabular model using SSAS
- Following processes and procedures, documentation requirements, and knowledge transfer of work completed
- Create tabular models and Power BI dashboards to visualize the data for the customer as needed
- We are also rolling out Microsoft Fabric using a medallion architecture (Bronze, Silver, Gold). This role could also work on adding or updating pipelines in Microsoft Fabric.
Experience
- 3+ years of experience in Business Intelligence design and delivery.
- 3+ years of experience with Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Report Services (SSRS), and Microsoft Power BI
- Strong proficiency in DAX, Power Query, and data modeling.
- Ability to communicate effectively with both technical and non-technical stakeholders.
- Microsoft Fabric and/or Azure integrations experience is a strong plus.