Work In Tech

About eSentire

eSentire, Inc. is the Authority in Managed Detection and Response, protecting the critical data and applications of 2000+ organizations in 80+ countries, across 35 industries from known and unknown cyber threats.

Founded in 2001, the company’s mission is to hunt, investigate and stop cyber threats before they become business-disrupting events. Combining cutting-edge machine learning XDR technology, 24/7 Threat Hunting, and proven security operations leadership, eSentire mitigates business risk and enables security at scale.

The Team eSentire difference means enterprises are protected by the best in the business with a named Cyber Risk Advisor, 24/7 access to SOC Cyber Analysts, Elite Threat Hunters, and industry-leading threat intelligence research from eSentire’s Threat Response Unit (TRU). eSentire provides Managed Risk, Managed Detection and Response and Incident Response services.

The Role

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.

Planning and Analysis

• Supports projects to develop new data sources, new data feeds, new data stores and new tools for end users.
• 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