About the role
We are Systematix and we are looking for a Data Warehouse ETL Developer for an upcoming opportunity with a Federal Government department. The ideal candidate must already possess a security clearance at the Reliability level (Level I) or higher and be bilingual in both official languages (English and French).
About the Project
The resource designs, develops, and maintains data warehouse and analytics architecture to meet the client’s enterprise’s business analysis and reporting needs. The resource also provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.
About the Responsibilities
- Designs, maintains, and provides support for data warehouse systems and related data marts;
- Translates business requirements into viable technical solutions;
- Participates in the testing of developed technical solutions;
- Participates in the investigation and resolution of complex Data Warehouse issues;
- Proactively identifies opportunities for process, systems, and other efficiency improvements;
- Works effectively in the team and contributes to team effectiveness through personal style;
- Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.
About the Qualifications
- Minimum of eight years of related experience and knowledge;
- Recent experience working with Cognos Data Manager
- 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQL Server;
- Bilingualism in both official languages (English and French).
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio).
Candidates must outline in detail how they meet the above requirements.
At Systematix, our core values—excellence, collaboration, respect, and knowledge as a pursuit—underpin our commitment to fostering an inclusive and equitable environment. We encourage everyone to be their authentic selves, and we are committed to ensuring that our employment decisions are entirely based on job requirements and individual qualifications. We welcome applications from qualified candidates of all backgrounds, including but not limited to race, ethnicity, gender identity or expression, sexual orientation, disability, age, and religious beliefs. If our values and the position advertised resonate with you, we encourage you to apply.
About Systematix
Systematix is one of North America's most tenured and trusted IT Consulting and Solutions Firms, with offices spread throughout Canada, in the US and UK.
For over 40 years we have delivered local, exceptionally cost effective resources and solutions, and never offshore. Our longstanding success if predicated on three core principles: Expertise, Ethics and a Commitment to your Success.
Our service catalog is vast, but focuses on 3 key offerings:
• IT Consulting • IT Resourcing • IT Solutions
We pride ourselves on our geographic capability, regional autonomy, and exceptional client relationships. With over 800 consultants and growing, Systematix is the organization to help you empower your technology, on demand.
For more information or openings at Systematix, always go to www.systematix.com
About the role
We are Systematix and we are looking for a Data Warehouse ETL Developer for an upcoming opportunity with a Federal Government department. The ideal candidate must already possess a security clearance at the Reliability level (Level I) or higher and be bilingual in both official languages (English and French).
About the Project
The resource designs, develops, and maintains data warehouse and analytics architecture to meet the client’s enterprise’s business analysis and reporting needs. The resource also provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.
About the Responsibilities
- Designs, maintains, and provides support for data warehouse systems and related data marts;
- Translates business requirements into viable technical solutions;
- Participates in the testing of developed technical solutions;
- Participates in the investigation and resolution of complex Data Warehouse issues;
- Proactively identifies opportunities for process, systems, and other efficiency improvements;
- Works effectively in the team and contributes to team effectiveness through personal style;
- Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.
About the Qualifications
- Minimum of eight years of related experience and knowledge;
- Recent experience working with Cognos Data Manager
- 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQL Server;
- Bilingualism in both official languages (English and French).
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio).
Candidates must outline in detail how they meet the above requirements.
At Systematix, our core values—excellence, collaboration, respect, and knowledge as a pursuit—underpin our commitment to fostering an inclusive and equitable environment. We encourage everyone to be their authentic selves, and we are committed to ensuring that our employment decisions are entirely based on job requirements and individual qualifications. We welcome applications from qualified candidates of all backgrounds, including but not limited to race, ethnicity, gender identity or expression, sexual orientation, disability, age, and religious beliefs. If our values and the position advertised resonate with you, we encourage you to apply.
About Systematix
Systematix is one of North America's most tenured and trusted IT Consulting and Solutions Firms, with offices spread throughout Canada, in the US and UK.
For over 40 years we have delivered local, exceptionally cost effective resources and solutions, and never offshore. Our longstanding success if predicated on three core principles: Expertise, Ethics and a Commitment to your Success.
Our service catalog is vast, but focuses on 3 key offerings:
• IT Consulting • IT Resourcing • IT Solutions
We pride ourselves on our geographic capability, regional autonomy, and exceptional client relationships. With over 800 consultants and growing, Systematix is the organization to help you empower your technology, on demand.
For more information or openings at Systematix, always go to www.systematix.com