We are seeking a motivated Business Data Engineer with 2–5 years of experience in Lakehouse environments. This hybrid role combines the technical rigor of a Data Engineer with the business insight of a Data Analyst, building reliable data pipelines while partnering with stakeholders to deliver impactful analytics and reporting.
The ideal candidate has hands-on experience with Databricks, PowerBI, advanced SQL, Fivetran, data integration from on-prem and cloud systems (including Workday and Salesforce), and solid understanding of Python and Databricks Notebooks.
Key Responsibilities
- Design, develop, and maintain data pipelines and workflows for ingestion, transformation, and delivery of clean, reliable business data for analysis and reporting.
- Collaborate with business teams to gather requirements, perform data validation, and support UAT/demos.
- Extract, integrate, and transform data from diverse systems including Workday, Salesforce, on-prem and SaaS applications using APIs, JDBC/ODBC, and native/direct connections.
- Write and optimize advanced SQL for data modeling, transformation, and cost-efficient query execution.
- Build and optimize Power BI datasets, models, and dashboards for business insights and performance tracking.
- Use Databricks Notebooks with Python and/or Scala for data preparation, automation, and analysis.
- Monitor and optimize compute resources and job performance for cost control and efficiency.
- Document data pipelines, transformation logic, and architecture for transparency and maintainability.
Education and Experience
- 2–5 years in a Data Engineering or Business Data Analysis role.
- Strong hands-on experience with Databricks (including Delta Lake, Spark SQL, and Notebooks).
- Strong working knowledge of Power BI (data modeling, DAX, dashboard design, publishing).
- Advanced SQL skills for large-scale data transformation and optimization.
- Proficiency in Python and/or Scala for data processing in Databricks.
- Proven experience with Fivetran or similar ETL/ELT tools for automated data ingestion.
- Experience integrating data from Business Applications like Workday and Salesforce (via APIs, reports, or connectors).
- Ability to manage and transform data from on-premises and cloud systems.
- Strong communication skills with experience in business requirement gathering and data storytelling.
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Statistics, or a related field.
- Relevant certifications (e.g., Databricks Certified Data Engineer, Microsoft Power BI Data Analyst, Workday Reporting Specialist) are a plus.
Preferred / Nice-to-Have
- Fundamental knowledge of Apache Spark (architecture, RDDs, DataFrames, optimization).
- Experience in query and compute cost optimization within Databricks or similar platforms.
- Familiarity with data governance, security, and metadata management.
- Exposure to CI/CD for data pipelines using Git or DevOps tools.
- GenAI Agents and/or ML experience
Decision Making and Supervision
- Work under minimal supervision.
- Make decisions and recommendations requiring analysis and interpretation within established procedures.
Working Conditions
- Generally comfortable working conditions with lifting and onsite installations.
- Moderate visual concentration in use of video display terminal.
The successful candidate must be able to work in Canada and obtain clearance under the Canadian Controlled Goods program (CGP).
#LI-MF1
