Senior Data Engineer I

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. The Senior Data Engineer designs, builds, integrates data from various resources and manages big data.

Roles and Responsibilities/ Essential Functions

• 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 underlying 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.
• Able 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.

Requirements Competencies

• 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.

Required Experience

• 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

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.)

Required Skills, Education and/or Certifications

• Bachelor’s degree in business or I.T. related discipline accepted or equivalent experience
• Equal Opportunity Employer - Including Disabled and Veterans