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.
Int. Application Support Analyst to maintain and support Data Warehouses and Applications for a large insurance client - 5198
Work closely with business partners and internal clients to provide end to end support to ingest and retain data in the EDL and maintain the data integrity. The candidate must work well within a dynamic environment and have an ability to understand applications and handle multiple requests and prior...
Technology & Data Internship Program
The program provides you access to a virtual classroom and on the job training where you will learn how to leverage your problem solving and technical skills to help make critical business decisions. We encourage you to bring your authentic self to work and take every opportunity to excel in your ro...
Intermediate IT Asset Coordinator to assist with the lifecycle management of software & hardware assets- 195122
Hybrid (3 days in the office, Brampton). Working with other teams & vendors to ensure product is procured. Participate in IT Asset Management activities as required. ...
design draftsperson
Prepare engineering designs and drawings. Develop and prepare design sketches. Read blueprints to determine work requirements. Prepare construction specifications, costs and material estimates. ...
Sr. UX Designer/Content Strategist to play a critical role in leading content assessment and strategy projects for our client -
UX Designer/Content Strategist to play a critical role in leading content assessment and strategy projects for our clients. The candidate will be responsible for conducting comprehensive research, defining strategic recommendations, and developing content plans that align with business objectives an...
Coding and Data Management for Business Analytics
Minimum Qualifications Must have completed and achieved a minimum grade of “A” MGT301 equivalentcourse with programming/codingexperience and familiarity withPython/SQL or equivalent. Meet with or respond to students inquiries during office hours. Update material and grades on Quercus courseware. Att...
Subject Matter Expert B2B (Data Science and ML courses)
Get hands-on experience in an Edtech environment (learning tools and the ins and outs of online education for adults). We're excited to get to know you and work together!. Data Science, Machine Learning, and AI training to help organizations enhance the capabilities of their workforce. Collaborate w...
Analyst, Procurement Strategy & Transformation
Support various strategic initiatives (big and small) including process re-design, strategy development, budget and priority-setting, digital culture transformation and more - it's an exciting and fast-paced environment and you'll be required to leverage your problem-solving, communication, project ...
Project Manager (Regulatory & Financial Transformation)
Toronto, ON, Canada Req #2799 Monday, July 29, 2024 Questrade Financial Group (QFG) of Companies is committed to helping our customers become much more financially successful and secure. You will collaborate and align end-to-end project milestones and goals with multiple stakeholders, technology tea...
Senior Care NeededStrongAble to pick up a man(170pds)Dufferin & Bloor7pm to 10 pm Portuguese
We need an experienced, hard-working and responsible senior care provider near Toronto M6H. Services such as Personal care (bathing, grooming), Live-out care and Mobility support will be part of this job. Please send me a message to discuss this job in more detail. ...