Database Analyst

1 month ago


Ottawa, Canada RealDecoy Full time

**To qualify, you**:

- **Must be able to obtain and maintain a valid Canadian Security Clearance at the level of SECRET; and**:

- **Must be a citizen of Canada.**
- Must hold a Bachelor’s degree in Computer Science.
- Must have a minimum of 3 years’ experience within the last five (5) years: As a Database Analyst/Information Management Administrator.

Managing database architecture design and development for large and complex data sets
Developing and implementing Extraction, Transformation and Loading (ETL) processes comprising multiple large and /or complex databases.
Developing and maintaining data dictionaries and/or documenting ETL processes.
- Must have a strong oral and written command of the English language.

**Responsibilities**:

- **Key**_
- Identify requirements for improvements to existing databases by determining users' information requirements and system performance and functional requirements.
- Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database.
- Mediate and resolve conflicts among users' needs for data.
- Advise programmers, analysts, and users about the efficient use of data.
- Optimize the data configuration of current BI tools.
- Develop and implement a data acquisition strategy including obtaining, staging, merging and sharing data.
- Optimize the Extract, Transform, and Load (ETL) processes.
- Design, develop, and test the regular, recurring data acquisition procedures to obtain data from departmental data sources.
- Evaluate, recommend and implement data validation and verification processes to confirm that data warehouse accurately reflects data from Systems of Record (SoR)
- Participate in processes for elicitation and prioritization of user data needs.
- Automate end-to-end data pipelines to ingest, transform, and publish data.
- Support business initiatives with additional Qlik and Tableau dashboards to surface relevant data as visualizations.
- Assist business users with creating visualizations in Tableau and Qlik.
- Write script to generate reports on incoming data quality.
- Write scripts to automate data validation.
- Collaborate with data providers to resolve anomalies and errors in the data they provide.
- **Occasional**_
- Data Modeling
- Define new database structures.
- Define data conversion strategy.
- Define database conversion specifications.
- Define the data conversion strategy for each business initiative including providing recommendations on the ETL process.
- Write system configuration and maintenance documentation.

**Relevant skills include**:

- **Must Have**_
- Microsoft SQL Server 2016 (or higher)
- SQL
- Excel (including Macros)
- **Nice to Have**_
- CloverDX ETL
- Process automation with Jenkins
- Tableau, Tableau Prep
- Qlik Sense
- PowerBI
- Scripting, including PowerShell, Python, and Groovy
- Graph databases, such as Neo4j

**Safety and Security Requirements**

The applicant must be a **citizen of Canada and eligible for (or already** **hold) a valid Facility Security Clearance at the level of SECRET, issued by the Contract Security Program (CSP), Public Works and Government Services Canada (PWGSC).**

**About RealDecoy**

**RealDecoy** is a professional services company focused on transforming information into meaningful experiences for our clients. Our value is derived from remaining open and flexible with an emphasis on personal client engagement. We tailor every aspect of our work to each client since every client has a unique business need. As a result, RealDecoy has been rewarded with long lasting client relationships, referrals, and additional engagements.

This approach is also reflected in our employees and company culture. At RealDecoy, we are more than the sum of our parts, and we embrace the best ideas in the room by respecting that everyone has a voice. We are led by our values **- We Care, We Lead **and **We Learn** and this is reflected daily in our culture and our interactions. We are comprised of an interconnected group of individuals who learn and collaborate together. RealDecoy formally recognizes and encourages a cultural environment that fosters personal growth and knowledge. We embrace ideas and provide thought leadership in everything we do which is then reflected in the quality of work we deliver to our customers.
- **So, what do you think? Do you sound like a RealDecoy employee?**_

Thank you for considering a career with RealDecoy.

**Salary**: From $85,000.00 per year

**Benefits**:

- Company events
- Dental care
- Extended health care
- Life insurance
- Paid time off
- Profit sharing
- Wellness program

Schedule:

- 8 hour shift
- Monday to Friday

Ability to commute/relocate:

- Ottawa, ON: reliably commute or plan to relocate before starting work (required)

Application question(s):

- Do you possess a valid Canadian Security Clearance at the level of SECRET?

