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

S.i. Systems
Victoria, CA
57 $ / heure
Temps plein

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.
  • Il y a plus de 30 jours
Emplois reliés
S.i. Systems
Victoria, Colombie-Britannique

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

Data Analyst, you will combine your deep understanding of who our clients are with your passion for data and masterful analytics skills to uncover opportunities that will enable Aritzia to create long lasting relationships with clients. The mission of the Data & Analytics Department is to provide th...

S.i. Systems
Victoria, Colombie-Britannique

Senior DevOps Consultant with Azure and release coordination experience to build and maintain k8s environments for multiple projects . Implementing advanced monitoring for platforms and applications (Splunk cloud, Splunk Observability, etc. Experience designing and maintaining. Experience building a...

Arctic Wolf
Remote, Canada
Télétravail

And we appreciate that—by protecting people’s and organizations’ sensitive data and seeking to end cyber risk— we get to work in an industry that is fundamental to the greater good. We are looking for experienced developers to join our pack and work with us to continuously evolve and expand the capa...

S.i. Systems
Victoria, Colombie-Britannique

Experience working with Big Data tools such as PySpark, Hadoop, Data Bricks, MongoDB, Apache Spark, Apache Kafka. Experience with monitoring tools such as Splunk, Grafana, and Prometheus . Developer with search ranking (Apache Solr) experience to build microservices and queries for search indexing i...

KPMG
Canada, Canada

As a Manager within our Cybersecurity team, you will lead initiatives focusing on safeguarding our clients' data assets by implementing robust data protection strategies, enhancing compliance frameworks, and overseeing data security solutions. Design, develop, and implement data protection strategie...

Thompson Rivers University
BC, CA

Topics include organizations and organization theory; strategy, organizational design, and effectiveness; fundamentals of organizational structure; the external environment; inter-organizational relationships; manufacturing and service technologies; organizational culture; innovation and change; dec...

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...

Boyden
BC, CA

As an experienced leader with a proven track record of driving business transformation through technology, the Senior Director will build the talent, tools, and capabilities needed to collaborate with internal teams to identify and co-create new sources of value and competitive advantage for BCI. Al...

VCA Canada
Victoria, Colombie-Britannique

E-tools to assist with meditation, better sleep, exercise, and focus. VCA Canada is committed to providing an inclusive and diverse workplace and is an equal-opportunity employer. Work and Play on Beautiful Vancouver Island!. Veterinary Technologists to join our team in full-time, part-time, and cas...