Job Description:BI Data EngineerFull stack engineer for BI / Reporting solutionLocation: Markham, ON (Hybrid)Employment Type: Full-TimeDepartment: Business Intelligence / Data AnalyticsReporting To: Director, BI / AnalyticsSeniority Level: Intermediate (2–5 years)Compensation & Role Details:Expected Salary Range: The expected base salary range for this role is between $100,000 – $115,000 CAD, depending on experience and qualificationsRole Type: New RoleAI Disclosure: AI may be used during the hiring process.Role OverviewWe are seeking a BI Data Engineer to design, build, and optimize BI assets — dashboards, reports, and semantic data models — primarily in AWS QuickSight on top of SQL-based datasets. This is a hands-on BI role that involves building data models, data pipelines and a web presentation layer. Your day is spent turning business ask into governed, performing dashboards and reports served through web application and build / maintain SQL models behind them.Key ResponsibilitiesBI Solution DevelopmentBuild interactive QuickSight dashboards (parameters, controls, calculated fields).Implement data visualizations that clearly communicate business insights.Apply security and data-governance standards across BI assets.Data Analysis & ModelingWrite and optimize complex SQL for extraction, transformation, aggregation and performance tuning.Design semantic layers and curated datasets aligned to reporting needs.Monitor and troubleshoot BI solutions for accuracy, performance, scale and efficiency.Data Pipeline EngineeringContribute to data acquisition, wrangling, shaping and validate data quality and lineage for reporting.Orchestrate and manage data shaping jobs that run in Cloud to maintain a high quality data modelWeb Application Upkeep & MaintenanceApplication layer built with OAuth, Node.JS, Express.JS, MongoDB, SQL and .NETMust-Have Qualifications2–5 years in a BI / reporting development role.Strong SQL: complex joins, window functions, CTEs, aggregations, and query performance tuning.Strong data wrangling,



pipeline and basic web development skills. Experience with .NET, Java Script, Python and CSS.Good understanding of data warehousing and dimensional modeling (star schemas, semantic layers).Good AWS QuickSight experience. Knowledge of parameters, controls, calculated fields and dataset design.Hands on AWS Cloud experience. Knowledge of AWS data services: S3, Lambda and IAM basics.Hands on experience with Git and typical development workflows.Comfortable with work needed to improve data quality & produce reports users can rely onGood communication skills.Nice-to-Have SkillsMaintaining web application, fixing defects and testing fixesExperience with Google charts APIBuilding and maintaining API layer for data acquisition and data servicesAutomating data jobs that can run at scaleExperience delivering email digests, Narrative summaries that go beyond classic reports, dashboards, analyticsKnowledge of SPICE and row-level securityExperience using AI tools to accelerate developmentExperience with Mongo DBExperience with Docker and container deploymentsExperience with Service BusExperience with pandas Data FramesEnd to end experience going from data acquisition through presentation layer in a production settingData governance exposure (cataloging, lineage, definitions)Continuous integration / Continuous Delivery (CI/CD) for BI assets.Knowledge of BI solutions like Power BI, LookerKnowledge of Data lake / Data warehouse solutions like Snowflake, DataBricksExperience automating QAExperience with build tools like JenkinsExperience with Cloud Ops,



Dev Ops and automationExperience building prediction modelsBuilding interactive chat type solutions over existing data assetsBest Visualization practices and UX for analyticsKey CompetenciesData Storytelling: Translates complex data into clear visuals and narratives.Rapid Learner: Curious and fast paced learner that can adapt to change;Bias for Action: Ships iteratively, validate quickly and improve continuously.Quality & Accuracy: High attention to detail; strong testing discipline. Security consciousnessCustomer Focus: Collaborates with business partners to understand and deliver high-value insights.Ownership & Scope Discipline: Proactive in monitoring and support; comfortable owning BI/reporting deliverablesBusiness Unit:Jonas ClubScheduled Weekly Hours:37.5Number of Openings Available:1Worker Type:RegularMore About Jonas Software:Jonas Software is a leading provider of enterprise management software solutions, serving a wide range of vertical markets including hospitality, healthcare, construction, education, personal care, fitness, leisure, moving and legal services, to name a few. Within these markets, Jonas is comprised of over 65 distinct brands, each a respected leader in its domain.Jonas’ vision is to be the branded global leader across these verticals and to be recognized by customers and industry stakeholders as the trusted provider of “Software for Life.” We are committed to technology, product innovation, quality, and exceptional customer service.Jonas Software supports over 60,000 customers in more than 30 countries. We employ over 6,000 skilled professionals, including industry experts and technology specialists. Across our broader network, we support a global workforce of more than 30,000 employees.Headquartered in Canada, Jonas Software has a global footprint with offices around the world. We’re a 100% owned subsidiary of Constellation Software Inc., based in Toronto, publicly listed on the TSX (CSU.TO), and a member of the S&P;/TSX 60 Index.
#J-18808-Ljbffr

📌 BI Data Engineer (Ontario)
🏢 EWS Group
📍 Ontario