Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Analytics Engineer

Toptal

Toptal is a global network of top talent in business, design, and technology that enables companies to scale their teams, on‑demand. With $200+ million in annual revenue and team members based around the globe , Toptal is the world’s largest fully remote workforce.

We take the best elements of virtual teams and combine them with a support structure that encourages innovation, social interaction, and fun. We see no borders, move at a fast pace, and are never afraid to break the mold.

Job Summary

Toptal prides itself on being a data‑driven organization. The primary objective of the Data Analytics Engineer is to help drive business impact and better decision making by laying the data foundation for a world‑class analytics function. This role will be critical to fostering trust in our data and confidence in our decisions.

Our Data Analytics Engineers focus on creating a data environment that is conducive to analytics and business decision making. You will own and maintain the data transformation layer. This will require data governance (quality, accuracy, coverage, security), data modeling (structure, relationships, integrity), technical communication (data dictionaries, user training), quality control (code reviews, data validation), raw data analysis, and building AI data systems and pipelines. You will be the product owner for our data warehouse and will coordinate closely with our functional Business Analysts on one side, and Data Engineers on the other.

This role sits within the Business Analytics Center of Excellence and will ensure trustworthy data is available for all downstream data users. Positive relationships with both Data Engineers and Business Analysts will be key, but you must also think independently and bring your own point of view. To be successful in this role you must live and breathe SQL daily and be a critical thinker, problem solver and self‑starter.

This role requires an AI‑heavy workflow and skillset. We’ve transformed our codebase to be instrumented for agentic development and continue to build our internal AI tooling, and you will be part of this process. Fluency with using LLMs and agentic coding tools is a requirement of this role. The flip side of that is the part machines cannot do: understanding our business and metrics deeply, and making decisions on what matters and what doesn’t in terms of pushing the company’s business objectives forward.

This is a remote position. We do not offer visa sponsorship or assistance. Resumes and communication must be submitted in English.

Responsibilities

The following information is intended to describe the general nature and level of work being performed. It is not intended to be an exhaustive list of all duties, responsibilities, or required skills.

  • Design, write, review and ship SQL models across our repositories that transform raw data into usable data products for all organizational stakeholders. Own and maintain the transformation layer.
  • Proactively work with the Data Engineers to ensure new data sources are added and available, and then modeled and published in our data warehouse.
  • Proactively monitor the data warehouse and extract insights to identify opportunities to improve data operations, data accuracy and quality, coverage, integrity, structure, and general usability.
  • Turn ambiguous business asks into modeled data. Run requirements gathering with stakeholders. Establish the grain, surface the edge cases, write down the business rules, and push back when the request would produce a misleading number.
  • Implement measures and processes to improve data quality, accuracy, coverage, lineage, access and retention across dozens of source production databases.
  • Own the data dictionary. Write table and column documentation that traces each field to its true origin. This documentation is consumed by AI agents as well as humans, and is an integral part of the semantic layer.
  • Diagnose and resolve data incidents.
  • Review your teammates’ code and provide feedback to maintain the hygiene of the data warehouse production environment.
  • Work closely with Business Analysts, Data Engineers, Data Scientists, and business process owners to empower data-driven decision making.
  • Enable end users to better use data, understand complexities, nuances, and limitations.
  • Help make the team faster. Improve the agent playbooks, documentation, and tooling the team uses to work with the warehouse.

Qualifications and Job Requirements

  • Bachelor’s degree is required, preferably in Engineering or a related technical field.
  • 4+ years of experience in an Analytics Engineer, Data Engineer, or Data Analyst role where you personally shipped production data models.
  • Expert‑level SQL skills and a working knowledge of Python.
  • Fluency with LLMs and agentic coding tools. You already use tools such as Claude Code, Cursor or equivalent as part of your daily working practice. You know where they are reliable, where they should not be used, and how to verify their output.
  • Experience with cloud data warehousing, such as BigQuery or Snowflake.
  • Good understanding of a modern transformation framework (dbt, Dataform, SQLMesh or similar). You understand dependency graphs, refs, incremental strategies, tests and environment promotion as concepts, not just as commands.
  • Git fluency. Branching, pull requests, code review, conflict resolution and generally working with a critical production environment.
  • Strong familiarity with orchestration tools such as Airflow, Cloud Composer, Dagster or Prefect. You can read a DAG, understand its schedule and dependencies, and find out why a task failed.
  • Process discipline. Jira, ticket hygiene, and code review etiquette. It’s mandatory you understand how to avoid shipping unverified LLM‑generated code.
  • Experience in doing exploratory/raw data analysis, data modeling, and data governance (quality, accuracy, coverage, security, etc.).
  • Experience translating business logic and objectives into SQL code and linking data and analytics to business strategy and operations to drive real impact.
  • Familiarity with BI tools (Tableau, Power BI, etc.).
  • Detail oriented, methodical, and thorough.
  • Team player who builds strong relationships and collaborates with others.
  • Outstanding written and verbal communication skills, including the ability to explain complex issues in a simple and intuitive way.
  • Ability to work collaboratively and independently; take ownership of quality, accuracy, and timeliness of deliverables.
  • You must be a world‑class individual contributor to thrive at Toptal. You will not be here just to tell other people what to do.
