Senior Associate in Deals Real Assets focusing on data engineering and digital solutions for capital projects.
Compensation
The salary range for this position is $60,000 - $100,100.
Responsibilities
Architect, design, and develop robust, end-to-end data pipelines utilizing Azure Data Factory, Azure Databricks, and Azure Synapse Analytics
Design and implement data models within Azure Data Lake, leveraging Medallion Architecture and building complex business logic into scalable, efficient transformations
Develop processes to ingest data from relational databases, APIs, flat files, and project management systems
Automate data workflows and implement CI/CD practices for data pipelines using Azure DevOps or GitHub Actions
Monitor, troubleshoot, and optimize data solutions for performance, scalability, and cost-effectiveness
Requirements
Bachelor's degree in Computer Science, Engineering, Information Technology, or related field
Lead analytics work within the Surgical and Medical Imaging sectors, developing indicators, methodologies, and advanced analyses to support executive decision‑making and system improvement.
Responsibilities
Provide analytical leadership on quantitative and qualitative analyses of clinical and administrative data
Build strong relationships with internal and external stakeholders
Develop analytics plans, methodology protocols, and data acquisition and collection plans
Deliver rigorous, timely analytics products with briefing notes, presentations and reports
Support the Analytics Manager in setting timelines and priorities
Requirements
Masters degree in epidemiology, biostatistics, health sciences, industrial engineering or related fields
A newly created winter student position based in downtown Ottawa focusing on sourcing, tracking and benchmarking statistical data.
Compensation
The expected salary for this position is $22 per hour.
Responsibilities
Assist with the development, testing and maintenance of Power BI dashboards, reports and data models that support decision-making across Ottawa Tourism.
Prepare, clean, transform and integrate data from a variety of sources using tools such as Excel, Power Query, Power BI and Microsoft Fabric.
Support data quality and validation activities, including identifying missing, duplicate or inconsistent data, reconciling reported results to source data, and documenting data-quality issues.
Assist with the development and maintenance of semantic models, data flows and other reusable BI data assets that improve access to consistent, reliable organizational data.
Support the evaluation and integration of new data sources, including tourism, visitor, hotel, event, CRM, market and other business data.
Requirements
Post-Secondary education in a relevant quantitative or technical discipline (Business Analysis, Data Science, Statistics, etc.)
The Tier 3 SPD Developer is responsible for coding, testing and debugging software used either in the PBS internal environment or externally by customers.
Compensation
Competitive annual base salary
Up to $4,800 per year in product certification bonuses
Responsibilities
Build and enhance internal applications that support daily business operations.
Design, build, and maintain Blazor and C# solutions using SQL and API integrations for internal web applications, analytics, notifications, data movement, and automation.
Design and maintain SQL database tables, relationships, functions, business rules, and security roles.
Experience with UI/UX design tools, conventions, and implementation.
Integrate solutions within SharePoint, Teams, and Outlook and accommodate external integration via API (REST) or custom connectors.
Design, deploy and manage containerized environments using Kubernetes, GKE, AKS, or similar platform.
Compensation
$126,800 - $164,100 CAD
Responsibilities
Design, deploy and manage containerized environments using Kubernetes, GKE, AKS, or similar platform.
Document security configurations, procedures and guidelines for containerized environments, ensuring compliance with organizational standards and regulatory requirements.
Develop and maintain security tools, scripts, and automation workflows to enhance container security operations and incident response capabilities.
Utilize IaC (Infrastructure-as-Code) tools such as Terraform to automate infrastructure provisioning, ensure consistent configuration and prevent drift.
Work with microservice architecture, designing APIs, managing Ingress controllers, and implementing service meshes for improved scalability and security.
Requirements
Bachelor's degree in Computer Science or related field
Nice to have: Certified Kubernetes Administrator (CKA)
Nice to have: Certified Kubernetes Security Specialist (CKS)
Supports the FCRM Data Strategy and Management team in designing, implementing, and maintaining data management capabilities and controls aligned with Enterprise Data Management Office requirements.
Compensation
$96,900 - $136,800 CAD
Responsibilities
Design, implement and maintain data management processes and controls
Analyze, develop, validate and maintain end-to-end data lineage and data flows
Define, develop and implement business and technical data quality rules
Perform root-cause analysis of complex data issues
Perform data analysis, profiling, validation and reconciliation using SQL
Requirements
Undergraduate degree or equivalent relevant experience