Core Objective:

Design and implement a robust, scalable, and high-performance data warehouse using

the Microsoft Fabric environment. This architecture will serve as the backbone for near

real-time analytics and reporting for airport curbside management solutions.

Responsibilities:

1. Data Warehouse Design

• Platform Expertise:

• Use Microsoft Fabric (hosted on Azure) to design a relational data warehouse.

• Leverage Azure tools for ETL processes, ensuring smooth integration of structured and

unstructured data.

• Design Constraints:

• Create a system that supports real-time data ingestion and querying with refresh

intervals of 1-10 minutes.

• Optimize performance for up to 20 simultaneous users querying the system.

2. Data Integration

• Data Sources:

• Integrate 14 APIs providing data from:

• Visual analytics (vehicle count and categorization by cameras).

• LPR cameras (license plate recognition with entry/exit timestamps).

• Traffic systems like Skidata (garage access, vehicle tracking).

• Employee, Uber/Lyft, and VIP vehicle data.

• Valet and reservation systems.

• Public data, such as flight schedules and weather patterns.

• ETL Development:

• Design extract, transform, and load (ETL) processes to handle high-frequency data

inputs.

• Ensure the ability to process terabytes of data annually with future scalability in mind

3. Reporting and Visualization

• Prepare the warehouse to feed Power BI dashboards for real-time reporting on:

• Monthly and daily traffic patterns (vehicle types, categories like taxi, limo, personal).• Occupancy and curbside activity levels.

• Historical trends for predictive analysis (to be expanded in Phase 2).

• Ensure that dashboards refresh dynamically based on real-time updates.

4. Performance and Scalability

• Design for high availability and redundancy, ensuring no data loss or significant

latency.

• Implement indexing, partitioning, and caching strategies to handle queries on datasets

spanning weeks or months while maintaining quick response times.

5. Security and Compliance

• Ensure compliance with security protocols, especially around sensitive data like license

plates.

• Design access controls for multi-user environments, ensuring data integrity.

6. Future Readiness

• Design with a data lake integration strategy for Phase 2, allowing unstructured data

and advanced analytics.

• Lay the foundation for AI-powered insights and correlations between data sources

(e.g., flight patterns affecting curbside activity).

Technical Expertise

1. Microsoft Ecosystem:

• Deep knowledge of Microsoft Fabric tools and Azure cloud services.

• Proficient in SQL Server and relational database design.

• Familiarity with Power BI for report integration.

2. ETL and Data Modeling:

• Strong experience in ETL tools and processes for large-scale, high-frequency data

ingestion.

• Expertise in designing efficient, scalable data models tailored to real-time operations.

3. Data Analytics:

• Experience with visual analytics tools and API-driven data ingestion.

• Ability to integrate diverse data types (structured/unstructured) into a unified system.

Experience

• 5-10+ years in data architecture and database design, preferably with large-scale

projects (e.g., airports, logistics, or high-traffic systems).• Demonstrated ability to manage real-time systems with high performance and multi-

user access.

• Familiarity with visual analytics platforms (e.g., Eagle Eye) and real-time categorization

systems.

Soft Skills

• Strong communication skills to collaborate with technical and non-technical teams.

• Ability to document processes and articulate designs for stakeholder understanding.

• Problem-solving mindset to adapt solutions for high-complexity environments.

Engagement Details

• Project Timeline: Estimated 4–6 months for the design and deployment phase, with

possible extensions for optimization and ongoing support.

• Location: Open to local or global resources, but time efficiency and availability must be

prioritized.

• Scope of Work: Focused on designing and delivering the data warehouse architecture

(not API development).

Location: Toronto, ON ( Hybrid position) it can be Canada Wide

Core Objective: Design and implement a robust, scalable, and high-performance data warehouse using the Microsoft Fabric environment. This architecture will serve as the backbone for near real-time ana...View more

Posted 3 months ago

Company Overview: A healthcare technology company focused on improving administrative processes in clinics through augmented off-site administrative teams, optimized workflows, and AI-supported back-office technologies.

Position Summary: We are seeking a Sales Executive with a strong hunter mentality who thrives on the challenge of engaging prospects, understanding their pain points, and offering tailored solutions that drive client success. You will have access to a large base of potential clients across medical, dental, and allied health segments. The role demands the ability to prioritize, build strong relationships, and maintain a dedicated work ethic.

