Senior Data Engineer I

Description

This position would require a candidate to possess 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. The Senior Data Engineer transforms data into a useful format for analysis and is focused on the design and architecture.

• → Meet with clients to understand their current business processes and needs to provide consulting services and direction on how to build or grow their current data strategy.
• → Work with HBS Sales Solutions consultants to identify and grow opportunities within HBS client environments.
• → Support and administer the underlining infrastructure and layout of a client data environment.
• → Develop and design the process for the customer data collection process.
• → Develop policies and procedures for the collection and analysis of data.
• → Review customer sources to ensure integrity of the data collection process.
• → Collaborate with the BI Data Developers to ensure the requirements are being met to build the right solution needed.
• → Estimate development effort required to deliver data customer needs and requests.
• → Use business analysis skillset to identify development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability.
• → Ability to work independently or as a team on project-based solutions for clients.
• → Work with team mates to continue to grow and mature data services and delivery options for HBS clients.
• → Based on experience, one may mentor other engineers in developing scalable, secure, high-performance BI and Data solutions.
• → Meet annual billable hour goal, as defined by HBS. This number may change over time as the business evolves. 

•  Accuracy – Ability to produce high quality work deliverables leveraging industry best practices.
•  Analytical Skills - Strong abilities required to effectively interpret customer business needs and translate 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 – Ability to motivate and guide others to ensure performance is in accordance with clear expectations and goals.
•  Learning – Ability to quickly learn new technologies to deliver solutions.
•  Presentation Skills – Ability to effectively conduct formal and informal presentations in both small and large group settings within all levels of a company.
•  Project Management – Ability to demonstrate an understanding of process engineering, planning, organizing, staffing, directing, and controlling work tasks.
•  Time Management – Ability to effectively utilize available time for managing multiple tasks/projects simultaneously.

• 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 Manage Instance
• Strong knowledge of SQL utilizing MS SQL Server
• Expertise in Professional Services or similar client facing roles

• 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

Equal Opportunity Employer - Including Disabled and Veterans

#HBS