Job Type

Full-time
Description
Position Summary:
This position requires a candidate with a strong technical background in developing and delivering BI solutions along with a strong understanding of SQL Server environments. Business intelligence (BI) is a set of technologies and practices for transforming business information into actionable reports and visualizations.
A Senior Data Warehouse Engineer is the data professional who assists with the design of, and prepares, the data infrastructure to be leveraged by the HBS BI Data Developers. This individual will design, build, and integrate data from various resources. In addition, this individual ensures the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access. The work involves tuning databases for fast analysis and creating table schemas.
The Senior Data Warehouse Engineer is responsible for making data easily accessible, ensuring the process works smoothly and is optimized. This individual is a critical firm member of the Data Team. This role will run Extract, Transform and Load (ETL) on top of datasets and create data that is warehoused to be used for reporting and analysis.
Roles and Responsibilities/ Essential Functions:

• Meet with internal customers to understand current business processes and business needs to provide data driven solutions.
• Support and administer the underlining infrastructure and layout of HBS's data environment including continued architecture and maintenance of warehouse solution.
• Optimize the data collection process.
• Develop policies and procedures for the collection and analysis of data.
• Review data sources to ensure integrity of the data and recommend/implement data integrity solutions.
• Collaborate with the internal data team to ensure the requirements are being met to build the right solution to solve the right problem.
• Estimate development effort required to deliver data needs and requests.
• Manage and build system and data integration through API's.
• Use business analysis skillset to identify development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability.
• Work as part of the operations team to continue to grow and mature data services and delivery options for HBS.
• Based on experience, one may mentor other engineers in developing scalable, secure, high-performance BI and Data solutions.

Requirements
Competencies:

• Accuracy - Able to produce high quality work deliverables leveraging industry best practices.
• Analytical Skills - Effectively interprets business needs and translates them into application and operational requirements, resolving complex technical and business problems.
• Communication - Strong written, verbal, and non-verbal communication skills, especially conveying complex information in an understandable manner.
• Leadership - Motivates and guides others to ensure performance is in accordance with clear expectations and goals.
• Learning - Quickly learns new technologies / processes required to deliver advanced solutions.
• Presentation Skills - Effectively conducts formal and informal presentations in both small and large group settings at all levels of a company.
• Project Management - Understands process (re-)engineering, planning, organizing, staffing, directing, and controlling work tasks.
• Time Management - Effectively prioritizes and utilizes available time for managing multiple tasks/projects simultaneously.

Required Experience:

• Minimum of 6 years progressive experience delivering data solutions.
• Experience with needs analysis, software evaluation and selection, customization, and implementation.
• Data Warehousing systems and architecture experience in 'real world', practical, successful implementations.
• Understand multi-dimensional database structures and schemas.
• Strong knowledge of system design, development, and deployment.
• Microsoft BI Suite Experience:
• Microsoft Excel
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft SQL Server Reporting Services (SSRS)
• Microsoft SQL Server Analysis Services (SSAS)
• Programming and Processing Experience:
• T-SQL
• ETL
• Azure Experience:
• Azure SQL Database
• Azure SQL Manage Instance
• Azure Architecture
• Azure Data Factory
• Strong knowledge of SQL utilizing MS SQL Server

Preferred Experience:

• SWE or equivalent experience in prior role.
• Experience using and building API's
• Reverse ETL
• Python
• SMART Connect
• Experience in a Technology Service Provider business model.
• PowerShell knowledge and understanding
• Understanding of report writing and visualization
• Microsoft BI Suite Experience
• Microsoft Power BI
• Microsoft certified: Data Analyst Associate
• Microsoft certified: DP-200 - Implementing an Azure Data Solution
• Microsoft certified: DP-201 - Designing an Azure Data Solution
• Microsoft certified: DP-300 - Administering Relational Databases on Microsoft Azure

Required Skills, Education and/ or Certifications:

• Bachelor's degree in business or IT related discipline

Equal Opportunity Employer - Including Disabled and Veterans
#HBS