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

Telesat

Business Data Engineer

Telesat

Similar Remote Jobs