Software Engineer Power BI analyst role
STEC Technologies · Oct 2022 – Aug 2023
- Designed and maintained automated stakeholder-facing business intelligence reports and dashboards using SQL and Power BI, ensuring data accuracy, integrity, and consistency across all reporting outputs.
- Gathered reporting and data requirements from cross-functional business teams and translated them into scalable BI solutions supporting business planning and process improvement decisions.
- Data extracted, cleaned, and analysed data from SQL Server and flat files to identify trends and patterns, delivering actionable insights for stakeholder decision-making.
- Built and maintained ETL pipelines to automate recurring data refreshes, improving report turnaround time and the reliability of data used in business reviews.
- Designed data models in Power BI using Star and Snowflake schemas and created DAX calculations to optimize SQL-driven reporting for business partners and leadership.
- Monitored key business KPIs and conducted trend analysis and forecasting to support recommendations on business opportunities and operational improvements.
- Designed KPI cards, heatmaps, and custom dashboard visuals to communicate complex findings clearly to non-technical stakeholders, and documented reporting processes and standards.


