IT Data Analytics Specialist Reporting
Westerville, OH - USA
Job Summary
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 organisations 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 companys 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.
Required Experience:
IC
About Company
Work Authorization No calls or agencies please. Vertiv will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need s ... View more