Data and Systems Analyst

Description

SKYSERVICE BUSINESS AVIATION

Skyservice is the North American leader in business aviation. Focused on the key principles of safety and excellence, we offer a comprehensive service and expertise experience ranging from aircraft management to charter, maintenance and aircraft sales, in our airport aviation service terminals across Canada and the United States. People and values are inseparable assets that drive our commitment to quality, safety, respect, and efficiency. These core values guide us daily and contribute to our reputation as leaders in aviation services. Skyservice is a team dedicated to supporting and developing its staff. If you want to advance your career and join a team determined to go further and aim higher in business aviation, the Skyservice family of companies is the team for you.

Get to know us: https://www.skyservice.com/fr

A BRIGHT FUTURE FOR YOU AT SKYSERVICE

At Skyservice, we continue to grow and provide high-quality service to our customers, expanding our footprint and name across America. You will bring attention to detail and a fast-paced, dynamic schedule to a team that works together to exceed client expectations. We are focused on excellence and are dedicated to supporting and developing our teams!

JOB PURPOSE: The Data and Systems Analyst supports business operations by leading data analysis projects, managing critical data pipelines, and ensuring the maintenance of core business applications. They collaborate with business stakeholders and technology teams to bridge the gap between complex software development, cloud data engineering, and business intelligence, transforming raw data into reliable and useful information.

SUMMARY OF RESPONSIBILITIES

• Application and Systems Management: Maintain, optimize, and develop business systems and web interfaces using Visual Studio environments and C# language (.NET Framework and Core 9.0+)
• Data Pipelines and Engineering: Extract, synthesize, and transform large datasets from multiple sources using Azure Databricks (PySpark and Databricks SQL), and automate workflows with Power Automate
• Database Administration and Querying: Write and optimize complex queries for all relational databases and fix problematic ones, especially for Azure SQL and Oracle SQL databases, using SSMS and Oracle SQL Developer
• Reporting and Business Intelligence: Design, build, and maintain enterprise-level reports and dashboards using modern tools (Power BI) and existing systems (Crystal Reports)
• Artificial Intelligence and Document Automation: Implement intelligent workflow automation and data extraction using Azure Document Intelligence and Python scripts
• Stakeholder Collaboration: Collaborate with cybersecurity and business sector stakeholders to understand needs, map data requirements, and provide secure data solutions
• Data Quality and Documentation: Monitor data quality, resolve database issues to ensure absolute integrity, and document data definitions, processes, and application workflows

EDUCATION AND SKILLS

Education and Experience

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related quantitative field (or equivalent experience)
• Diverse experience of four to seven years, including data analysis, software design, and data engineering (senior level position – P03)

Technical Skills (required)

• Software Design: Strong proficiency in MS Visual Studio and C# language, and practical experience with .NET Framework and .NET Core (9.0+)
• Automation and Data Engineering: Practical experience with Azure Databricks (PySpark and Databricks SQL) and Python for data processing and scripting
• Database Management: Strong SQL skills and extensive operational experience with Azure SQL (SSMS) and Oracle SQL (Oracle SQL Developer)
• Reporting and Business Intelligence: Bimodal reporting skills and experience with Power BI (modern dashboards) and Crystal Reports (existing enterprise reports)
• Cloud and AI Tools: Knowledge of Azure Document Intelligence for extracting documents and data, and Power Automate for automating workflows

Essential Skills

• Strong understanding of data modeling, data structures, and database performance optimization
• Strong analytical and problem-solving skills, critical thinking, and great attention to detail
• Ability to manage multiple priorities simultaneously, work autonomously, and resolve complex system-level bugs
• Excellent communication skills and ability to translate technical developer concepts into clear business information
• Hands-on, solution-oriented mindset with a focus on delivering operational value
• Interpersonal skills, strong stakeholder management ability, and capacity to transform business needs into data solutions
• Excellent communication skills (both written and verbal)

Benefits

Here are some of the extras and benefits we offer:

• Hybrid work arrangements
• Group health insurance plan for you and your eligible dependents, including healthcare, vision care, and dental care
• Employee assistance program
• Group retirement savings plan with employer matching contributions
• Paid health and personal leave
• Employee referral program
• Service awards

Skyservice is an equal employment opportunity employer that accepts applications from all interested individuals. If, for any reason, you cannot submit your application through our employment site, please contact a member of our Human Resources team to make special arrangements.