Business Intelligence Data Analyst

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