Application deadline: 2023-01-14


  • Database Analyst

    3 weeks ago


    Ottawa, Canada The Royal Ottawa Mental Health Centre Full time

    **Position Information** **Posting Number**: - ROM23-054E**Title**: - Database Analyst (TFT 1.0 FTE)**Position Status**: - Temporary Full-time**Contract End Date**: - 03/31/2024**FTE**: - 1.0**Job Schedule**: - Days**Department**: - Data & Analytics**Union**: - Non-union**Site**: - Royal Ottawa Mental Health Centre**About The Royal** - As one of...


  • Ottawa, Canada ADGA Group Consultants Inc Full time

    Company Description Our culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to...


  • Ottawa, Canada ADGA Group Consultants Inc Full time

    Company Description Our culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to...


  • Ottawa, Canada ADGA Group Consultants Inc Full time

    Company Description Our culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to...

  • Data Analyst

    2 months ago


    Ottawa, Canada Compugen Inc Full time

    **Job Title** - Data Analyst **Vacancy No** - VN6014 **Work Location** - Ottawa, ON **Job Details** - The Data Analyst, reporting to the Specialist, Data Analysis, supports the Microsoft Structure Query Language (SQL) Server database and collects, transforms, and analyses data into convenient data sources. The Data Analyst develops user friendly reports...

  • Pricing Analyst Iii

    2 days ago


    Ottawa, Canada Thermo Fisher Scientific Full time

    **Pricing Analyst III, Fisher Scientific, Ottawa, Canada** **Position Summary**: The Pricing Analyst supports Pricing Operations group in meeting complex customer pricing requirements and profitability improvements through conducting pricing analysis and problem solving. **Key Responsibilities**: - Provide analysis and technical support for pricing...


  • Ottawa, Canada Thermo Fisher Scientific Full time

    **Pricing Analyst III, Fisher Scientific, Ottawa, Canada** The Pricing Analyst supports Pricing Operations group in meeting complex customer pricing requirements and profitability improvements through conducting pricing analysis and problem solving. **Key Responsibilities**: - Provide analysis and technical support for pricing initiatives that include...

  • Business Analyst

    1 week ago


    Ottawa, Canada Canada Foundation for Innovation Full time

    With a bold, future-looking mandate, the Canada Foundation for Innovation equips researchers to _ - be global leaders in their field and to respond to emerging challenges. Our investments in state -of-_ - the-art tools, instruments and facilities underpin both curiosity - and mission-driven research that _ - cuts across disciplines and bridges all sectors....

  • Pricing Analyst Iii

    1 month ago


    Ottawa, Canada Thermo Fisher Scientific Full time

    As part of the Thermo Fisher Scientific team, you will discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life every single day to enable our customers to make the world healthier, cleaner, and safer. We provide our global teams with the resources needed to achieve individual career goals...

  • Pricing Analyst Iii

    2 months ago


    Ottawa, Canada Thermo Fisher Scientific Full time

    As part of the Thermo Fisher Scientific team, you will discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life every single day to enable our customers to make the world healthier, cleaner, and safer. We provide our global teams with the resources needed to achieve individual career goals...

  • Spatial Analyst

    2 weeks ago


    Ottawa, Canada Canadian Wildlife Federation Full time

    **Your Connection to Wildlife** - As one of Canada’s largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position _ **Spatial Analyst**: **Location**: CWF's Head Office in Ottawa, ON. **Reports to**: Spatial Ecologist **Fixed-Term **for 2-years **Who we are**: The Canadian Wildlife...

  • Spatial Analyst

    14 hours ago


    Ottawa, Canada Canadian Wildlife Federation Full time

    **_Your Connection to Wildlife_**: - As one of Canada’s largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position..._ **Spatial Analyst** **Location**: CWF's Head Office in Ottawa, ON. **Reports to**: Senior Spatial Ecologist **Fixed-term** for 1-year **Who we are** The Canadian...

  • Spatial Analyst

    2 months ago


    Ottawa, Canada Canadian Wildlife Federation Full time

    Your Connection to Wildlife As one of Canada's largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position... Spatial Analyst **Location**: CWF's Head Office in Ottawa, ON. **Reports to**: Senior Spatial Ecologist Fixed-term for 1-year Who we are The Canadian Wildlife Federation (CWF) is a...

  • Genome Analyst

    2 months ago


    Ottawa, Canada EORLA ALREO Full time

    **Position Overview** The Genome Analyst interprets genetic variants, submits data to relevant internal and external databases, and utilizes both practical and theoretical knowledge for the analysis of next-generation sequencing (NGS) and other laboratory data. The Analyst participates in education and teaching activities and other duties as required. Key...


  • Ottawa, Canada Compugen Inc Full time

    **Job Title** - Bilingual Data Analyst - Contract to Hire **Vacancy No** - VN5827 **Work Location** - Ottawa, ON **Job Details** - Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is to help organizations realize new...


  • Ottawa, Canada Canadian Medical Protective Association Full time

    **DATA INTEGRATION ANALYST** **CONTRIBUTING TO THE CMPA** **POSITION OVERVIEW** Reporting to the Senior Data Architect II, the Data Integration Analyst is responsible for developing and implementing ETL processing, reporting, integrations, and visualizations at all stages of Actuarial Services’ workflows and dataflows for source data used in actuarial...

  • Gis analyst

    1 week ago


    Ottawa, Canada Adecco Canada Full time

    Adecco is currently recruiting for a GIS Analyst for a 12-Month contract with a possibility of extension. The Crown Corporation Client is in the GTA, ON. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it. The GIS Analyst will have the following responsibilities: Runs geotargeting analysis leveraging tools;...


  • Ottawa, Canada Adecco Canada Full time

    Adecco is currently recruiting for a Financial Accounting Analyst for a permanent opportunity in Ottawa, ON with our Telecommunications client. This role will be hybrid ; 2 days at home and 3 days in the office. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it. Candidates outside of Ottawa may be eligible for...


  • Ottawa, Canada Adecco Canada Full time

    Adecco is currently recruiting for a Financial Accounting Analyst for a permanent opportunity in Ottawa, ON with our Telecommunications client. This role will be hybrid ; 2 days at home and 3 days in the office. The successful candidate must hold a valid Reliability Security Clearance or be eligible for it. Candidates outside of Ottawa may be eligible for...

  • QA Analyst

    1 day ago


    Ottawa, Canada Vision33 Full time

    **QA Analyst** **Full Time - Permanent** **Location: Open East Coast Canada** Vision33 is a global IT professional services consultancy that solves customer business challenges through the promise of technology and the value it delivers. We partner with growing and large organizations in both the public and private sectors to understand their vision and...