Data Analyst

This role will be responsible for extracting, analyzing, and visualizing data to support business decision-making, as well as investigating and documenting existing data systems, reports, and processes. Reverse engineer existing reports, dashboards, spreadsheets, and legacy SQL logic to understand and document underlying business rules, calculations, and data lineage.

We are seeking a detail-oriented Data Analyst to join our team. This role will be responsible for extracting, analyzing, and visualizing data to support business decision-making, as well as investigating and documenting existing data systems, reports, and processes.

Key Responsibilities

• Write and optimize SQL queries to extract, transform, and analyze data from relational databases
• Design, build, and maintain interactive dashboards and reports in Power BI
• Reverse engineer existing reports, dashboards, spreadsheets, and legacy SQL logic to understand and document underlying business rules, calculations, and data lineage
• Trace metrics and KPIs back to their source systems and transformation logic when documentation is missing or outdated
• Identify data quality issues, inconsistencies, or gaps in existing reporting processes and recommend improvements
• Partner with business stakeholders to understand reporting needs and translate them into data solutions
• Document data definitions, query logic, and dashboard architecture for future maintainability
• Support ad hoc data requests and analysis for various departments Required Qualifications
• Strong proficiency in SQL (joins, subqueries, window functions, query optimization)
• Hands-on experience building reports and dashboards in Power BI (DAX, Power Query, data modeling)
• Demonstrated ability to reverse engineer existing queries, reports, or systems
• Strong analytical and problem-solving skills with high attention to detail
• Ability to communicate technical findings clearly to non-technical stakeholders

Preferred Qualifications

• Experience with ETL processes and data warehousing concepts
• Familiarity with Excel (advanced formulas, pivot tables) as a complement to Power BI
• Experience working with legacy systems or undocumented reporting environments
• Exposure to Python or another scripting language for data analysis