Sr Data Analyst - BI & Reporting

The Sr Data Analyst - BI & Reporting will play a key role in developing end-to-end reporting solutions, from data collection and transformation to report generation and visualization. This role involves working on the cutting edge of data engineering and analytics, leveraging machine learning, predictive modeling, and generative AI to drive business insights.

Job Description

Job Description Summary

The Sr Data Analyst - BI & Reporting will play a key role in developing end-to-end reporting solutions, from data collection and transformation to report generation and visualization. This role involves working on the cutting edge of data engineering and analytics, leveraging machine learning, predictive modeling, and generative AI to drive business insights.

Roles and Responsibilities

• Design visualizations and create dashboards/reports using Power BI (good to have Tableau experience).
• Explore, clean, and visualize data sets to prepare for analysis/reporting, ensuring data quality and consistency.
• Develop and maintain BI semantic data models for large-scale data Warehouses/ Data Lakes eventually getting consumed by reporting tools.
• Leverage SQL and big data tools (e.g., Hadoop, Spark) for data manipulation and optimization.
• Build advanced data models and pipelines using SQL and other tools.
• Ensure data quality, consistency, and integrity throughout the data lifecycle.
• Collaborate closely with data engineers, analysts, and other stakeholders to understand data requirements and optimize the data flow architecture.
• Document data processes, data architecture modelling/flow charts, and best practices for future reference and knowledge sharing.

Desired Characteristics & Technical Expertise

• 6+ years of experience in data analytics, data mining/integration, BI development, reporting and insights.
• Strong analytical skills with the ability to interpret raw data, identify patterns, connect the dots, understand the gaps and connect insights across multiple projects to drive meaningful business insights and actionable outcomes.
• Must have prior experience in Commercial, Sales, Renewals & Services reporting.
• Proficient knowledge in salesforce (SFDC), Fusion, SAP & Oracle P6 tools.
• Strong knowledge of SQL and experience with big data technologies such as Hadoop, Spark, or similar tool for data massaging/manipulation.
• Develop advanced visualization/reports to highlight trends, patterns, and outliers, making complex data easily understandable for various business functions.
• Implement UI/UX best practices to improve navigation, data storytelling, and the overall usability of dashboards, ensuring that reports are actionable and user-friendly providing the desired insights.
• Experience with data modeling techniques, including OLAP and data marts.
• Hands-on experience with data integration tools and platforms.
• Knowledge of data architecture principles and best practices for building scalable data solutions.
• Strong problem-solving skills with attention to detail in data processing.
• Ability to work independently and collaborate effectively across teams.
• Excellent communication skills to convey technical solutions to non-technical stakeholders.
• Self-motivated with a drive to continuously improve data processes and explore new technologies.

Business Acumen: Understands the technology landscape, up to date on current technology trends and new technology, brings new ideas to the team. Displays understanding of the project's value proposition for the customer. Shows commitment to deliver the best value proposition for the targeted customer. Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization visionLeadership Attributes: Voices opinions and presents clear rationale. Uses data or factual evidence to influence. Learns organization vision statement and decision-making framework. Able to understand how team and personal goals/objectives contribute to the organization vision. Completes assigned tasks on time and with high quality. Takes independent responsibility for assigned deliverables. Seeks to understand problems thoroughly before implementing solutions. Asks questions to clarify requirements when ambiguities are present. Identifies opportunities for innovation and offers new ideas. Takes the initiative to experiment with new software frameworks Adapts to new environments and changing requirements. Pivots quickly as needed. When coached, responds to need & seeks info from other sources.