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.