Senior Data Integration Analyst

6 days ago

Toronto, Ontario, Canada Artech Full-time

Title : Senior Data Integration Analyst
Location:Toronto ,Ontario
Duration: 6 Months 

Join our dynamic team as an Information Technology Engineer, where you will play a crucial role in managing data workflows and collaborating with business stakeholders to optimize our file transmission processes. We are seeking a skilled professional who thrives in a fast-paced environment and is passionate about data integration and business analysis.

Required Skills & Qualifications

  • Experience with SQL Server Back-End development including: SQL Scripts, Stored-Procedures, Dynamic Stored-Procedures.
  • Proficiency in developing Python scripts and libraries.
  • Experience with Agile development, GitHub, SSMS, Dataiku.
  • Experience working with databases such as SQL Server, HDFS.
  • Experience with DBMS Data Modelling, ERD, Data Pipelines and DQ rules Implementation.
  • Ability to implement complex logic from Business Requirements using both SQL Stored Procedures and/or Python.
  • Capability to produce Architecture Design and Technical documents for all Layers such as Front-End UI, API End Points, and Back-End Stored Procedures.

Preferred Skills & Qualifications

  • Experience with ETL Workflow and Python/SQL and Dataiku Recipes using Dataiku Platform.
  • Experience designing front-end solutions with React.js, OpenShift, API Endpoints (APIGEE).
  • Experience with HR systems & workflow management tools such as Workday, SAP, ServiceNow.
  • Experience developing Tableau Dashboard and reusable Work Books.
  • Good knowledge of API Endpoints development using Python Language.

Day-to-Day Responsibilities

  • Take direction from the Data Acquisition Lead to collate data from various structured and unstructured data sources.
  • Coordinate with business stakeholders to gather information associated with each file transmission workflow.
  • Populate a workflow database with file transmission related data.
  • Participate in data triage calls with business stakeholders to help identify missing data for file transmission workflows.

Company Benefits & Culture

  • Inclusive and diverse work environment.
  • Opportunities for professional growth and development.
  • Supportive team culture that values collaboration and innovation.

For immediate consideration please click APPLY to begin the screening process with Alex.