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.
Senior Infrastructure Analyst/Test Environment Management Specialist to support integration quality assurance and testing activities.
Collaborate with cross-functional teams (development, testing, infrastructure) to define, set up, and monitor test environments, troubleshooting issues and implementing automated tools for efficiency. As a Test Environment Management Specialist, you will ensure that Vancity integrates quality assura...
Physical Design Engineer - PnR Flow and Methodology
AMD together we advance_ THE ROLE: The North America SoC Physical Design Team within the GPU Technologies and Engineering is looking for an experienced Design professional with strong industry experience to join the PnR Flow and MethodologyTeam. KEY RESPONSIBLITIES: Bring deep knowledge and experien...
Identity Engineer to support Active Directory and EntraID infrastructure - 80144-1
EntraID Connect, EntraID SSO, EntraID App Registrations and SPN, role management, ability to design conditional access policies, understand tokens around EntraID, Phishing resistant MFA, EntraID secure score, Understand the EntraID hybrid configuration with Active Directory ). What does the LOB do?:...
Leadership Program Design & Development Manager, Deloitte Global People
This includes, but is not limited to, people with disabilities, candidates from Indigenous communities, and candidates from the Black community in support of living our values, creating a culture of Diversity Equity and Inclusion and our commitment to our AccessAbility Action Plan , Reconciliation A...
Int. JavaScript and PHP (Laravel) Developer to develop and enhance application services for our education client
Collaborating with other software developers and Product Delivery Leads to plan, design, develop, test, and maintain no code/low code web-based business forms and workflows and custom based applications. The candidates plan, architect, design, develop, implement, test, and solve problems with comple...
Technology Strategy & Transformation, Cloud Strategy, Director
We focus on building technology enabled and agile operating models, planning their new enterprise architecture into a differentiating capability system that helps them win in the market, leveraging digital analytics to enhance the customer experience and optimising business operations, and using mod...
Data Analyst and Reporting Tools Developer
The Data Analyst and Reporting Tools Developer reports to the Manager, Reporting and Analysis, is responsible for the planning, design, development, and deployment of new reporting database tools as well as the enhancement of existing reports and database reporting applications. Design and implement...
First Nations / Inuit / Métis - Senior Analyst, Data & Analytics
Uses data mining and extracting usable data from valuable data sources to assess feasibility of AI/ML solutions for improved processing and usage of organization data. Collaborate together with the product team and partners to understand and provide data-driven decision making, business planning and...
Corporate Law Clerk - Intermediate
Compose and file business name, partnership and limited partnership registrations as required by provincial legislation Draft and file extra-provincial and territorial registrations, amendments and annual returns on behalf of corporations, partnerships and limited partnerships as required by the var...
Senior Data Engineer - Data Security and Remediation
Have knowledge/experience of Big Data, Structured data, unstructured data such as Synapse, PostgreSQL, Azure Databricks Cosmo Database, ADLS, Blob, Oracle database and/or MS SQL. Follow Agile methodology to setup environment, configure, test, debug, and document in order to ensure successful impleme...