Data Engineer - Power BI
Particle41 is looking for a skilled and adaptableData Engineer (Power BI)to join our growing team. In this role, you will be responsible for building and maintaining scalableETL/ELT pipelines, optimisingdata warehouse/lakehousesolutions, and delivering reliable, analysis-ready datasets. You will also play a key role in developing and enhancingPower 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 maintainPower BI dashboards and reportsfor business and leadership stakeholders.
- Build optimizedsemantic modelsin Power BI (star/snowflake schema) for performance and scalability.
- Write and optimizeDAX measures, calculated columns, and KPIs aligned to business metrics.
- UsePower Query (M)for transformations and ensure reporting datasets are refresh-ready and reliable.
- Manage Power BI deployments viaPower 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.