Senior Data Engineer I

Heartland Business Systems; Springfield (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

Heartland Business Systems is looking for a Senior Data Engineer in Springfield, Missouri, to develop and deliver business intelligence solutions. Responsibilities include consulting with clients on data strategies and collaborating with the sales team to grow opportunities. The ideal candidate will have over 7 years of experience in technology, knowledge of SQL Server, and Microsoft BI tools. A Bachelor's degree or equivalent experience is required. This is a full-time position focusing on transforming data into actionable insights.

Qualifications

• 7+ years of experience in a technology-related role.
• Experience in Data Model Design, Data Warehousing systems, and architecture.
• Strong knowledge of SQL utilizing MS SQL Server.

Responsibilities

• Meet with clients to understand business processes and provide consulting.
• Work with sales to identify and grow opportunities within client environments.
• Develop policies for the collection and analysis of data.

Skills

Analytical Skills

Communication

Time Management

Project Management

Leadership

Education

Bachelor's degree in business or I.T. related discipline or equivalent experience

Tools

Microsoft SQL Server Integration Services (SSIS)

Azure Data Factory (ADF)

Power BI

T-SQL

Job description

Position Summary

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.

Job Type: Full-time

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

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

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