#J-18808-Ljbffr
Vacancy posted 13 hours ago
Similar jobs that could be interesting for youBased on the Data Analytics Engineer in Ottawa, ON vacancy
  • $106k - $118k per year

     ...Description Title: Manager, Enterprise Data and Analytics Employment Type:  Permanent, Full Time Location:  Ottawa, Canada – Hybrid...  ...you You will have a Bachelor’s or Master’s degree in Data Engineering, Computer Science, Information Systems, or related field with... 
    Data
    Permanent employment
    Full time
    Work at office
    Flexible hours
    2 days per week

    Nutrition International

    Ottawa, ON
    a month ago
  •  ...Staff Software Engineer, Data Level: P4 Location: Remote, Canada Reports To: Sean Yang, Director of Engineering Type: Permanent...  ..., including databases, POS systems, access control systems, analytics platforms, APIs, and more. These integrations form the basis of... 
    Data
    Remote job
    Permanent employment
    Full time
    Immediate start

    Sol Ink

    Ottawa, ON
    16 days ago
  •  ...regulatory expertise, and the world’s largest supply chain data network to help organizations reduce risk, lower...  ...screening, candidate communication, and talent analytics. Job Description The Senior DevOps Engineer, Data & AI Platform is a technical expert dedicated... 
    Data
    Long term contract
    Full time
    Flexible hours

    Assent Inc

    Ottawa, ON
    a month ago
  •  ...setting – Speechify has no office. These include frontend and backend engineers, AI research scientists, and others from Amazon, Microsoft, and...  ...own companies. Overview We're looking to hire for our Data side of our AI team at Speechify. This role is responsible for all... 
    Data
    Full time
    Work at office
    Shift work

    Speechify

    Ottawa, ON
    more than 2 months ago
  • $40k - $80k per year

     ...and government customers for over 55 years. Backed by a legacy of engineering excellence, reliability and industry-leading customer service,...  ...Telesat on X and LinkedIn or visit The Telesat LEO Lightspeed Data Management Specialist will report to the Lightspeed Manager,... 
    Data
    Full time
    For contractors
    Internship
    Work at office
    Worldwide
    Flexible hours

    Telesat Corporation

    Ottawa, ON
    14 days ago
  •  ...Job Title: Wafer Product Engineer Location: Ottawa, ON About Ranovus Ranovus...  ...with global operations helping power the data behind next generation AI and data center...  ...Key Competencies Strong statistical and analytical thinking; data-driven decision making;... 
    Data
    Full time
    Internship

    Ranovus Inc.

    Ottawa, ON
    1 day ago
  • $94.66k - $128.74k per year

     ...world better through trade. Position: Data Analyst 18 Employment Type: Contract /...  ...adaptability, excellent communication and analytical skills, and strong relationship-...  ...Business Analysts, Data Architects and Data Engineers to develop solution approaches. Review... 
    Data
    Permanent employment
    Full time
    Contract work
    Temporary work
    Summer work
    Work at office
    2 days per week

    Export Development Canada

    Ottawa, ON
    11 days ago
  • $35 - $40 per hour

     ...Job Responsibility: Overview We are seeking a highly skilled and motivated Analytics Manager to join our dynamic team. The ideal candidate will play a crucial role in leveraging data to drive strategic decisions within our supply chain and warehouse distribution operations... 
    Data
    Hourly pay
    Permanent employment
    Full time
    Monday to friday
    Flexible hours

    Chase Logistics Canada Inc.

    Ottawa, ON
    7 days ago
  •  ...Software Engineer Co-op, Apps Location: Ottawa, ON | Hybrid Reports To: Xiaokun Xu...  ...key moments. This empowers teams to make data-driven decisions, enhance security, and improve...  ...demonstrate strong attention to detail, analytical skills, and a passion for quality. You... 
    Data
    Permanent employment
    Full time
    Internship

    Sol Ink

    Ottawa, ON
    1 day ago
  •  ...Social networking, machine learning, and big data analytics demand ever-increasing network connectivity. RANOVUS, with operations in Ottawa...  ...for datacenters. We are seeking a Senior Embedded Software Engineer to work as part of our R&D software-firmware design team.... 
    Data
    Long term contract
    Full time
    Remote work

    Ranovus Inc.

    Ottawa, ON
    2 days ago
  • $96.56k - $128.74k per year

     ...through trade. Position: Senior Software Engineer, Edge Delivery Services, Design Systems &...  ....  ~ Lead integrated digital, data, infrastructure, and cybersecurity implementations...  ...Web Vitals, SEO, security, localization, analytics, and content authoring.  ~ Engineer... 
    Data
    Permanent employment
    Full time
    Contract work
    Summer work
    Work at office
    Relocation package
    3 days per week

    Export Development Canada

    Ottawa, ON
    1 day ago
  • $92k - $110k per year

     ...Dynamics Mission Systems–Canada, we’re not just engineering technology — we’re shaping the future of...  .../harness design software. ~ Strong analytical, problem-solving, communication, and...  ...requirements in order to gain access to technical data, classified areas or information that is... 
    Data
    Full time
    Internship
    Flexible hours

    General Dynamics Missions System International

    Ottawa, ON
    22 days ago
  •  ...motivated and experienced Senior Infrastructure Engineer (with strong Networking) to design,...  ...deep technical expertise with strong analytical and communication skills to translate complex...  ...extensive experience with enterprise data center infrastructure, networking, virtualization... 
    Data
    Full time

    Jsi

    Ottawa, ON
    23 days ago
  • $62.09k - $75.65k per year

     ...Location: Ottawa, Ontario (Hybrid, 3-4 Days On-site) Reports to: Manager, Data & Donor Relations Status: Permanent, Full time Bargaining Unit Status: Included Classification: Band 3 Salary range: CA$ 62,086 - CA$ 75,645 per annum Language requirements: English... 
    Data
    Permanent employment
    Full time
    For subcontractor
    Seasonal work
    Work at office
    Monday to friday
    3 days per week

    Cuso International

    Ottawa, ON
    2 days ago
  •  ...for over 55 years. Backed by a legacy of engineering excellence, reliability and industry-leading...  ...operations tools for the purposes of data trending and performance evaluation across...  ...(relational and/or time-series) Strong analytical, problem solving, real-time decision-making... 
    Data
    Full time
    Internship
    Work at office
    Worldwide

    Telesat Corporation

    Ottawa, ON
    14 days ago
  • $80k - $95k per year

     ...to join the Larus Labs team as Data Scientists, where we develop...  ...Intelligence, Machine Learning, and Data Analytics. This is an opportunity to...  ...Computer/Software/Electrical Engineering, Applied Math, Engineering...  ...™ Systems Simulation Engine, Software Engineering Services... 
    Data
    Permanent employment
    Full time
    Work at office
    Remote work
    Home office
    Monday to friday
    3 days per week

    Larus Technologies

    Ottawa, ON
    5 days ago
  •  ...better through trade. Position: Director, Data Platform Management Employment Type:...  ...for reporting, integration, analytics, and AI. The team owns platform lifecycle...  ...teams of data platform administrators, cloud engineers and data architects, building strong technical... 
    Data
    Long term contract
    Permanent employment
    Full time
    Contract work
    Temporary work
    Summer work
    Work at office
    Relocation package
    3 days per week

    E Dc

    Ottawa, ON
    more than 2 months ago
  •  ...for over 55 years. Backed by a legacy of engineering excellence, reliability and industry-leading...  ..., or equivalent tools. Strong analytical, technical writing, presentation, and meeting...  ...you would like more information about how your data is processed, please contact us.... 
    Data
    Full time
    Internship
    Work at office
    Worldwide

    Telesat Corporation

    Ottawa, ON
    13 days ago
  • $65.17k - $86.9k per year

     ...better through trade. Position: Associate Data Platform Administrator Employment Type...  ...continuous improvement of EDC’s data and analytics platforms. Working within an agile,...  ...looking to grow a career in data platform engineering and administration through structured learning... 
    Data
    Permanent employment
    Full time
    Summer work
    Work at office
    Relocation package
    2 days per week
    3 days per week

    Export Development Canada

    Ottawa, ON
    a month ago
  •  ...for over 55 years. Backed by a legacy of engineering excellence, reliability and industry-leading...  ...equivalent tools is an asset. Strong analytical, organizational, problem-solving,...  ...you would like more information about how your data is processed, please contact us.... 
    Data
    Full time
    Internship
    Work at office
    Worldwide

    Telesat Corporation

    Ottawa, ON
    13 days ago
  •  ...Senior Hardware Design Engineer Ranovus is a semiconductor company with global operations helping power the data behind next generation AI and data center networks. We design and build advanced hardware that moves massive amounts of information quickly and efficiently... 
    Data
    Full time
    Internship

    Ranovus Inc.

    Ottawa, ON
    1 day ago
  • $128k - $160k per year

     ...Description Title: Director IT & Data Transformation Employment Type:  Permanent, Full Time Location:  Ottawa, Canada – Hybrid...  ...preferred). Proven track record leading enterprise data governance or analytics programs and delivering technology projects using agile and... 
    Data
    Permanent employment
    Full time
    Contract work
    Work at office
    Flexible hours
    2 days per week

    Nutrition International

    Ottawa, ON
    more than 2 months ago
  •  ...role. If you have experience with NetSuite, ERP systems, invoicing, and accounts payable/receivable (AP/AR)—and enjoy working with data, systems, and people—you’ll feel right at home here. In this role, you’ll take the lead on invoicing processes, support our NetSuite... 
    Data
    Long term contract
    Full time
    Part time
    Work from home
    Night shift

    BPG Co-operative Inc.

    Ottawa, ON
    more than 2 months ago
  • $108k - $158k per year

     ...Company: Qualcomm Canada ULC Job Area: Engineering Group, Engineering Group ASICS...  ...experiences and drives communication and data processing transformation to help create...  ...~ Extremely detail oriented ~ Superb analytical and problem-solving skills ~ Drives for... 
    Data
    Remplacement
    Full time

    Qualcomm

    Ottawa, ON
    7 days ago
  •  ...quickly and are currently in need of a System Engineering Specialist to join our System Solutions...  ...system architectures.  Strong analytical and problem-solving skills with attention...  ...you would like more information about how your data is processed, please contact us.... 
    Data
    Full time

    Telesat Corporation

    Ottawa, ON
    more than 2 months ago
  • $105k - $170k per year

     ...lower-cost mission development, and valuable data returns. Mission Control launched the...  ...Mission Control is seeking a Senior Systems Engineer to lead the expansion of our technology...  ...across disciplines. ~ Excellent analytical, documentation, and problem-solving skills... 
    Data
    Long term contract
    Permanent employment
    Full time
    Relocation
    Relocation package
    Flexible hours

    Mission Control Space Services

    Ottawa, ON
    more than 2 months ago
  •  ...team of over 50,000 planners, designers, engineers, scientists, digital innovators, program...  ..., but are not limited to: Grows their analytic and design skills in structural engineering...  ...drawings Collects and analyzes data Uses computer software as a tool for solving... 
    Data
    Full time
    For contractors
    Casual work
    Work at office
    Local area
    Worldwide
    Flexible hours

    Aecom

    Ottawa, ON
    more than 2 months ago
  • $95k - $135k per year

     ...Senior CET/Structural Engineer (on-site/Ottawa) Job Summary: Salas O’Brien Canada...  ...skills to work with diverse teams Math and analytical abilities for tasks like estimating and scheduling...  ...experience includes design for data centers, healthcare, science and technology... 
    Data
    Full time
    Contract work
    For contractors
    Internship
    Work at office
    Local area

    Salas O'Brien

    Ottawa, ON
    more than 2 months ago
  •  ...As part of the Canadian Sales Engineering team, the Communication Systems Engineer is responsible...  ...modifications and enhancements. Good analytical and problem-solving skills are necessary...  ...you would like more information about how your data is processed, please contact us.... 
    Data
    Full time
    For contractors
    For subcontractor
    Work at office

    Telesat Corporation

    Ottawa, ON
    more than 2 months ago
  •  ...Senior Software Engineer JD About the job Company Description askpolly transforms...  ...statistical models to analyze organic social media data, askpolly provides near-instant,...  ...databases (e.g., MongoDB ) and handling analytical data formats like Parquet . Workflow... 
    Data
    Full time
    Internship
    Manual labor
    Work at office

    Forum Ventures

    Ottawa, ON
    a month ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Analytics Engineer. Be the first to apply!