• Collaborate Business Analysts to translate business requirements into scalable and efficient data analytics solutions utilizing Microsoft technologies. • Exhibit in-depth knowledge and hands-on experience architecting solutions with Microsoft Fabric, Azure Synapse Analytics, Azure Data Services, Power BI, SQL Server, Azure Analysis Services, and other relevant Microsoft tools. • Develop end-to-end data analytics architectures, including data integration, data warehousing, data modeling, data visualization, and reporting, leveraging Microsoft platforms. • Review existing and data architectures to identify gaps, recognize risks, recommend improvements, and ensure alignment with enterprise standards and future scalability. • Implement data integration pipelines using Microsoft Azure Data Factory, Azure Data Lake, and other relevant tools to extract, transform, and load data from various sources into a unified data platform. • Create visually appealing and interactive dashboards, reports, and visualizations using Microsoft Power BI, enabling users to gain valuable insights from data. • Identify performance bottlenecks and implement optimizations to improve data processing, query performance, and overall system efficiency. • Partner with our Security practice to ensure data security, privacy, and compliance with relevant regulations and standards are met. • Collaborate with cross-functional teams, providing technical leadership and guidance to clients, data engineers, analysts, and other stakeholders to ensure successful project delivery. • Keep abreast of the latest advancements in data analytics technologies (Microsoft based and others) and industry trends, continuously enhancing your expertise and applying best practices in solution design and implementation.

• Define key KPIs, product metrics, and reports that drive decision making at the highest level. • Design, build, and evangelize source-of-truth reporting tools for finance, sales ops, and technical product executives, to arm them with the needed information to drive their day to day decision making. • Lay the foundation for the growing analytics team to empower cross functional engineering and product teams to make data driven decisions and fast experimental iteration. • Build and publish data visualization and dashboards for exec visibility into product, sales and operations data

• Collect, clean, validate, and analyze large datasets across financial and operational systems to support metrics, dashboards, and decision-making. • Develop and maintain data visualizations, dashboards, and automated reports using tools such as Power BI and Excel. • Perform data reconciliation, quality assurance checks, and financial system research to resolve discrepancies, interpret trends, and ensure data integrity. • Maintain invoicing records, funding documentation, and contract tracking measures while leveraging analytics to identify anomalies or risks. • Conduct internal and agency audits to ensure compliance with contract usage, funding, and financial regulations. • Collaborate with technical teams on Power Platform solutions, including Power Apps, Power Automate, and process automation initiatives. • Identify and implement process improvements to enhance data pipelines, reporting workflows, and analytical efficiency. • Present insights, performance trends, and operational metrics to stakeholders in a clear and structured format, supporting decision-making and team training.

• Partner with Product teams to define success metrics, design experiments, and evaluate feature impact • Partner with fractional squad analysts where they exist; serve as the primary analytics partner for squads without dedicated coverage and help evolve our organisational model for product analytics • Be hands-on with analysis, dashboards, and metric development while building the foundations for a scalable product analytics practice • Define, own, and govern product metrics and KPIs in alignment with our company-wide unified KPI framework-ensuring consistency, clarity, and trust in how we measure product performance in alignment with business goals • Build and maintain core product health dashboards in partnership with analytics engineering as we’re transitioning to self-service via Lightdash and maturing our analytics platform • Conduct deep-dive analyses on user behavior, funnel performance, and cohort trends to surface opportunities and diagnose issues • Design and analyze A/B tests and experiments, establishing best practices for experimentation rigor • Translate complex analytical findings into clear recommendations for technical and non-technical stakeholders, including executive leadership • Partner with data and product teams, to define data requirements and ensure product event tracking meets analytical needs