Sr. SQL Business Systems Analyst

Job Title: Sr. SQL Business Systems Analyst

Job ID:

Job Location: Toronto, ON (2 days/week onsite)

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Duration:Long Term

# of Layers:0

Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers

Key Technology:Business Analysis, SQL, Power BI

Job Responsibilities:

• 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 Required:

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.