Job Title: Sr. SQL Business Systems Analyst Job ID: 2024-12858 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. #J-18808-Ljbffr
Job Title
Sr. SQL Business Systems Analyst