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

S.i. Systems
Victoria, CA
$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
Victoria, British Columbia

The successful candidate will oversee that all security programs, tools, and technologies are working correctly, providing the necessary protections to the company's computer systems, databases, and networks from cyberattacks or security breaches. Open to candidates in Tumbler Ridge willing to work ...

Aritzia
Canada, Canada

Operational Efficiency and Continuous Growth: Commitment to operational efficiency and the ability to identify and implement process and system improvements to drive team and business results. The mission of the Data & Analytics Department is to maximize the value of Aritzia's data by making it avai...

S.i. Systems
Victoria, British Columbia

Performing MDG Configurations and Customizations in areas like Data Modeling, UI Modeling, Process Modeling, Data Replication Framework, Key Mapping, rules, and derivations, BRF+ . SAP MDG consultant to do data modelling, process modelling and data replication for operations and enhancement projects...

York Region District School Board
British Columbia, Canada

Under the collaborative direction and mentoring support of the Interschool Principal and Director of Education, the Witat Principal Teacher is the primary administrative leader of and responsible for the day to day operations of the school, for providing educational leadership that continuously impr...

S.i. Systems
Victoria, British Columbia

Establish and maintain a close engagement with specialists from the HR, training and communication branches to ensure a smooth transition to change and organization-wide successful implementation of these change initiatives. Identify deviations in performance from the change standards and implement ...

Turner & Townsend
Canada Wide, Canada

Relocating with Turner & Townsend gives the opportunity to expand your skillset and provides a unique chance to experience a different culture and work environment, fostering personal and professional development. In order to be an authorised Recruitment Agency/Search Firm for Turner & ...

Deloitte
Victoria, British Columbia

Design development programs and offerings, including but not limited to: skill development programs and modules, career milestone programs and modules, leadership development experience programs, etc. Design and develop all support materials, including program presentations, facilitator guides, prog...

ITREB
Canada

The data analysis and Quality assurance program team ensures appropriate data collection, compliance to privacy protection and reporting to allow program improvement. Analyze and provide data on requested metrics to national and regional teams, ensuring data accuracy and relevance. Continuously revi...

5th World Regenerative Agriculture Corporation
CA
Remote

As a Senior Business Consultant - Land and Property Design at 5th World, you will play a pivotal role in guiding our clients toward implementing regenerative systems, ecosystem restoration, renewable energies, and advanced water management practices. Empathy: Ability to take on another's perspective...

LaowaiCareer
Victoria, British Columbia

Schedule and coordinate speaking engagements, appearances, photo shoots, and other special events. Your daily duties and responsibilities shall consist of, but not limited to the following:. Applicants should also have strong writing skills, as well as a solid understanding of social media. Only int...