Data Engineer - Power BI
In This Role, You Will:
Data Engineering & Pipeline Development
- Design, develop, and maintain scalableETL/ELT pipelinesto process large volumes of data from multiple sources.
- Build and optimizedata lakes / data warehouses / lakehousestructures 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) and query optimization.
- Proficiency inPythonfor data transformation, automation, and integrations.
- Experience withdata warehousing / lakehouse principlesand 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 withGitand modern collaborative development workflows.
- Comfortable working inLinuxand 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].