This position offers a blend of salary plus uncapped commission, giving you the opportunity to achieve on-target earnings of $135,000+.

You should be comfortable working in a fast-paced environment, interacting with key decision-makers, and moving leads through the sales cycle from initial contact to closure. A strong understanding of CRM systems and pipeline management is crucial to success.

We seek a candidate who embraces a consultative sales approach and can effectively deliver complex value propositions, whether in-person or virtually. Quick learning, self-motivation, and a drive to succeed are key. Candidates must demonstrate a proven track record of success in sales. Technology should be a tool you leverage to enhance communication and time management across a large territory. You should be adept at asking probing questions to uncover true pain points and position our solution effectively.

Microsoft Word - JOB Title

Key Responsibilities:

  •   Sell and Educate: Drive sales and build awareness of the company’s flagship product to clinicians in the medical, dental, and allied health sectors.
  •   Lead Generation: Identify and secure new customers through cold and warm calls.
  •   Inbound Support: Handle inbound inquiries and demonstrate how our services meet client needs.
  •   Proposal Demonstrations: Present complex value propositions to clinicians and their teams.
  •   Data Maintenance: Keep CRM systems updated with detailed records of all client interactions following best practices. Requirements:
  •   Proven sales experience with success in a competitive, hunter-driven environment.
  •   Post-secondary degree. Compensation:
  •   Base salary: $60,000-$70,000.
  •   Commission: Uncapped earning potential with a significant portion based on commission.

Company Overview: A healthcare technology company focused on improving administrative processes in clinics through augmented off-site administrative teams, optimized workflows, and AI-supported back-o...View more

Our client, a leading player in the construction industry, is seeking a Senior Project Manager to join their team.

Company Overview

Our client is one of the larger privately-owned construction companies in North America, providing comprehensive general contracting services. With over half a century of experience, they offer unparalleled expertise, driven by passion, focus, and a family-oriented culture. Established in 1948, they continue to earn their clients' trust by delivering projects with the highest level of confidence and professionalism.

The Role: Senior Project Manager

The Senior Project Manager will oversee all aspects of project administration, from pre-construction budgeting and scheduling to procurement, construction, and final project closeout. They will collaborate with the project team to ensure successful project delivery.

Key Responsibilities:

  •   Lead the project team to ensure the project is completed on time, within budget, and in accordance with design documents.
  •   Assist senior management in collaborating with various departments, including estimating, scheduling, procurement, and finance.
  •   Develop project bidding strategies and manage the tender process.
  •   Oversee the logistics plan and ensure minimal disruption to the surrounding area.
  •   Coordinate activities among project team members, including Assistant Project Managers and Superintendents.
  •   Review and approve major purchase orders, change orders, and contractor requisitions.
  •   Conduct regular meetings with contractors and design teams to track progress and address any issues.
  •   Monitor and report on project costs, schedules, and financials, ensuring alignment with the project baseline.
    Microsoft Word - JOB Title
  •  Manage client relationships, ensuring clear communication and consistent reporting.
  •   Oversee project closeout and secure client sign-off for the completed work. Qualifications:
  •   Degree in Engineering, Architecture, Construction Management, or a related field (or equivalent experience).
  •   Minimum of 10 years of construction project management experience.
  •   Current WHMIS certification and fall protection training.
  •   Strong understanding of construction, engineering, procurement, and industry standards.
  •   Excellent communication, leadership, and management skills.
  •   Proficiency with Microsoft Office and project management software. What We Offer:
  •   Competitive compensation package.
  •   Collaborative and dynamic work environment.
  •   Early departure on Fridays.
  •   Renovated office space with free coffee daily.
  •   Regular team bonding activities.

Our client, a leading player in the construction industry, is seeking a Senior Project Manager to join their team. Company Overview Our client is one of the larger privately-owned construction compani...View more

  • Must be a registered licensed mechanic through Skilled Trades Ontario. ( Truck and Coach Technician- 310T)
  • Must have the skillset to diagnose and carry out repairs efficiently.
  • Comfortable working on both heavy duty construction equipment and trucks.
  • Experience working on Caterpillar and Navistar equipment would be an asset.
  • Experience fabricating/welding would be an asset.
  • Must be available to work various shifts (i.e. day, afternoon, evening, weekends as required).
  • Possess a valid G class driver’s license, as some travel to jobsites is required.
  • Possession of an AZ license is an asset.

Job Features

Job Type

Full-time

Salary

$40.00-$46.00 per hour