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.
VP Merchandising, product development and design
Job Summary: The Vice President of Merchandising, Product Development, and Design is a key leadership role responsible for driving the strategic vision and execution of the company's merchandising, product development, and design initiatives. This role demands a dynamic leader who is both a strategi...
2X Senior Business Systems Analyst to do data mapping to support the development and implementation of advanced systems within the organization
Senior Business Systems Analyst to do data mapping to support the development and implementation of advanced systems within the organization. Conduct detailed technical requirements gathering to understand project needs and objectives. Perform comprehensive data mapping to ensure seamless integratio...
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...
Contract Management Specialist- Structural Design & Construction
In Canada, our 12,000+ people are involved in everything from environmental remediation to urban planning, from engineering iconic buildings to designing sustainable transportation networks, from finding new ways to extract essential resources to developing renewable power sources for the future. Th...
light duty cleaner
Sweep, mop, wash and polish floors. Vacuum carpeting, area rugs, draperies and upholstered furniture. Pick up debris and empty trash containers. Hours: 32 to 40 hours per week. ...
Senior Application Software Architect to assist in the implementation and in-service support for the delivery of the Future Aircrew Training System for the public sector.
This program aims to develop and implement a new, cohesive training program to replace the existing training systems for pilots and related aircrew roles. Participate in all kick-off meetings for the 3 Canadian base locations to analyze information and timelines derived from meetings against the IM/...
Intermediate Youth Worker
As one of Ottawa’s largest child and youth-serving charitable organizations, BGC Ottawa provides FREE, subsidized, and cost saving Community-based services, and life-changing programs to an annual average of 4,500 young Members each year. From anti-Racism to Reconciliation to LGBTQ2S+, food security...
Manager Of Design Services & Facilities - Operations
The job opportunity you have selected requires the Public Service Commission (PSC) to transfer you to the hiring organization's Web site or a service provider Web site they have selected to advertise this process. Select the link below to be transferred from the PSC's GC Jobs Web site and be directe...
Junior Top Secret cleared System Administrator to provide support for the upgrade and optimization of their enterprise level systems.
As a System Administrator you will assist in the day to day activities as well as participate in various projects dealing with performance and tuning, system maintenance, trouble shooting, installations & upgrades, cluster configuration & administration, monitoring and automation. Junior Top Secret ...
Website Developer Elementor and Branding Expert
We are a web design and development agency specialising in building businesses into real brands that shape the world!. We are seeking a talented and motivated Website Designer and Developer to join our dynamic team. Collaborate with our team to develop and maintain websites using WordPress and other...