Sr. SQL Business Systems Analyst

GalaxE.Solutions; Toronto; On-site; CAD 95,000 - 135,000; Full time

Job summary

A leading IT services firm in Toronto seeks a senior Business Analyst with expertise in data analysis and SQL. You will be responsible for optimizing data processes, ensuring data quality, and collaborating with teams on technical solutions. This role offers the opportunity to work with cutting-edge data tools and direct impacts to enterprise business transformations.

Qualifications

• 10+ years of relevant experience as a Business Analyst.
• Experience with SQL and NoSQL databases.
• Ability to write SQL queries.

Responsibilities

• Analyze current data processes and recommend improvements based on industry trends.
• Ensure data quality and integrity across various sources and systems.
• Implement and optimize data pipelines for performance.

Skills

SQL

Data Analysis

Data Quality

Problem Solving

Education

Undergraduate Degree

Tools

Hadoop

Spark

Kafka

Databricks

Job description

• Analyze current data processes and make recommendations for improvement based on industry trends and professional business knowledge
• Work directly with team to understand analysis and design needs
• Use a variety of data analysis and organization tools to discover the most impactful
• Implement data products curated by our Chief Data Office, as well as custom data models for fit for use.
• Ensure data quality and integrity across various data sources and systems to ensure data accuracy, completeness, and reliability.
• Optimize data pipelines for performance and scalability.
• Provide technical support to promptly resolve escalated incidents / outages.
• Develop and document a detailed solution design, impart your subject matter expertise throughout life cycle.
• Develop system performance and development standards requirements, then develop functional, technical and designs.
• Build design leverages existing reusable components, traces back to business requirements, and that new modules are designed with reusability in mind.
• Keep up to date with the latest industry trends and technologies related to data engineering.

Skills and Experience You Will Need

Required :

• 10+ years of relevant experience as BA.
• Must be an experienced user with relational SQL and NoSQL databases.
• Ability to write SQL queries

Desired :

• Experience with : Java, Spring,
• Experience with big data tools : Hadoop, HDFS, ADLS, ADF, Spark, Kafka, Databricks,
• Experience in Python
• Knowledge of Capital Markets.

Education :

• Undergraduate Degree.

Who We Are

GalaxE, now Endava, is a professional IT services firm that specializes in platform-driven solutions and the use of automation to achieve enterprise business transformation and mission-critical change for some of the largest companies in the world. Using our proprietary solution set, GxFource, we apply machine learning techniques and predictive analytics tools as part of a broad artificial intelligence strategy that provides effective impact and data-driven business transformation.

Since its founding, GalaxE has been dedicated to advancing the benefits of technology. Recently, we have joined forces with Endava, to offer our employees global exposure and enhanced opportunities. As we continue that legacy and look to the future, a focus on business enablement through agile, cost-efficient, and effective integration of people, process, and technology anchors our success. We revolutionize change in the costs of doing business that transform companies and their ability to leap beyond the competition.

We value people and are committed to diversity and inclusion where our employees are made to feel comfortable and are encouraged to be authentic.

We are always looking for passionate, entrepreneurial-minded innovators and disrupters; game-changers that take ownership of the work they produce and bring it each and every day. Working with like-minded team members you will get a chance to discover, develop, and use cutting-edge technologies to transform the way we deliver creative business solutions.

Sound like you? Join us and find out for yourself what it means for you, and your career, to be part of the GalaxE team. Let’s build something, together.

• Equal Opportunity Employer / Veterans / Disabled
• Payisbasedonseveralfactorsincludingmarketlocationandmayvarydependingon actualjob-relatedknowledge,skills,andexperience.

Physical Requirements :

• Prolonged periods of remaining stationary at a desk and working on a computer
• Must be able to lift to 15 lbs., as needed
• Must be able to work on-site (corporate / client offices), as needed (not applicable for 100% remote roles)
• Occasionally required to bend, kneel, crouch, and reach overhead.
• Hand-eye coordination necessary to operate computers and various pieces of office equipment.
• Specific vision abilities required include close vision, the ability to tolerate fluorescent lighting, and the ability to adjust focus.

Employees must be able to perform the physical requirements of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.

Create a job alert for this search