Database Administrator/ETL Specialist | [X.014]

Database Administrator/ETL Specialist | [X.014]

18 May
|
Research Reserved
|
Toronto

18 May

Research Reserved

Toronto

Company Overview

Compass for Success is a collaboration of school boards working together to build capacity to use data to improve student achievement It represents the collective development of technologies within a framework focused on research-driven data to allow Teachers, Superintendents, Directors and Principals the ability to see and use the data in a way that will help students succeed. We are currently looking to add to our team a Database/ETL and Business Intelligence Specialist.

Position Summary

The DBA/ETL and BI Specialist will be responsible for the support and day to day maintenance and management of our data warehouse environment. The incumbent will develop, maintain and implement high-quality,





high-performance Data Warehouse and BI solutions.

Job Duties and Responsibilities


- Strong technical competencies using SQL Server, SSAS, SSIS, Cognos Data Manager
- Managing and maintaining corporate systems, data environments and reporting tools using Cognos BI, Cognos Data Manager, Microsoft Analysis Services
- Provides end user support for clients
- Develops, tests, documents and implements high-performing, scalable solutions including schema design, storage engines, indexing strategies, SQL tuning, ETL processes, stored procedures and software applications
- Determine the quality and integrity of data required to meet business needs of the end users and work towards resolving the most critical data quality issues.
- Evaluate and improve data quality throughout source systems by implementing data quality safeguards.
- SSIS Data warehouse design, including build, migration and configure ETL processes, data mappings & transformations to orchestrate data integrations.
- Use and support database applications and tools for extraction, transformation and analysis of raw data.
- Ability to understand business processes, data entities, data producers, and data dependencies.
- Develop, manage, and validate existing data models including logical and physical models of the data warehouse and source systems.
- Designing and developing exception handling and data cleansing / standardization procedures.
- Evaluate and improve data quality throughout source systems by implementing data quality safeguards.
- Participate in discussions with business users and source system owners to derive business and data rules to be used in data quality assessments.
- Provides support for the implementation and deployment of new data solutions


Qualification Skills Requirement

A professional at this position level within Accenture has the following responsibilities:


- 5+ years’ experience with SQL Server
- 4+ years Cognos Data Manager or equivalent
- 3+ years’ experience with data extraction/ETL tools
- Adapts existing methods and procedures to create possible alternative solutions to moderately complex problems
- Uses considerable judgment to determine solution and seeks guidance on complex problems interaction with peers and/or management levels and the client level
- Determines methods and procedures on new assignments with guidance. Decisions often impact the team in which they reside. Ability to meet travel requirements
- Ability to communicate design solutions to both technical and non-technical audiences.
- Strong analytical and documentation skills
- Experience in data architecture, data warehousing, data management, enterprise information integration and ETL
- Knowledge of education data in particular student data is an asset
- French and English language would be an asset
- Experience with data analysis, modeling and design specific to a data warehouse
- Experience with the design of large scale ETL solutions integrating multiple source systems
- Experience with Cognos Analytics, Report Studio, one or more best of breed BI tools is a plus.
- Proven success in contributing to a team-oriented environment
- Proven ability to work creatively and analytically in a problem-solving environment
- Excellent leadership, communication (written and oral) and interpersonal skills.
- Confidentiality and privacy is a priority


Important Messages


Your application must clearly demonstrate how you meet the requirements as we cannot make assumptions about your education and experience.

We thank all those who apply. Only those selected for further consideration will be contacted.


___________________

Property Maintenance Technician

Property Maintenance Technician

25 May
|
Anonymous Company
|
Toronto
  • 25 May
  • Anonymous Company
  • Toronto

Looking for experienced crew members. We use stihl line trimmers and blowers, Toro tractors and walkbehinds and honda push mowers. Commercial property maintenance working an average of 50 hours per we [...]

Préposé à l’entretien ménager et à la maintenance (Concierge)

Préposé à l’entretien ménager et à la maintenance (Concierge)

25 May
|
Anonymous Company
|
Montréal
  • 25 May
  • Anonymous Company
  • Toronto

Nous recherchons un préposé à l’entretien ménager et à la maintenance (Concierge). Ce poste est à temps partiel (18-20 heures par semaine) et se situe à St-Hubert sur la Rive-Sud. Les journ [...]

(TR-388) - Moving helper available here

(TR-388) - Moving helper available here

25 May
|
Research Reserved
|
Toronto
  • 25 May
  • Research Reserved
  • Toronto

I can help with any kind of moving. Available on short notice. Loading and unloading helper. 3657738447 [...]

(OO006) - Entrepot distribution preparateur de commande mannutentionaire

(OO006) - Entrepot distribution preparateur de commande mannutentionaire

25 May
|
Confidential
|
Montréal
  • 25 May
  • Confidential
  • Toronto

Bonjour nous sommes une company de distribution alimentaire a laval. Nous cherchons un preparateur de commande. Aussi comme commis dentrepot, le preposer doit aussi organiser et nettoyer lentrepot. Pa [...]

Subscribe to this job alert:
Enter Your E-mail address to receive the latest job offers for: database administrator/etl specialist | [x.014]
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert