Data Integration Specialist Job at Q1 Technologies, Inc., Canada

bk54dFJXM3hmM2VWZGNxbmViaVp1eXpJU3c9PQ==
  • Q1 Technologies, Inc.
  • Canada

Job Description

Job Description

Role: Data Integrator (Power BI)

Major Responsibilities :

  • Design and Develop ETL Processes: Architect and implement ETL workflows to extract data from diverse sources, transform it into a usable format, and load it into a data warehouse or data mart.
  • Data Pipeline Management: Manage and maintain the ETL pipelines, ensuring data integrity and consistency. Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, SnowSQL and SnowPipe) to develop data pipeline solutions to ingest and exploit new and existing data sources.
  • Database Design and Management: Design and manage database structures, including tables, views, and indexes, to support ETL processes. Experience designing and developing Enterprise Data Warehouse solutions.
  • Data Modeling: Develop and maintain data models to ensure data quality and consistency within the BI system. Proficient writing SQL and Python queries and programming including stored procedures and reverse engineering existing process.
  • Data Visualization :Create clear and concise visualizations (charts, graphs, dashboards) to communicate data insights effectively.
  • Documentation : ability to create well documented tech specs and user guides of existing dashboards.
  • Data Quality Assurance: Implement data quality checks and validation processes to ensure the accuracy and reliability of the transformed data.
  • Performance Tuning: Optimize ETL processes for performance, scalability, and efficiency.
  • Scheduling : Setting up Tidal jobs.

Skills:

  • 5+ years - Enterprise Data Management
  • Expertise in developing and maintaining Azure data factory pipelines.
  • 2+ years of hands-on experience with Databricks.
  • 5+ years - SQL Server based development of large datasets
  • 3+ years with Data Architecture
  • 3+ years’ experience in Finance / Banking industry – some understanding of Securities and Banking products and their data footprints
  • 3+ years Python coding experience.
  • Proficient with Power BI or other data visualization tools
  • Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe
  • Working knowledge of MS Azure configuration items with respect to Snowflake.
  • Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
  • Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling
  • Previous experience contributing to an enterprise-wide Cloud Data Platform migration
  • Experience with Cloud based data architectures, messaging, analytics

Job Tags

Similar Jobs

County of Delaware, PA

Correctional Officer Job at County of Delaware, PA

 ...details, reception, intake, and visits officer, etc., as required by management. Provides...  ...training standards. Performs correctional duties for any shift as defined by management...  ...Do you have prior correctional experience? Yes No 08 If you... 

Express Pros Mt Vernon

Patient Care Coordinator - Y869 Job at Express Pros Mt Vernon

 ...Express Employment Professionals of Mount Vernon has partnered with a local dental office committed to providing top-quality dental care to their patients in a friendly and welcoming environment. Their team of dedicated professionals are passionate about helping patients... 

Longview Regional Medical Center

Travel Inpatient Rehabilitation Physical Therapist - $2,160 per week Job at Longview Regional Medical Center

 ...Certification Details BLS Current Texas licensure Job Details Physical therapists (PTs) are licensed health care professionals who can help patients reduce pain and improve or restore mobility. Physical therapists can teach patients how to prevent or manage... 

Dakota Vascular

Registered Nurse (RN) Clinic/Procedures Job at Dakota Vascular

 ...education and support Job Requirements Qualifications: Active RN license in the state of South Dakota Minimum of 1 year of clinical experience Minnesota license required upon hire Excellent communication and interpersonal skills Ability to work in a... 

Mohawk Valley Health System

LPN - NYSUT (VNA) -(UTICA, NY) Job at Mohawk Valley Health System

 ...acute care setting. Excellent written, verbal and interpersonal communication skills. Proficient with EHR tools. Ability to travel to patient homes which may not be handicap accessible with reliable transportation. Licensure/Certification Requirements...