Transform data into a useful format for analysis and focus on design and architecture.
Prepare the data infrastructure for BI Data Developers.
Design, build, integrate data from various resources and manage big data.
Ensure the operations of the data pipeline follow a consistent process of Ingestion, Processing, Storage and Access.
Tune databases for fast analysis and create table schemas.
Make data easily accessible, ensuring smooth and optimized processes.
Run Extract, Transform and Load (ETL) on datasets and create data warehouses for reporting and analysis.
Meet with clients to understand their current business processes and provide consulting services on how to build or grow data strategy.
Work with HBS Sales Solutions consultants to identify and grow opportunities within HBS client environments.
Support and administer the underlying infrastructure of a client data environment.
Develop and design the customer data collection process.
Develop policies and procedures for collection and analysis of data.
Collaborate with BI Data Developers to ensure requirements are met for the right solution.

7+ years of experience in technology related role
Data Model Design (Physical or Conceptual or both)
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/relational database structures and schemas.
Strong knowledge of system design, development, and deployment
Microsoft BI Suite Experience (Excel, Microsoft SQL Server Integration Services (SSIS), Azure Data Factory (ADF), etc.)
Programming and Processing Experience (T-SQL, ETL, etc.)
Azure Experience in Azure SQL Database or Azure SQL Managed Instance
Strong knowledge of SQL utilizing MS SQL Server
Expertise in Professional Services or similar client facing roles
Preferred Experience: Experience in multiple industry (Education, Healthcare, Retail, Manufacturing) verticals.
PowerShell knowledge and understanding.
Understanding of report writing and visualization.
GitHub Copilot experience.
Microsoft BI Suite Experience (Power BI or Fabric)
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.
Other SQL platform knowledge (Oracle, MySQL, PostgreSQL, etc.)
Bachelor’s degree in business or I.T. related discipline accepted or equivalent experience.

Senior Data Engineer

Key skills