Temporary, Full-Time Business Intelligence Data Analyst Position - One Year Contract

eSentire; Waterloo; Hybrid; CAD 70,000 - 95,000; Full time

Job summary

eSentire seeks a Business Intelligence Data Analyst to enhance data management and analytics functionality. The role involves collecting and transforming data, ensuring the reliability of data warehouses, and developing reporting capabilities to meet business objectives in a hybrid work environment.

Benefits

Comprehensive health benefits

Flexible vacation plan

Company equity program

Qualifications

• Minimum 4 years degree in a related field.
• 3+ years in Data Warehouse Design and Architecture.
• Experience with ETL processes and SQL programming.

Responsibilities

• Support development and maintenance of data warehouses.
• Design ETL processes for data from various systems.
• Collaborate with teams to define and document requirements.

Skills

Data Warehouse Design

SQL Programming

ETL Processes

Collaboration Skills

Analytical Skills

Education

Degree in Computer Science

Data Science Degree

Tools

MS SQL Server

Power BI

ETL Tools (Boomi or similar)

Azure

Job description

About eSentire

eSentire is on a mission to hunt, investigate and stop cyber threats before they become business disrupting events. We were founded on 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, teamwork, and continuous innovation.

As the authority in Managed Detection and Response, we protect the critical data and applications of 2000+ organizations in 80+ countries, across 35 industries from known and unknown cyber threats.

As Business Intelligence Data Analyst, you are required to perform the following duties and undertake the following responsibilities in a professional and satisfactory manner.

Reporting to the Manager, Business Intelligence, the Business Intelligence Data Analyst will work with clients across eSentire to analyze, plan, organize, and optimize our analytical databases and applications. They will work to improve the Business Operations Analytics and Reporting (BOAR) team’s utilization of data to help the company meet business goals and objectives. The Analyst will gather those requirements and engage in expanding the data warehouse and its capabilities by extending and/or improving the data warehouse architecture and other external data sources. The primary focus is to maintain, enhance, and administer the ETL (Extract, Transform, Load) processes.

The successful candidate will be experienced in all aspects of BI starting with the collection and transformation of detailed data elements, through to helping users access and use the information in the data warehouse. The BI Data Analyst will assist BI Analysts in developing the presentation layer(s) and providing specialized reporting views. In addition, the successful candidate will provide support to data analytics clients by providing features/data elements for advanced analysis such as forecasting and predictions.

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. Accurate documentation and communication of these requirements.
  • Manages and tracks project work and timelines in tools like Jira, DevOps.
• Planning and Analysis
  • Supports projects to develop new data sources, new data feeds, new data stores and new tools for end users.
  • Experience in leveraging AI to increase efficiency and quality of recurring processes and project work.
  • Analyzes current reporting applications and/or data warehouses through review of documentation and interviews with clients.
  • 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.
  • Manage architecture, applications, systems and reporting services.
  • Co-ordinate the design and develop efficient workflow processes to automate ETL events.
  • Identifying, troubleshooting and reporting application performance and outages.
  • 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
  • Provide the quality assurance on promoting applications and services received from program analysts through development environment and test to production server application according to company approved promotion policies, procedures and change management routines.

Requirements:

• 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 verbal and written communication skills

If the successful candidate lives within 50 km of our office in Waterloo, Ontario this will be a hybrid position (Monday and Friday – work from home, Tuesday, Wednesday and Thursday – work onsite). If the successful candidate lives more than 50 km from our office in Waterloo this will be a remote position.

Our Culture and Values

At eSentire we work in a collaborative and innovative work environment. We work with brilliant and passionate people who strive and encourage others to do their best. eSentire’s idea-rich environment welcomes creative and sometimes unconventional perspectives!

We celebrate diversity, operating with mutual respect and consideration, in an environment that fosters inclusivity for all. We believe that a variety of perspectives, backgrounds, and experiences make us stronger – if you’re enthusiastic about this opportunity but don’t meet every qualification, we encourage you to apply anyway. It takes a diverse set of thoughts, cultures, backgrounds, and perspectives to be a true market leader.

Total Rewards

We believe in rewarding performance and providing comprehensive benefits tailored to support your well-being. Our package includes comprehensive health benefits, a flexible vacation plan, and participation in our company-wide equity program, allowing you to share in the success and growth of our organization.

Accommodation

If you have any accessibility requirements during the recruitment process, please reach out to our HR team at [e-mail] and any accommodation needs will be addressed upon request.Your talents and unique perspectives are valued, and we look forward to the opportunity to work together to build a more inclusive future.

It's our mission at eSentire to protect our customers 24/7/365 and we extend this conviction to job seekers. During the application and interview process, eSentire will communicate with you from one of our corporate "@esentire.com" email addresses, never from a public email address. We strive to provide a welcoming, respectful, and thorough interview process, providing the candidate with ample opportunity to spend time with the hiring manager, recruiter, and future colleagues face to face, or using a video conference technology.

#LI-VM1
#LI-Hybrid