Key Facts

Remote From:

Full time

Mid-level (2-5 years)

English

Hard Skills

SQL Server Reporting Services Performance Systems Analysis Microsoft Business Intelligence SQL (Programming Language) Microsoft SQL Server Data Engine (MSDE) Microsoft Dynamics Data Warehouse Architectures ETL (Extract Transform Load) Power BI

Other Skills

•
Communication

Roles & Responsibilities

4 to 5 years of experience in MSBI (SSRS, SSIS, SSAS) development.
Extensive experience with Microsoft BI Stack and SSRS/SSIS at an advanced level.
Hands-on experience in designing and implementing Data Warehousing solutions.
Strong knowledge of SQL Server, performance tuning, and Microsoft Dynamics AX ERP.

Requirements:

Develop and support SSRS reports and SSIS ETL processes.
Design and implement Data Warehousing solutions based on business requirements.
Optimize SQL procedures for performance and efficiency.
Collaborate with teams to improve BI solutions across various ERP modules.

Job description

We are looking for 5 to 7 years of MSBI (SSIS, SSRS and SSAS) Developer who has worked on

development and support experience in SSRS reports and SSIS including technical design and support

different phases of SDLC.

Technical Experience:  Required 4 to 5 years of experience in MSBI (SSRS, SSIS and SSAS) development.
 Extensive experience in working with Microsoft BI Stack, SSRS and SSIS at an advance level.
 Extensive experience with SSIS ETL processes.
 Handson experience in design and implementation of Data Warehousing solutions
 Demonstrated proficiency authoring basic to complex queries in SQL & familiarity in underlying
AX applications database architecture.
 Extensive experience in working on BI solutions in various ERP subject areas (Sales, Inventory,
Quoting, Order Management, Purchasing, Shipping, Costing, Pricing, Accounts Payable, Accounts
Receivable, General Ledger). Microsoft Dynamics AX ERP experience is a must.
 Strong knowledge on SQL Server and Performance tuning.
 Advanced SQL skills to produce procedures based on business functional requirements.
 Has the ability to see potential performance enhancements on the current BI SQL procedures
 Must understand the AX Da Vinci database schema to a high level to efficiently provide a
working solution for the change requests.
 Excellent communication skills both oral and verbal
 Reviews, identifies areas for improvement and makes recommendations to leadership.
 4 year degree from an accredited collegeuniversity in Information Systems or related field or
equivalent related experience
 Working knowledge of Power BI