BI Data Engineer
Job Description
ProV is an award winning global technology consulting firm. Specializing in IT strategy, advisory, implementation, management and optimization. Our proven technology solutions not only improve operations, but provide better business outcomes and results.
We specialize in: Cloud Technology, IT Strategy & Advisory, Software Implementation, Business Process Optimization,and Intelligent Operations.
We are a certified partner of the top technology platforms used today, including IFS Applications, Microsoft Azure, Tanium, ServiceNow, Boomi, Sugar CRM, and UiPath.
Why Join Us
Strong Company Culture fostering collaboration, growth, engagement and Work Life Balance
Innovative Work Environment with recognition and rewards for team members who excel and give their best performance for the company and its clients.
Competitive and above market standard compensation and benefits are offered to team members including HMO and Insurance on 1st day.
ProV is committed to Diversity, Equality, and Inclusion
Business Intelligence Data Engineer
As a BI Data Engineer you will be part of the Business Intelligence (BI) team and will be responsible for delivering BI solutions and assuming control of operational application management to ensure the BI platform is fully functional, updated, and available at all times.
You will primarily be working with our modern Azure-based BI platform. Code is developed and deployed using Azure DevOps, employing Infrastructure as Code for efficiency and scalability. End solutions are typically delivered for consumption using Azure Analysis Services.You will also participate in maintenance and changes to our legacy platform based on Microsoft SQL Server 2016 and SQL Server Analysis Services.
Responsibility
Business support through continuous optimization and design, development, and deployment of Data Warehouse, ETL and Tabular Models
Technical support for the BI platform, including documentation, development, operational support and life-cycle management.
Deliver ongoing support as well as ad hoc training in how the BI applications work.
Work closely with the rest of the BI team members on translating business demands into technical specifications with subsequent design, development and maintenance of data warehouse and BI solutions.
Quality assurance and user acceptance testing by writing test plans and communicating on test issues directly with testers assigned to the project.
Active involvement in BI projects and coordination between the Data Engineers and BI Partners.
Profile
SSAS (Tabular and multidimensional): 6 years or moreT-SQL development: 5 years or more
Azure Data Factory: 4 years or more
Agile development: 2 years or more
Data warehouse design and development: +3 years
Excellent understanding of dimensional modeling as well traditional database modeling.
SSIS ETL: 5 years or moreMDX development: 2 years or more
Worked with Azure DevOps Repos (or TFS) as source control and branching/deployment system.
A relevant bachelor's or master's degree.
You will be working closely with the rest of the BI team as well as the Intelligent Automation, Master Data Management, and Data Scientists so excellent communication skills are necessary.
You are fluent in both oral and written English.
Experience with Continuous Integration (CI) and deployment within a BI/DW context
Experience with full-lifecycle implementation of BI and data projects: Starting from zero to full production.
Experience with Power BI is a plus.