Data Engineer - Power BI

*]:pointer-events-auto scroll-mt-[calc(var(--header-height)+min(200px,max(70px,20svh)))]" data-turn-id="939bcb52-4927-4803-97ab-81e27bde755f" data-testid="conversation-turn-38" data-scroll-anchor="true" data-turn="assistant">

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.

In This Role, You Will

Data Engineering & Pipeline Development

Design, develop, and maintain scalable ETL/ELT pipelines to process large volumes of data from multiple sources.
Build and optimize 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 optimized semantic models in Power BI (star/snowflake schema) for performance and scalability.
Write and optimize 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 optimizing 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