Current jobs related to Business Intelligence Data Analyst - Ottawa - eSentire

  • Business Intelligence Data Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    Business Intelligence Analyst Job DescriptionAngular Directions is partnering with a unique Canadian company to find a skilled Business Intelligence Analyst to drive their operation in Ottawa. This company is dedicated to optimizing e-commerce, managing risk, and analyzing data, and we're excited to help them find the ideal candidate with strong foundations...

  • Business Intelligence Data Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    Business Intelligence Analyst Job DescriptionAngular Directions is partnering with a unique Canadian company to find a skilled Business Intelligence Analyst to drive their operation in Ottawa. This company is dedicated to optimizing e-commerce, managing risk, and analyzing data, and we're excited to help them find the ideal candidate with strong foundations...

  • Business Intelligence Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Angular Directions. As a key member of our team, you will be responsible for driving business growth through data-driven insights.Key ResponsibilitiesDevelop and maintain business intelligence solutions to support data-driven decision makingCollaborate with...

  • Business Intelligence Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Angular Directions. As a key member of our team, you will be responsible for driving business growth through data-driven insights.Key ResponsibilitiesDevelop and maintain business intelligence solutions to support data-driven decision makingCollaborate with...

  • Business Intelligence SQL Data Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Angular Directions. As a Business Intelligence Analyst, you will play a crucial role in driving business intelligence initiatives forward and helping our clients make data-driven decisions.Key ResponsibilitiesDevelop and maintain complex SQL queries to extract and...

  • Business Intelligence SQL Data Analyst

    2 weeks ago

    Ottawa, Ontario, Canada Angular Directions Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at Angular Directions. As a Business Intelligence Analyst, you will play a crucial role in driving business intelligence initiatives forward and helping our clients make data-driven decisions.Key ResponsibilitiesDevelop and maintain complex SQL queries to extract and...

  • Business Intelligence Analyst

    8 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    5 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    5 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a key member of our data analytics team, you will be responsible for developing and maintaining business intelligence solutions to support our reliability program.Key Responsibilities:Design and develop complex data...

  • Business Intelligence Analyst

    2 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a key member of our data analytics team, you will be responsible for developing and maintaining business intelligence solutions to support our reliability program.Key Responsibilities:Design and develop complex data...

  • Business Intelligence Analyst

    10 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

  • Business Intelligence Analyst

    6 hours ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Intelligence AnalystWe are seeking a highly skilled Business Intelligence Analyst to join our team at Electricity Canada. As a Business Intelligence Analyst, you will play a key role in developing and maintaining our data analytics capabilities, ensuring that our members have access to accurate and reliable data to inform their business...

Business Intelligence Data Analyst

3 months ago

Ottawa, Canada eSentire Full time

About eSentire

eSentire is on a mission to hunt, investigate and stop cyber threats before they become business disrupting events. We were founded from the premise that if you can't find a solution, you build it. Entrepreneurship and innovation are in our DNA. Our culture is based on transparency, candor, and resiliency. At eSentire, continuous improvement isn't an option. It's expected.

Join our team and build your cybersecurity career in one of the world's most dynamic industries.

The incumbent will keep up to date with the rapid advancements being made in BI systems and will help both the BOAR team and business users understand how the new technologies can be applied to move the company forward in planning and monitoring goals and objectives.

**Responsibilities**:
Project Leadership and Support
- Supports the development and maintenance of data warehouses and creates new or expanded data stores to support new requirements.
- Supports multifunctional teams to ensure data warehouse projects are aligned with other BOAR projects and meet user requirements.
- Resolves issues related to service requests or production problems.
- Collaborates with business users to understand and collect business requirements.

Planning and Analysis
- Supports projects to develop new data sources, new data feeds, new data stores and new tools for end users.
- Follows and is compliant with company policies and security/privacy procedures.
- Prepares or assists with feasibility studies, requirements definitions, conceptual design documents, work plans, systems design, implementation designs, system and program specifications, and system and client documentation.
- Defines testing requirements.
- Troubleshoots, researches and has a deep understanding of sources of data and production systems.
- Develops and manages implementation of data/code fixes for defects utilizing the Application Lifecycle Management (ALM) process.
- Monitors data warehouses load performance and data quality on a regular basis or for month-end and works with Business Systems team to improve both performance and quality.
- Consults with managers in requesting business units to determine project timelines, and where necessary, develops project plans to complete data warehouse requests.

Design, Development and Administration
- Extract, Transfer Load (ETL): Design end to end processes to extract, transfer and load data from CRM, ERP, HCM systems and other sources into the Data Warehouse.
- Co-ordinate the design and develop efficient workflow processes to automate ETL events
- Fine tuning and performance enhancement throughout all ETL processes through data cleansing recommendations, coding and redesigning of data models
- Develops SQL queries, shell scripts, SQL stored procedures, and reports, using customer requirements and documents, in accordance with established criteria and standards.
- Designs, integrates, tests, maintains, and supports automated reports delivered through Power BI or other technologies, as required.
- Designs and executes the moving of data from one environment to another by using Imports or SQL queries.
- Prepares operational documentation for the system users and support teams according to established departmental and divisional standards.
- Contributes to team effort by completing assigned tasks and supporting other team members.
- Creates program design specifications in accordance with established criteria and standards

**Requirements**:
Qualifications/Experience
- Minimum four (4) year Degree in Computer Science, Data Science or a related field
- Minimum three (3) years in Data Warehouse Design and Architecture, including extensive experience designing, implementing and supporting data model and data warehouse projects.
- Experience with designing and supporting the 3 database functions of the ETL
- Strong understanding of the CRM, ERP, and HCM products and the flow of information in context of data warehousing
- Strong understanding of MS SQL Server and SQL programming
- Data Warehouse Design or similar certification a plus

**Demonstrated experience in**:

- Relational Database Management System (RDBMS).
- A business analyst and/or systems analyst in IT role together with experience in managing customer relationships and project coordination/project management.
- Technology process mapping, business process mapping and workflow.
- Executing quality assurance best practice and procedures for information systems and services.
- SQL programming
- Extract-Transform-Load Tools and Techniques (Boomi or similar)
- MS Azure/other Cloud platforms
- Shell scripting familiarity

**Additional assets**:

- Knowledge of Oracle database architecture
- Advanced Shell Scripting abilities, Python proficiency
- Collaboration and facilitation skills to consult with diverse stakeholders and facilitate discussions among stakeholders with different interests
- Strong judgement, organizational skills and ability to be flexible/adaptable
- Excellent