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 solid 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 building or growing their 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's data environment.
• Develop and design the process for customer data collection.
• Develop policies and procedures for the collection and analysis of data.
• Review customer sources to ensure the integrity of the data collection process.
• Collaborate with the BI Data Developers to ensure the requirements are being met to build the right solution.
• Estimate development effort required to deliver data customer needs and requests.
• Use business analysis skills to identify development needs for streamlining and improving operations.
• Able to work independently or as part of a team on project-based solutions for clients.
• Collaborate with team members 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.

Competencies

• Accuracy – Ability to produce high-quality work deliverables leveraging industry best practices.
• Analytical Skills – Strong abilities to 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 in conveying complex information in an understandable manner.
• Leadership – Ability to motivate and guide others to ensure performance aligns with clear expectations and goals.
• Learning – Ability to quickly learn new technologies to deliver solutions.
• Presentation Skills – Ability to conduct formal and informal presentations in both small and large group settings within all levels of a company.
• Project Management – Ability to demonstrate 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 roles.
• 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 industries (Education, Healthcare, Retail, Manufacturing).
• 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 IT-related discipline accepted or equivalent experience.