Business Intelligence Data Analyst

6 days 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

  • Data Analyst

    7 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...

  • Business Intelligence

    4 weeks ago

    Ottawa, Canada belairdirect Full time

    About the roleFrom coast-to-coast, our inspiring colleagues are at the heart of what we do best: helping people, businesses and society prosper in good times and be resilient in bad times. With our team, you’ll bring this purpose to life every day by living our Values, being open to change, and pursuing your goals.At belairdirect, we’ll give you...

  • Business Analyst

    7 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a **Business Analyst (Bilingual) **to join our team **REMOTE** in the** Canada (EST work hours).** - Lead and conduct business analysis to assess client's business problems/opportunities and documents the business requirements in such a way that technology solutions can be determined. - Assist with the development of strategies and...

  • Business Analyst

    24 hours ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Business Analyst to join our team in Ottawa, Ontario (CA-ON), Canada (CA). **How You'll Help Us**: As a Business Analyst, you will use your wide array of knowledge to provide support to our clients. If you are passionate about business analysis, technology and are solution driven, you will be a great fit for our team.In this...

  • Business Intelligence Analyst

    7 months ago

    Ottawa, Canada NSERC Full time

    A written examination and an interview will be administered. If you are looking for a dynamic and challenging work environment with a fun, diverse and dedicated team, the Social Sciences and Humanities Research Council (SSHRC) and Natural Science and Engineering Research Council’s (NSERC) is the place for you! We are growing our team and looking for...

  • Competitive Intelligence Analyst

    5 days ago

    Ottawa, Canada Versaterm Full time

    **The Company** Versaterm is a global public safety solutions company helping agencies transform how they serve their communities. Since 1977, we've been building an ecosystem of intuitive tools designed for public safety agencies, forensic labs, court systems, schools and other institutions. Through purposeful integrations and a selective growth strategy,...

  • Media Intelligence Analyst, Data + Analytics

    6 months ago

    Ottawa, Canada H+K Canada Full time

    Hill+Knowlton Strategies is seeking a Media Intelligence Analyst to join our Data + Analytics team in Canada. This entry-level role represents a unique opportunity to grow your analytics skills by working with a diverse base of influential clients within a dynamic global organization. Although this role is focused on media intelligence, you will have the...

  • Manager, Business Intelligence and Visualization

    2 months ago

    Ottawa, Canada NAV Canada Full time

    Job Posting Title Manager, Business Intelligence and Visualization Center of Excellence Job Category Business Intelligence Language Requirements English / Anglais Flexible Work Agreement Type Hybrid / Hybride Posting End Date 2024-11-13 Job Grade L1 Zone B Pay Range Commensurate with Experience / Selon l’expérience Job Summary The Manager,...

  • Technical Business Intelligence Solutions Specialist

    2 days ago

    Ottawa, Canada S.i. Systems Full time

    S.i. Systems, a leading provider of business solutions, is seeking a highly skilled Senior ERP Technical Analyst to join its team.About the RoleWe are building a team of 4 resources to work on an as-and-when-needed basis to support the design, implementation and operation of a Business Intelligence and Analytics solution that integrates data from complex...

  • Financial Data Analyst

    3 months ago

    Ottawa, Canada NSERC Full time

    **Selection Process Number**: - 7265879-C**Location of Position**: - Ottawa, ON**Job Status**: - Indeterminate appointment**Job Category**: - Accounting/Finance**Directorate**: - Common Administrative Services (CASD)**Division**: - Finance and Awards Administration**Number of Positions Being Staffed**: - 1**Classification**: - GR-07**Security...

  • Data Analyst

    6 months ago

    Ottawa, Canada World Vision Canada Full time

    Are you looking for more than a job? At World Vision Canada we offer challenging careers that change the lives of children all over the world and it will change yours too. Come and be part of a team of 400 Canadians with a vision for the world: Life in all its fullness for every child. You will experience Christian faith in action helping to make real and...

  • Analyst, Open Source Intelligence

    6 days ago

    Ottawa, Canada House of Commons Full time

    **Language Profile** Bilingual Imperative (English / French) - Reading comprehension: Advanced Level (C) - Written expression: Intermediate Level (B) - Oral interaction: Advanced level (C) **Your Challenge** If you dream of joining an organization that is small enough to be noticed and big enough to provide a meaningful career, we want to hear from...

  • Bilingual Business Analyst

    2 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a **Senior Business Analyst **to join our team **Remote** based anywhere in **Canada.** - Develop and update Government of Canada Infrastructure Project and GCdocs operational processes for the creation, storage, access, management, sharing and transmission of information. - Update the current Concept of Operations (CONOPS) for the...

  • Bilingual Business Analyst

    2 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a **Senior Business Analyst **to join our team **Remote** based anywhere in **Canada.** - Develop and update Government of Canada Infrastructure Project and GCdocs operational processes for the creation, storage, access, management, sharing and transmission of information. - Update the current Concept of Operations for the Government...

  • Business System Analyst

    7 months ago

    Ottawa, Canada Bank of Canada Full time

    **Business System Analyst** **Take a central role** The Bank of Canada has a vision to be a leading central bank—dynamic, engaged and trusted—committed to a better Canada. No other employer in the country offers you the unique opportunity to work at the very center of Canada’s economy, in an organization with significant impact on the economic and...

  • Systems Analyst

    7 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Systems Analyst to join our team in Canada. Location: Remote Language: Bilingual (English/French) Security: Reliability **How You'll Help Us**: We are looking for a Systems Analyst with 5 years experience. You will work collaboratively with stakeholders to identify improvements and design systems to implement those and...

  • Data Analyst Ii

    7 months ago

    Ottawa, Canada Fullscript Full time

    Fullscript is making optimal care easy for everyone. Through our care delivery platform, health practitioners can seamlessly design personalized health plans, provide support and education tools, and effortlessly prescribe and manage the use of healthcare's best supplements — all in one place. Since 2011, Fullscript has enabled over 90,000 practitioners...

  • Business Data Analyst

    23 hours ago

    Ottawa, Canada BuzzClan LLC Full time

    Perform functional analysis of the client’s business processes. - Identify process improvements and facilitate reengineering of business processes that align with Sagitec product solutions. - Participate in data migration to SQL Server. - Analyze data and data models in collaboration with developers. - Participate in database design with the technical team...

  • Business Analyst or Senior Business Analyst

    1 week ago

    Ottawa, Canada Export Development Canada Full time

    p>Description - Senior Business Analyst, Business Analyst Chapter (perm and contract/temporary assignment) (0004Y9) Job Type: Permanent Schedule: Full-time Export Development Canada (EDC) is a financial Crown corporation dedicated to helping Canadian businesses make an impact at home and abroad. EDC offers financial products and knowledge to help Canadian...

  • Business Intelligence Lead

    6 months ago

    Ottawa, Canada Home and Community Care Support Services South East Full time

    Company Bio Home and Community Care Support Services South East is one of 14 Home and Community Care Support Services organizations in Ontario with a focused mandate to deliver local health care services such as home and community care and long-term care home placement. These organizations were previously known as Local Health Integration Networks (or...