Intermediate ETL Developers to design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities

S.i. Systems
Regina
$57 an hour
Full-time

Our client is seeking a n Intermediate ETL Developer to design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities

  • Must Haves :
  • 5+ years of experience as a ETL Developer in database and / or reporting environments incorporating Microsoft SQL Server technology.
  • Experience in data warehouse / data mart design and development.
  • Experience with ETL processes / tools
  • Experience in visual design and development utilizing Microsoft Power BI, Tableau or similar software.
  • Understanding of OLAP / multi-dimensional data organization techniques and one or more related
  • SSIS and / or Informatica
  • Nice to Have :
  • SAS Data Integration studio
  • Education / experience in Advanced Mathematics and / or Statistics is considered an asset
  • Minimum 2-year diploma in Computer Science

Responsibilities :

  • Develop complex, mission critical reports, projects and applications.
  • Deliver professional quality of data analysis and ETL processes to reduce the high consequence of error.
  • Gather and formally document the object inventory, capturing details including data sources and data requirements to fulfill internal and external audit requirements.
  • Build Extract, Transform, Load processes using SAS Data Integrator based on a logical model or design.
  • Perform peer code reviews to ensure adherence to design, development and maintenance standards.
  • Contribute to design and development best practices and guidelines.
  • Monitor and remediate all issues with the data warehouse / data marts and reports.
  • Provide knowledge transfer to the other members of the development team.
  • Perform and support daily tasks such as job scheduling, monitoring, troubleshooting and remediation.
  • Support testing of solutions in all applicable environments.
  • Support stakeholders in the use of information products.
  • Assist with training materials, and demonstrations.
  • Ensure issues are identified, tracked, reported on and resolved in a timely manner.
  • Participate in post-project implementation reviews or lessons learned’, incorporating these lessons into appropriate process documentation, standards templates and checklists.
  • Perform other duties as assigned by the Information Management leaders.
  • 30+ days ago
Related jobs
S.i. Systems
Regina, Saskatchewan
Remote

Makes decisions related to the day-to-day execution of approved change adoption plans on behalf of the product or initiative sponsor; with considerable discretion to proactively identify and take action to manage barriers. Intermediate, Bilingual (En/FR) Change Management Professional (5+ years) to ...

Charter
Anywhere - Canada

Founded in 1997, Victoria headquartered Charter has grown into one of Canada's foremost fastest growing Information Technology providers in the country, providing a broad array of high value product and service solutions to clients operating some of the most mission critical networks and application...

S.i. Systems
Regina, Saskatchewan

Senior Reliability Cleared SAP Ariba Cloud on-demand Consultant to implement and deploy SAP Ariba based supplier relationship management and procurement solutions. The resource will adapt existing methods and procedures to create possible alternative solutions to the client's complex problems. Respo...

LEELOG TECHNOLOGY
CA

Assign IT projects to systems analysts, programmers and other computer technicians. Computer and technology knowledge. Work conditions and physical capabilities. Are you currently legally able to work in Canada?. ...

S.i. Systems
Regina, Saskatchewan

Senior M Solutions Architect and SME to lead a technical team supporting a DLP (Data Loss Prevention) Program with expertise in Purview and SharePoint Information and Records Management solutions. Experience designing and implementing. Experience designing and implementing. Installing and configurin...

Aritzia
Canada, Canada

As the Senior Engineer, Digital Platform, you will leverage modern software development and operational practices to support a comprehensive approach to Digital Analytics-ensuring the right data is collected, and the appropriate tools and technologies are in place to support in-depth understanding a...

Refonte Learning
Canada

Are you passionate about uncovering insights in data and eager to launch your career in data analytics? Refonte AI, a global leader in IT and Ed-tech, invites you to join our. With expertise spanning digital marketing, data science, data analytics, UI/UX design, web development, and app development,...

KPMG
Canada, Canada

We play an integral role in helping our clients ensure they are protected by developing transformation strategies focused on security, efficiently integrate and manage new or existing technology systems to deliver continuous operational improvements and increase their return on cybersecurity investm...

Macropus Global
Canada

Architect, implement, and test data processing pipelines and data mining / data science algorithms on a variety of hosted settings such as AWS, Azure, client technology stacks. Perform activities related to software design, operating architecture integration, and support in the selection of appropri...

KPMG
Canada, Canada

We play an integral role in helping our clients ensure they are protected by developing transformation strategies focused on security, efficiently integrate and manage new or existing technology systems to deliver continuous operational improvements and increase their cybersecurity investment, and d...