ESSENTIAL DUTIES
Reporting & Dashboard Development
- Design, build, and maintain Power BI dashboards and reports for operations, finance, sales, and executive stakeholders.
- Develop and manage semantic data models in Power BI using DAX, including measures, calculated columns, and row-level security (RLS).
- Analyze and tune underperforming reports and queries to improve load times and reliability.
- Establish and document self-service BI standards and a shared metrics catalog.
Data & SQL
- Write complex T-SQL queries, CTEs, window functions, multi-table joins against Azure SQL and Microsoft Fabric.
- Collaborate with data engineers to define data requirements, validate pipeline outputs, and ensure data quality upstream of reporting.
- Identify data anomalies and inconsistencies; work upstream to resolve at the source rather than patching in reports.
Stakeholder Collaboration
- Partner with department leaders across operations, finance, and customer experience to translate business questions into measurable data products.
- Lead requirements-gathering sessions and translate ambiguous requests into defined scopes with clear deliverables and timelines.
- Communicate findings clearly to non-technical audiences — written, visual, and verbal.
- Contribute to special projects, operational improvement initiatives, and data-driven strategy efforts.
Team & Process
- Recommend and implement process improvements within the analytics function.
- Uphold data governance, security, and confidentiality standards across all reporting environments.
- Participate in sprint planning and contribute to team workflows using Azure DevOps or equivalent tooling.