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.
Requirements
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Benefits
- Generous Paid Time Off
- 401k Matching
- Retirement Plan
- Relocation Assistance
- Tuition Reimbursement
