Sr. SQL Business Systems Analyst

Job Title:
Sr. SQL Business Systems Analyst

Job :

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

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

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

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

• Undergraduate Degree.