Senior BI Engineer

Schema App is a fast-paced, profitable SaaS company headquartered in Guelph, Ontario, and proud of our Canada-wide team. We are a smart, collaborative team on a mission to be a global leader in Enterprise Marketing Tech Innovation with a focus on content knowledge graphs. Schema App is proud to call SAP, Wells Fargo, and Henry Ford Health our customers. We are the leaders in a niche area of search engine optimization (SEO), called schema markup. Schema markup builds knowledge graphs that unlock AI and Search understanding of web content. Our comprehensive end-to-end solution empowers Enterprise Digital Marketing Teams to achieve organic search results, content insights and increased AI efficiency. Our technology is essential with the evolution of AI Search (ChatGPT, AI Overviews, and Gemini).

Visit Schema App at
www.schemaapp.com or on LinkedIn.

We are seeking a Senior BI Engineer who will own the reliability, scalability, and structure of the data that powers decision-making at Schema App. You will design and operate the data pipelines, models, and storage layers that our product, customer, and leadership teams rely on every day. Your work will ensure that the right data is available, accurate, and performant for downstream analytics, dashboards, and reporting.

You will be hands-on with modern data engineering tools such as Apache Flink / Spark, AWS Glue, EMR, batch APIs, and our semantic RDF / schema.org foundations to build robust data platforms that connect operational systems, knowledge graphs, and BI. This role is ideal for someone who loves building well-modeled, well-governed data systems and wants their work to directly enable better decisions, better products, and better customer outcomes.

This job is remote within Canada

Functional Accountabilities

Engineer Reliable and Scalable Data Systems

Design, build, and maintain high-performance data pipelines using Apache Flink, Spark, and AWS Glue to ensure trusted, accessible, and near-real-time data across the organization.

Maintain and Optimize Database Systems
Administer and tune data warehouses, lakehouses, and related storage systems for performance, cost efficiency, security, and scalability, ensuring that core datasets are efficient and reliable for BI use cases.

Ensure Data Model Compliance

Design and enforce dimensional and semantic data models aligned with business definitions, data contracts, and governance standards, ensuring downstream dashboards, APIs, and reports remain stable and consistent over time.

Integrate Semantic Data for Strategic Insights
Leverage Schema App’s RDF and schema.org foundations to connect structured and semantic data, building pipelines and models that enrich core datasets with semantic context for richer, more meaningful business intelligence.

Foster a Data-Centric Culture
Mentor peers on data engineering best practices, champion continuous improvement in data quality and reliability, and promote a culture where well-modeled, well-governed data is the default starting point for analysis and decision-making.

Key Competencies

Technical Mastery
Deep expertise in SQL and data processing frameworks such as Apache Flink / Spark, with strong proficiency in Python. Comfortable working with AWS Glue, EMR, batch APIs, and modern data warehousing patterns to build and operate robust ETL/ELT pipelines.

ETL & Semantic Data Modeling
Strong knowledge of ETL processes using RDF, schema.org, and related semantic standards. Skilled at designing and implementing data models and transformations that ensure data model compliance, maintain schema integrity, and make semantic data usable for BI and downstream applications.

Big Data & Distributed Processing
Experience with big data technologies (e.g., Hadoop, Spark) and distributed computing concepts, including partitioning, clustering, and performance tuning in large-scale environments.

Analytical & System Design Thinking
Applies system design and analytical thinking to data engineering problems and designing pipelines, data models, and storage layouts that balance performance, cost, maintainability, and downstream analytics needs.

Governance & Reliability
Ensures every dataset and pipeline meets standards for data quality, lineage, observability, and compliance. Implements monitoring, alerting, and SLAs for data freshness, accuracy, and uptime so that BI consumers can trust the platform.

Cross-Functional Collaboration & Enablement
Works seamlessly with Product, Engineering, and Business teams to translate requirements into stable data models and pipelines. Enables analytics and BI stakeholders through clear documentation, handoffs, and education so they can confidently build dashboards and reports on top of the engineered data.

Performance Metrics

Cycle Time
Measures the average time between a well-defined data request (or change request) and the delivery of a production-ready dataset, pipeline change, or asset that enables the requested insight, reflecting the team’s responsiveness and operational agility.

Pipeline Uptime / SLA Performance
Tracks the percentage of time the data pipelines and refresh jobs meet their defined SLAs for completeness and freshness, reflecting the reliability of the data platform.

Data Quality Index
Measures data quality across certified datasets using automated checks (e.g., completeness, accuracy, schema conformity) and alerts, summarised into a simple index that can be tracked and improved over time.

Knowledge Graph Integration Success
Assesses how effectively core business domains (such as customers, products, accounts, and usage) are enriched with RDF/schema.org structures and integrated into BI datasets and pipelines, enabling active use of reporting and analysis.

Governance Adherence Rate
Tracks adherence to data governance standards, such as the percentage of certified datasets and pipelines with defined owners, documentation, lineage, SLAs, and monitoring, reflecting the maturity and sustainability of the data platform.

Core Values

• Growth Mindset: We are adaptable, nimble, and resilient. We are always learning.
• Resourceful: We are resourceful, take action on opportunities, and don’t give up.
• One Team: We are collaborative, we win and learn together.
• We are Humble: We know what we are good at as people and as a company. We share what we know, admit what we don’t, and seek clarity through curious questions.

Life @ Schema App

• Culture focused on your growth: Weekly 1:1 with conversations around Professional Development
• Great benefits for health & wellness, and your coverage starts as soon as you do
• RRSP matching!
• Flex days to re-energize on top of vacation days and you don’t work on your birthday
• You choose where you work - home or headquarters in Guelph. The sales team comes into the office 1–2 times per week
• The Culture Club keeps our virtual team connected through fun and innovative events
• Diverse smart team! The more inclusive we are, the better our work will be
• Schema App’s purpose is to build meaningful connections, with each other, our customers, and the data so that we are all understood. We are a team of smart people helping each other solve hard problems.