Senior Analytics Engineer - Power BI Development [T500-29608]

H.E. Services India; Hyderabad; On-site; INR 700,000 - 1,200,000; Full time

Job summary

H.E. Services India in Hyderabad seeks a data analytics specialist to design and deliver advanced Power BI reporting solutions.

You will extract, model, and visualize data from diverse sources, implement governance, security, and data lineage, and collaborate with analysts, stakeholders, and engineers to enable data-driven decisions. You will build interactive dashboards, use DAX for complex calculations, and leverage PySpark/Spark SQL for transformations, while ensuring performance and

Qualifications

• 3–5 years of experience with relational databases and star schema design.
• Advanced SQL query development and data transformation using PySpark/Spark SQL.
• Experience in building Power BI reports, data models, and DAX calculations.
• Experience with row-level security, Power Query optimization, and data governance.
• Hands-on experience with AI/GenAI in analytics and reporting is a plus.

Responsibilities

• Collaborate with cross-functional teams to translate business requirements into technical solutions.
• Design, develop, and optimize Power BI reports and dashboards.
• Implement data governance, security, and data lineage documentation.
• Manage data integrations from diverse sources and develop data models.
• Use Azure DevOps to track user stories and project tasks in Agile workflows.
• Perform advanced data analysis using DAX and SQL.

Skills

SQL

Data analysis

Stakeholder management

Cross-functional collaboration

Data modeling

Tools

Power BI

Azure DevOps

GitHub

Visual Studio Code

PySpark

Spark SQL

Job description

A legacy of excellence, driving innovation and personalized service to create exceptional customer experiences.

About H.E. Services:

At H.E. Services vibrant tech Center in Hyderabad, you’ll have the opportunity to contribute to technology innovation for Holman Automotive, a leading American fleet management and automotive services company. Our goal is to continue investing in people, processes, and facilities to ensure expansion in a way that allows us to support our customers and develop new tech solutions.

Holman has come a long way during its first 100 years in business. The automotive markets Holman serves include fleet management and leasing; vehicle fabrication and up fitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States.

Join us and be part of a team that’s transforming the way Holman operates, creating a more efficient, data-driven, and customer-centric future.

JOB INPUTS:

• Collaborate with cross-functional teams, including business analysts, stakeholders, and end-users, to gather, refine, and translate business requirements into robust technical solutions.
• Serve as a bridge between technical and non-technical stakeholders to ensure alignment and clarity.
• Extract, integrate, and analyze data from diverse sources, such as databases, spreadsheets, and
• APIs, to support data-driven decision-making and analytics initiatives. Partner with data engineering teams to acquire, cleanse, and transform data, developing and maintaining sophisticated data models.
• Manage complex data integrations, including configuring data source connections, handling intricate data structures, and performing advanced data transformations.
• Independently design, develop, and optimize visually compelling and interactive Power BI reports and dashboards. Leverage advanced Power BI features such as bookmarks, drill-through navigation, and custom themes to enhance user experience.
• Perform advanced data analysis using DAX to create calculated measures, solve complex business challenges, and support in-depth financial, statistical, or performance analyses.
• Implement and enforce data governance practices, including role-level security, data access controls, and documentation of data lineage.
• Ensure compliance with data security, privacy, and regulatory standards throughout the development lifecycle. Troubleshoot and resolve Power BI-related issues, ensuring high data accuracy, integrity, and visualization quality.
• Optimize report and dashboard performance by improving data queries, data model design, and rendering speed.
• Utilize source control systems within Power BI projects to maintain version control and foster effective collaboration with other developers.
• Leverage Azure DevOps for organizing, tracking, and managing User Stories and tasks within an Agile project management framework.
• Stay informed on the latest Power BI features and industry trends to continuously improve reporting capabilities and technical proficiency.
• Demonstrate self-motivation, creative problem-solving, and a proactive approach to addressing challenges and contributing to project and team success.
• 3-5 years of experience working with relational databases and star schema design, including advanced SQL query development, optimization, and the use of Common.
• Table Expressions (CTEs), window functions, and PySpark / Spark SQL for data extraction and transformation.
• 3-5 years of experience using Power BI for creating sophisticated dashboards, reports, and data models, with expertise in writing advanced DAX calculations, optimizing Power Query for complex transformations, and implementing row-level security and contextual filtering within reports.
• Hands-on experience in evaluating, piloting, and operationalizing AI/GenAI solutions across Analytics & Reporting functions.
• Leveraged AI/GenAI technologies to drive automation, strengthen self-service capabilities, and improve reporting effectiveness.
• Delivered measurable value by reducing project delivery timelines, improving operational efficiency, and enabling faster access to actionable insights
• Demonstrated ability to independently design and create interactive and visually compelling reports and dashboards using Power BI.3-5 years of experience developing and maintaining complex data models, including establishing relationships, hierarchies, and calculated columns in Power BI.
• Manage data integration tasks, including data source connections and data transformation processes.
• 3-5 years of experience Handling complex data transformation and ETL processes, including handling data from multiple sources and dealing with complex data structures.
• 2-4 years of experience in project management using Azure DevOps, with a proven ability to manage workflows, timelines, scoping, documentation, and cross-functional collaboration independently.
• 1-2 years of experience using version control systems (Github) and integrated development environments (IDEs) such as Visual Studio Code, with experience managing code repositories, conducting code reviews, and applying version control best practices.
• Creative, advanced problem-solving skills.
• The ability to transfer prior experience to new assignments.
• Excellent organizational skills and the ability to coordinate and manage multiple priorities while maintaining a high quality of work.
• Self-motivated and able to structure one's work plan with minimal supervision.
• Works well in a collaborative environment.
• Must be able to think critically and use logical reasoning to solve data and business challenges.
• Demonstrate leadership of projects in high visibility situations and critical business projects.
• Ability to execute all phases of a project with minimal oversight.
• Excellent presentation skills to communicate the purpose, value, and details of data analytic projects.
• Ability to write technical requirements and technical documentation.
• Reasoning and negotiation are required when navigating user requests v. technical feasibility and workload. These conversations may be at the manager, director or even VP level depending on the nature of the request.
• It is often necessary to adapt oneself and influence the working habits of others; projects are typically assigned to 2-3 analysts, often with diverse cognitive and working styles.
• Ability to influence requestors and work partners to achieve optimal scope and methods.