IT Data Analytics Specialist - Reporting

Vertiv•Westerville, OH

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.
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.