Dp Jobs in Iowa (NOW HIRING)

Job Summary:
Heartland Business Systems is seeking a Senior Data Engineer I to develop and deliver BI solutions. The role involves transforming data into a useful format for analysis, designing data infrastructure, and ensuring the smooth operation of data pipelines for effective reporting and analysis.
Responsibilities:
• 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.
Qualifications:
Required:
• 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
• Bachelor’s degree in business or I.T. related discipline accepted or equivalent experience
Preferred:
• 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.)
Company:
Heartland Business Systems is a single source for consulting, design, solutions. Founded in 1992, the company is headquartered in Little Chute, USA, with a team of 501-1000 employees. The company is currently Late Stage.