IT Data Analytics Specialist - Reporting

JOB DESCRIPTION

Job Title: Senior Analytics & Report Developer

Function / Department: IT Data Analytics

Reports To: Reporting Lead

Role Overview

We are seeking a highly skilled Senior Analytics & Report Developer with deep experience in Power BI, AWS QuickSight, Streamlit, strong mandatory SQL expertise, and modern data visualization practices. The ideal candidate will play a critical role in designing, developing, and optimizing analytical dashboards, interactive applications, and data products that support business decision-making across the organization. This role is central to our strategic journey from PowerBI to AI-driven analytics, enabling broader Analytics capabilities alongside PowerBI expertise for our relevant business use cases. This position requires a strong blend of technical expertise, analytical thinking, data storytelling, and stakeholder management.

Key Responsibilities

Reporting & Dashboard Development

• Design, develop, and maintain advanced Power BI dashboards, reports, and datasets.
• Design, develop, and maintain AWS QuickSight dashboards, analyses, and datasets, leveraging the SPICE engine for high-performance analytics.
• Build interactive Streamlit applications to support advanced analytics and data-driven workflows.
• Translate business requirements into intuitive, visually compelling, and accurate reporting solutions.
• Optimize report performance, data models, measures, and queries for scalability and speed.

Data Modeling & Integration

• Develop efficient data models using best practices for semantic layers.
• Leverage mandatory strong SQL expertise to write complex queries, optimize performance, and ensure data accuracy across all integration layers.
• Integrate data from multiple sources (databases, APIs, Snowflake, AWS data services, etc.).
• Collaborate with Data Engineering teams to define and refine data structures enabling analytical consumption across both platforms.

Business Partnership

• Partner with business users to understand needs, gather requirements, and translate them into technical solutions.
• Provide training, guidance, and best practices for self-service reporting .
• Present insights and analytical findings in clear, actionable terms to non-technical stakeholders.
• Support the organisation's transition from traditional BI to AI-augmented analytics, identifying use cases where AI can enhance decision-making.

Governance, Quality & Standards

• Ensure adherence to data visualization standards, governance policies, and security protocols across environments.
• Implement version control, documentation, and lifecycle management for analytical assets.
• Proactively identify data issues and drive remediation initiatives with cross-functional teams.

Innovation & Continuous Improvement

• Evaluate and introduce new features in Power BI (Fabric, DAX advancements, etc.) and AWS QuickSight (ML Insights, QuickSight Q, Generative BI capabilities).
• Identify opportunities to automate manual reporting processes and leverage AI/ML for predictive and prescriptive analytics.
• Drive adoption of modern, scalable analytics patterns, supporting the company's PowerBI-to-AI transformation journey.
• Explore and implement generative AI capabilities within AWS QuickSight to enable natural language querying and automated insight generation for business users.

Required Qualifications

• 5+ years of experience in BI/report development, with proven expertise in Power BI.
• Hands-on experience with AWS QuickSight, including dashboard creation, dataset management, SPICE optimization, and analyses.
• Strong hands-on experience with Streamlit for building interactive Python-based applications.
• Expert-level knowledge of DAX, Power Query, data modeling, and visualization best practices.
• Strong SQL knowledge is mandatory - the candidate must demonstrate expert-level proficiency in writing complex queries, performance tuning, and working with enterprise data warehouses (e.g., Snowflake).
• Solid understanding of data governance, security, and report lifecycle management.
• Strong analytical and problem-solving skills with the ability to interpret complex datasets.
• Excellent communication skills and stakeholder management capabilities.
• Familiarity with cloud-based BI and AI/ML analytics platforms.

Preferred Qualifications

• Experience with Python for data manipulation and integration with Streamlit.
• Knowledge of Microsoft Fabric ecosystems.
• AWS certifications (e.g., AWS Certified Data Analytics, AWS Certified Cloud Practitioner).
• Experience with AWS QuickSight Q (natural language querying) and ML Insights for automated anomaly detection and forecasting.
• Experience with generative AI tools and their application in business analytics.
• Experience working in agile environments and using CI/CD tools for BI assets.
• Background in enterprise reporting for Finance, Supply Chain, Commercial, or Operations.

Soft Skills

• Strong sense of ownership and accountability.
• Ability to translate technical topics into business language.
• Attention to detail and passion for clean, intuitive design.
• Ability to manage multiple priorities and deliver high-quality output under tight timelines.
• Curiosity and enthusiasm for AI-driven innovation in analytics.