Data Analyst

The Data Analyst supports Power BI reporting, data requests, report generation, data quality initiatives, and day-to-day support tickets. This role works with stakeholders and senior technical staff to turn business questions into accurate, useful, and well-documented data outputs.

SUPERVISION RECEIVED AND EXERCISED

Reports to and receives general direction from ACSA’s Data Engineer. Works independently and uses expertise and experience to exercise discretion over methods used to perform tasks. Independent contributor.

ESSENTIAL DUTIES & RESPONSIBILITIES

Deliver organizational data analysis, including:

• Power BI Development: Develop, maintain, troubleshoot, and optimize Power BI dashboards, reports, semantic models, DAX measures, refresh behavior (including Direct Lake where applicable), and report performance.
• Data Requests & Analysis: Clarify requirements, define metrics, and complete data requests using SQL, Power BI, and other appropriate tools. Outputs may include dashboards, datasets, queries, extracts, regular reports, or analysis summaries.
• Data Quality: Investigate discrepancies between source and reported data, document findings, support validation processes, and help maintain consistent business definitions and metric standards.
• Ticket Management: Triage, prioritize, and resolve data-related support tickets; follow up with stakeholders; document resolutions; and escalate complex technical issues to the Data Engineer when needed.
• Business System Support: Field data questions related to Power BI, Dynamics 365 Customer Engagement, Dynamics 365 Finance & Operations, and other business systems, primarily working from curated reporting datasets rather than raw source data.
• Documentation: Document report logic, SQL queries, metric definitions, dependencies, and recurring support processes in the team's shared knowledge base.