Data & Systems Analyst

LV Aero, LLC; Mississauga; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid working arrangements

Health benefits

Employee assistance program

Retirement savings plan with company 2

Paid time off

Job summary

Skyservice is seeking a Data & Systems Analyst to lead data analytics initiatives, manage critical data pipelines, and maintain core business applications. This role bridges software development, cloud data engineering, and business intelligence to turn raw data into secure, actionable insights.

You will work with Visual Studio, C#, Azure Databricks, Python, Azure SQL, Oracle SQL, Power BI, and Crystal Reports, designing robust reports and automation.

Qualifications

• Bachelor's degree in CS/Data-related field or equivalent experience.
• 4–7+ years blending data analytics, software development, and data engineering.

Responsibilities

• Maintain, optimize, and develop business systems and web interfaces using Visual Studio and C#.
• Extract, transform, and load data from multiple sources with Azure Databricks and PySpark; automate workflows.
• Write and optimize queries across Azure SQL and Oracle SQL; troubleshoot performance issues.
• Design and maintain enterprise reports and dashboards using Power BI and Crystal Reports.
• Implement AI/document automation using Azure Document Intelligence and Python scripting.
• Collaborate with stakeholders to map data needs and deliver secure data solutions.
• Monitor data quality and document data processes and workflows.

Skills

Visual Studio

C# / .NET

Azure Databricks

PySpark

Power BI

Crystal Reports

Azure SQL

Oracle SQL

Power Automate

Python

Data Modeling

Data Quality

SQL Performance Tuning

Education

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field

Tools

SSMS

Oracle SQL Developer

Power BI

Crystal Reports

Azure Document Intelligence

Power Automate

Job description

JOB PURPOSE:

The Data & Systems Analyst supports business operations by leading data analytics initiatives, managing critical data pipelines, and maintaining core business applications. This role partners with business stakeholders and technology teams to bridge the gap between complex software development, cloud data engineering, and business intelligence, transforming raw data into secure, actionable insights.

SUMMARY OF RESPONSIBILITIES:

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

QUALIFICATIONS AND SKILLS REQUIRED:

• Education & Experience:
  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related quantitative field (or equivalent experience);
  • 4-7+ years of blended experience spanning data analytics, software development, and data engineering (Senior - P03 level).
• Technical Skills (Required):
  • Software Development: Strong proficiency in MS Visual Studio, C# with experience in .NET Framework and .NET Core (9.0+).
  • Data Engineering & Automation: Hands-on experience with Azure Databricks (PySpark / Databricks SQL) and Python for data manipulation and scripting.
  • Database Management: Advanced SQL skills with deep operational experience in both Azure SQL (SSMS) and Oracle SQL (Oracle SQL Developer).
  • Reporting & BI: Double-threat reporting capabilities with experience in Power BI (modern dashboards) and Crystal Reports (legacy enterprise reporting).
  • Cloud & AI Tools: Familiarity with Azure Document Intelligence for document/data extraction and Power Automate for workflow automation.
• Core Competencies:
  • Solid understanding of data modeling, data structures, and database performance tuning.
  • Strong analytical, problem-solving, and critical-thinking skills with a high attention to detail.
  • Ability to manage multiple priorities, work independently, and troubleshoot complex system-level bugs.
  • Excellent communication skills with the ability to translate technical developer concepts into clear business insights.
  • Practical, solution-oriented mindset with a focus on delivering business value;
  • Strong interpersonal and stakeholder management skills, with the ability to translate business needs into data solutions;
  • Excellent communication skills (both written and verbal).

Benefits:

• Hybrid working arrangements
• Competitive group health benefits coverage for you and your eligible dependants, including health, vision and dental plans
• Employee assistant program
• Group retirement savings plan with company matching contribution
• Paid time off including sick days and personal days
• Employee Referral Program
• Service Awards

Skyservice is an equal opportunity employer and welcomes applications from all interested parties.