Position Summary:

Data Integration Engineer, Accounting & Finance Department BI Team Over the last three years, our company has seen rapid growth, and we are not done growing! With even more development anticipated over the next three to five years, we are adding to our team of dedicated and hardworking individuals. You will be part of a group that is responsible for designing, developing, deploying, and administering an SAP Business Intelligence analytics-reporting tool. We are the billion-dollar company you've never heard of. Heartland Dental proudly supports more than 1, dental offices supported across 39 states, over 20, team members and over 3, supported doctors in our support, Heartland Dental has a proven track record of growth and success. We’re looking for professional individuals who are open, positive and mentally flexible to join our network of support. We are hardworking, fun loving and fast growing - looking for our next perfect fit! Do you want to be part of building the success of Heartland Dental's next 20 years? To give you an idea of the team structure, you will work on a team of professionals dedicated to developing enterprise-wide data engineering solutions used to enhance day-to-day operations, reporting to our AF Manager of Enterprise Data Engineering & Integration. As a Data Integration Engineer, your duties and responsibilities will include:

Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources Optimize current data integration processes to provide optimal performance under increasing data volumes Develop and document the data audit, archiving, and restoration processes Develop data integration standards according to Heartland Dental’s information services policies as well as best practices Work closely with the Data Engineering team, Business Users, to provide data pipelines that enable business intelligence. Convert physical data integration models and other design specifications to source codes Perform daily monitoring of data loads into and out of various systems Troubleshoot and resolve issues as it relates to errors in daily data feeds Minimum Requirements: Must be in office three days a week. Bachelor’s Degree with a major in Computer Science, Information Systems, related field and/or relevant work experience Well versed in SQL, and SQL based stored procedures Experience with one or more programming languages such as Python, Java, Groovy, or Node.js Understanding of cloud computing platforms, security, tools, and methodologies such as GCP or Azure Experience with data integration tools and understanding of key ELT/ETL concepts Understanding of flow graphs, SQL procedures, job scheduling Strong analytical and problem-solving skills – ability to identify discrepancies, perform research therein, and work toward resolution Strong computer skills, including experience with Microsoft Word, Outlook, Excel, and PowerPoint Strong organizational and interpersonal skills Excellent verbal and written communication skills Must be able to effectively handle multiple deliverables simultaneously in a deadline driven environment Desirable Qualifications: Understanding of SAP BTP cloud platform and its key services Experience with Enterprise Data Integration Platforms such as Informatica or SAP Integration Suite Experience with Cloud Platforms such as Azure, AWS, or GCP Physical Requirements: Ability to perform essential duties satisfactorily with or without reasonable accommodation. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties of the position Prolonged periods sitting at a desk and working on a computer Must be able to lift up to 15 pounds at times