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
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.