Support internal teams with reliable reporting, analytics, and process automation. This role will be responsible for designing, developing, and maintaining dashboards and reports, building efficient ETL pipelines, writing advanced SQL queries, and leveraging Power BI and DAX to deliver high-quality insights as well as implementing Power Automate workflows to streamline and optimize business processes.
responsibilities :
Collaborate with internal departments to gather requirements for reporting, analytics, and automation.
Design and maintain ETL processes to extract, transform, and load data from various internal systems (ERP, CRM, SQL, Excel, APIs).
Develop and optimize Power BI dashboards, reports, and data models aligned with business needs.
Build advanced DAX measures and calculations to enable complex analytics.
Write, optimize, and maintain SQL queries, views, and stored procedures to support reporting and data preparation.
Implement Power Automate workflows for data refresh, reporting notifications, and process automation.
Validate and reconcile data to ensure accuracy, consistency, and reliability.
Perform ongoing data quality checks and troubleshoot issues across ETL, BI, and automation flows.
Provide ad-hoc analysis and support management with decision-ready insights.
Train and support business users on Power BI, SQL, and Power Automate, encouraging self-service adoption.
Continuously improve the performance, usability, and governance of BI solutions.
requirements-expected :
Understanding of relational databases, data pipelines, and ETL concepts.
Strong proficiency in SQL (query writing, optimization, data extraction).
Proven experience with Power BI (desktop and service).
Solid knowledge of DAX, Power Query (M language), and data modeling.
Hands-on experience with data validation, reconciliation, and quality assurance.
Experience with Power Automate to build workflows and automate repetitive tasks.
Strong analytical, problem-solving, and troubleshooting skills.
Excellent communication skills to work effectively with business stakeholders.