Data Engineer - PowerBI

Particle41; Pune District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Particle41 is seeking a Data Engineer (Power BI) to design scalable ETL/ELT pipelines and optimize data warehouse/lakehouse solutions. You will build and maintain Power BI semantic models, dashboards, and reporting layers with a focus on performance and accuracy.

Collaborating with product, engineering, and business stakeholders in a fast-paced environment, you will deliver end-to-end data and BI solutions, apply best practices, and continuously improve data quality and reporting efficiency in

Qualifications

• Bachelor's degree in CS, Eng, or related field.
• 3+ years' experience as Data/BI Engineer.
• Strong Power BI skills: data modeling, DAX, Power Query, dashboards.
• Proficiency in SQL and Python for data work.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines.
• Build data lakes/warehouses and unify data for analytics.
• Create and optimize Power BI semantic models and dashboards.
• Write and optimize DAX measures and manage deployments.
• Collaborate with product, engineering, and business teams.

Skills

Power BI

SQL

Python

Data modeling

DAX

Power Query

Analytics

Communication

Education

Bachelor's degree in CS/Engineering

Tools

Databricks

Spark

PySpark

Pandas

APIs (Flask)

Git

Job description

Data Engineer – Power BI

Particle41 is looking for a skilled and adaptable Data Engineer (Power BI) to join our growing team. In this role, you will be responsible for building and maintaining scalable ETL/ELT pipelines, optimising data warehouse/lakehouse solutions, and delivering reliable, analysis‑ready datasets. You will also play a key role in developing and enhancing Power BI semantic models, dashboards, and reporting solutions, ensuring performance, accuracy, and business relevance. Working closely with product, engineering, and business stakeholders, you'll deliver end‑to‑end data and BI solutions that drive meaningful outcomes for our clients. This is a great opportunity to work on impactful projects, solve complex data challenges, and grow in a fast‑paced, collaborative environment.

Data Engineering & Pipeline Development

• Design, develop, and maintain scalable ETL/ELT pipelines to process large volumes of data from multiple sources.
• Build and optimise data lakes / data warehouses / lakehouse structures for efficient reporting and analytics.
• Integrate structured and unstructured data from internal and external systems to create a unified and analysis‑ready layer.
• Ensure data accuracy, consistency, and completeness through validation, cleansing, transformation, and reconciliation checks.
• Maintain strong documentation for data pipelines, datasets, Power BI models, and reporting logic.

Power BI Reporting & Semantic Modeling (Core Focus)

• Develop and maintain Power BI dashboards and reports for business and leadership stakeholders.
• Build optimised semantic models in Power BI (star/snowflake schema) for performance and scalability.
• Write and optimise DAX measures, calculated columns, and KPIs aligned to business metrics.
• Use Power Query (M) for transformations and ensure reporting datasets are refresh‑ready and reliable.
• Manage Power BI deployments via Power BI Service, including scheduled refresh, workspace access, and report sharing.
• Improve dashboard performance by optimising data model design, relationships, and aggregations.

Requirements Gathering & Business Alignment

• Collaborate with product managers and business stakeholders to gather reporting requirements and translate them into technical deliverables.
• Participate in analysis sessions to understand business needs and propose best‑fit BI/data solutions.
• Provide technical recommendations to improve reporting accuracy, usability, and speed of decision‑making.

Agile Delivery

• Work in Agile development cycles including sprint planning, daily stand‑ups, and sprint reviews.
• Deliver features on time by managing priorities, dependencies, and scope in a fast‑paced environment.

Testing, Debugging & Reliability

• Perform thorough testing of pipelines and reports to ensure reliability, performance, and data correctness.
• Write unit tests and validations for transformations and pipeline outputs.
• Conduct integration testing to ensure end‑to‑end reporting flows work as intended.
• Identify and resolve defects, performance bottlenecks, and model/report issues proactively.

Continuous Improvement & Innovation

• Stay updated on trends in data engineering, BI analytics, and Power BI capabilities.
• Recommend improvements to enhance scalability, maintainability, and performance of the data/reporting ecosystem.
• Continuously optimise existing codebases, ETL processes, and Power BI dashboards for better efficiency.
• Stay familiar with cloud platforms like Azure / AWS / GCP and modern data engineering practices.

Skills and Experience We Value:

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Proven experience as a Data Engineer / BI Engineer, with 3+ years of experience.
• Strong proficiency in Power BI, including:
  • Data modeling (semantic layer)
  • DAX
  • Power Query (M)
  • Dashboard/report optimization
• Strong hands‑on experience with SQL (MySQL / PostgreSQL preferred) and query optimisation.
• Proficiency in Python for data transformation, automation, and integrations.
• Experience with data warehousing / lakehouse principles and performance tuning concepts.
• Exposure to tools/technologies such as:
  • Databricks, Spark, PySpark
  • Pandas
  • APIs / data integrations (Flask or similar frameworks)
• Utilities & tools: logging, requests, subprocess, regex, pytest
• Familiarity with Git and modern collaborative development workflows.
• Comfortable working in Linux and writing basic shell scripts.
• Strong problem‑solving skills and attention to detail.
• Excellent communication skills and ability to work with cross‑functional stakeholders.
• Adaptability and willingness to learn new tools/technologies as needed.

About Particle41

Our core values of Empowering, Leadership, Innovation, Teamwork, and Excellence drive everything we do to achieve the ultimate outcomes for our clients. Empowering Leadership for Innovation in Teamwork with Excellence (ELITE)

• E - Empowering: Enabling individuals to reach their full potential
• L - Leadership: Taking initiative and guiding each other toward success
• I - Innovation: Embracing creativity and new ideas to stay ahead
• T - Teamwork: Collaborating with empathy to achieve common goals
• E - Excellence: Striving for the highest quality in everything we do

Particle41 welcomes individuals from all backgrounds who are committed to our mission and values. Particle41 provides equal employment opportunities to all employees and applicants, ensuring that hiring and employment decisions are based on merit and qualifications without discrimination based on race, color, religion, caste, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, local, or international laws. This policy applies to all aspects of employment and hiring.