Job Description:
Mandatory requirements:
Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards and utilizing advanced features.
ETL/Microsoft Azure Synapse Analytics experience, including its architecture, data storage options, data ingestion mechanisms and security features.
Dynamics 365 Client and/or F&O report development experience.
Nice to have requirements:
Azure cloud certifications (e.g. azure fundamentals, Azure Power BI Data Analyst Associate)
Dynamics 365 certifications.
Skills and knowledge:
Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
Microsoft Azure Synapse: In-depth knowledge and experience with Azure Synapse Analytics, including its architecture, data storage options (e.g., SQL Data Warehouse, Data Lake Storage), data ingestion mechanisms (e.g., Azure Data Factory), and security features.
Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.
Development experience with Dynamics 365 and understanding of the Common Data Model for Dynamics.
Report development experience for Microsoft Dynamics 365 Customer Engagement (Client) and/or Finance and Operations (F&O)
Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.
PowerBI:
Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.
Experience with SSIS, SSRS
ETL / Azure Platform:
Experience with Azure Synapse Workspaces and/or Azure Data Factory
Azure cloud certifications
Dynamics 365:
Demonstrated software development experience with PowerApps platform, Power Automate, Dynamics Client &F&O and producing reports from Dynamics
SQL / DB:
Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
Azure DevOps:
Demonstrated experience with Azure DevOps for version control, managing code, tracking changes, and collaborating with team members.
Desired Skills and Experience
POWER BI
Any Graduate