Business Data Engineer - Ottawa - Telesat

    Telesat
    Telesat Ottawa

    2 days ago

    Full time
    Description

    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


    #J-18808-Ljbffr

  • Data Engineer

    4 days ago

    Only for registered members Ottawa, Ontario

    We are excited to partner with Noda to attract top talent for Data Engineer. · Noda is a data and analytics company for the commercial built environment. We reimagine how modern buildings operate — because a better world needs better buildings. Better buildings are more efficient ...

  • Data Engineer

    1 week ago

    Only for registered members Ottawa, ON

    We are looking for a Data Engineer to work on large scale IT projects. This is a new position. · ...

  • Data Engineer

    2 weeks ago

    Only for registered members Ottawa, Ontario

    The Bank of Canada has a hybrid remote contract for a Data Engineer. · ...

  • Data Engineer

    3 weeks ago

    Only for registered members Ottawa

    Job summary · Are you passionate about building robust data solutions that power critical decision-making and shape the future of aviation? · Join NAV CANADA's Data Analytics team as a Senior Data Engineer and play a key role in designing and delivering scalable data solutions th ...

  • Data Engineer

    4 weeks ago

    Only for registered members Ottawa Full time $111,451 - $140,007 (CAD)

    Join NAV CANADA's Data Analytics team as a Senior Data Engineer and play a key role in designing and delivering scalable data solutions that drive innovation across Canada's air navigation system. · ...

  • Data Engineer

    4 weeks ago

    Only for registered members Ottawa

    +The Senior Data Engineer Service Provider must have experience in leading, designing, implementing, and collaborating with stakeholders to achieve the best results for our clients. · +Proven design, build and implementation of batch and real-time data pipelines. · Driven by auto ...

  • Data Engineer

    4 days ago

    Only for registered members Ottawa Full time

    We are excited to partner with Noda to attract top talent for Data Engineer.Noda is a data and analytics company for the commercial built environment. · ...

  • Data Engineer

    4 days ago

    Only for registered members Ottawa

    Noda is a data and analytics company for the commercial built environment. We reimagine how modern buildings operate — because a better world needs better buildings. Better buildings are more efficient, more sustainable, and more resilient.We do this with smart software, careful ...

  • Data Engineer

    4 weeks ago

    Only for registered members Ottawa, ON

    Are you passionate about building robust data solutions that power critical decision-making and shape the future of aviation? Join NAV CANADA's Data Analytics team as a Senior Data Engineer and play a key role in designing and delivering scalable data solutions that drive innovat ...

  • Data Engineer

    2 weeks ago

    Only for registered members Ottawa

    12 month renewable hybrid remote contract for a Data Engineer to design Copilot Studio agents that answer data questions and automate workflows with strong guardrails. · ...

  • Data Engineer

    4 days ago

    Only for registered members Ottawa Full time

    Noda is a data and analytics company for the commercial built environment. We reimagine how modern buildings operate — because a better world needs better buildings. Better buildings are more efficient, more sustainable, and more resilient. They are intelligent, autonomous ecosys ...

  • Data Engineer

    4 days ago

    Only for registered members Ottawa, ON KY C

    Noda is a data and analytics company for the commercial built environment. We reimagine how modern buildings operate — because a better world needs better buildings. · Better buildings are more efficient, more sustainable, and more resilient. They are intelligent, autonomous ecos ...

  • Azure Data Engineer

    1 week ago

    Only for registered members Ottawa, Ontario Remote job

    +We are seeking a skilled Data Engineer to design, build, and maintain robust data pipelines and architectures. · +Develop, maintain, and optimize scalable ETL (Extract, Transform, Load) pipelines to process structured and unstructured data from multiple sources. · ...

  • Senior Data Engineer

    3 weeks ago

    Only for registered members Greater Ottawa Metropolitan Area Remote job

    We are looking for a Senior Data Engineer for an upcoming opportunity with a public sector client. · Proven design, build and implementation of batch and real-time data pipelines. · ...

  • Sr. Data Engineer

    6 days ago

    Only for registered members Ottawa, Ontario

    The Senior Data Engineer will be responsible for leading the delivery of data on data and analytics platform. · • Proven design, build and implementation of batch and real-time data pipelines. · Increase the overall speed in which data is onboarded to the Data and Analytics platf ...

  • Business Data Engineer

    1 month ago

    Only for registered members Ottawa, Ontario

    We are seeking a motivated Business Data Engineer with 2–5 years of experience in Lakehouse environments. · Design, develop, and maintain data pipelines and workflows for ingestion, transformation, and delivery of clean, reliable business data for analysis and reporting. · ...

  • Data Integration Engineer

    1 month ago

    Only for registered members Ottawa, Ontario

    Data Integration Engineer (SSIS) is a role that requires strong focus on ETL and SQL skills. · ETL tasks · ...

  • Senior Data Engineer

    1 month ago

    Only for registered members Ottawa, Ontario Remote job

    LeverageTek is actively seeking a Senior Data Engineer for a contract with its customer in Ottawa. · Proven design and implementation of batch and real-time data pipelines. · Developing and proposing design patterns that conform to requirements. · ...

  • GTM Data Engineer

    3 weeks ago

    Only for registered members Ottawa, Ontario

    The Analytics Engineer designs and implements scalable data infrastructure to enable analytics and reporting. Responsibilities include development, management and governance of GTM BDM Data architecture. · Data pipeline developmentSQLCLOUD DATA WAREHOUSING · ...

  • Data Analytics Engineer

    3 weeks ago

    Only for registered members Ottawa $80,000 - $110,000 (CAD)

    Ribbon Communications is looking for a Data Analytics Engineer to design, architect, and implement data processing and analytics applications for real-world telecommunications use cases using ML. · Design and implement data processing and analytics applications. · Participate in ...

  • Data Pipeline Engineer

    3 weeks ago

    Only for registered members Ottawa $90,400 - $124,300 (CAD)

    Ribbon Communications is looking for a Data Pipeline Engineer to support the infrastructure and data pipelines powering Ribbon Analytics. · Design and develop large-scale distributed data processing pipelines. · Design efficient data ingestion and transformation solutions. · Coll ...

Jobs
>
Ottawa