Data Engineer - PowerBI
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.
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 likeAzure / AWS / GCPand modern data engineering practices.
Skills and Experience We Value:
- Bachelor’s degree in Computer Science, Engineering, or a related field.
- Proven experience as aData Engineer / BI Engineer, with3+ yearsof experience.
- Strong proficiency inPower BI, including:
- Data modeling (semantic layer)
- DAX
- Power Query (M)
- Dashboard/report optimization
- Strong hands-on experience withSQL(MySQL / PostgreSQL preferred)