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.
- 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.
- 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.
- 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.
- Stay familiar with cloud platforms like Azure / AWS / GCP and modern data engineering practices.
- 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 optimization.
- 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
We seek team members who embody these values and are committed to contributing to our mission. Particle41 welcomes individuals from all backgrounds who are committed to our mission and values. We provide 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.
We appreciate your interest and encourage applicants from these regions to apply. If you need any assistance during the application or interview process, please feel free to reach out to us at [email protected].
