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.
Enterprise Architect (Data & Infrastructure)
Symbol" data-leveltext=" " data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":" ","...
Sr Network Performance Analyst (5G/LTE) to perform network analysis, capacity planning and optimization for our large telco client- 19188
By collaborating with other technical and business teams to understand new technologies and services to make our team to succeed in an evolving business environment. As a 5G Capacity and Data Analytics Specialist, you’ll provide technical leadership to ensure we efficiently plan and deploy network c...
Brake Actuation Design and Release Engineer - PSP
The Brake Actuation Design and Release Engineer will be responsible for leading design and development of brake actuation systems (booster/master cylinder/electric vacuum pump/vacuum hoses/eboost systems), coordination of program timing/design guidelines with supplier and packaging of brake actuatio...
SR Business Analyst with Oracle Field Service and/or Maximo experience to support a electrical utilities project
This role requires a candidate with a strong understanding of electric utility terminology, technical expertise in relevant systems, and a proactive approach to problem-solving and feedback collection. Collaborate with stakeholders to collect, document, and analyze business requirements for the ADMS...
Senior Design Architect - Transit and Operations, Maintenance, Storage Facilities (OMSF)
This professional will work with senior members of the design team and provide direction to novice staff to develop design solutions appropriate to the context, budget, and aesthetic requirements of architectural projects. Our teams are driven by a common purpose to deliver a better world through ou...
Junior Supply Chain Administrator to provide purchase order life cycle management and supplier support (8949)
Manage purchase order lifecycle which includes monitoring, investigation and timely resolution of purchase order, receiving and invoicing queries and discrepancies. Junior Supply Chain Administrator to provide purchase order life cycle management and supplier support. Manage large volumes of purchas...
Mathematics and Science Teacher (Grades 6 to 8)
At CFIS we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role, but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway with a cover letter and resume describing why yo...
Senior Business Consultant - Land and Property Design (Future opportunities)
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...
Bartender at The Wilde, The Dorian, Autograph Collection and Courtyard by Marriott Calgary Downtown
Follows our 5 Star Service Standards, as outlined in the Service Standards Manual, on greeting etiquette, table service, technical proficiency and knowledge of food and beverage service, steps of service and departure of guests. Cell phone is to be tucked away and non-visible to guests or management...
HR Systems and Data Advisor, Human Capital
Maintain data integrity by conducting audits, reviewing reports and analyzing data for accuracy and completeness; question inconsistencies in data and bring forward to HC leadership. Engage with national and regional leadership, stakeholders and vendors to ensure our HC technology supports regulator...