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 experienceWell versed in SQL, and SQL based stored proceduresExperience with one or more programming languages such as Python, Java, Groovy, or Node.jsUnderstanding of cloud computing platforms, security, tools, and methodologies such as GCP or AzureExperience with data integration tools and understanding of key ELT / ETL conceptsUnderstanding of flow graphs, SQL procedures, job schedulingStrong analytical and problem-solving skills – ability to identify discrepancies, perform research therein, and work toward resolutionStrong computer skills, including experience with Microsoft Word, Outlook, Excel, and PowerPointStrong organizational and interpersonal skillsExcellent verbal and written communication skillsMust be able to effectively handle multiple deliverables simultaneously in a deadline driven environmentDesirable Qualifications :
Understanding of SAP BTP cloud platform and its key servicesExperience with Enterprise Data Integration Platforms such as Informatica or SAP Integration SuiteExperience with Cloud Platforms such as Azure, AWS, or GCPPhysical 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 positionProlonged periods sitting at a desk and working on a computerMust be able to lift up to 15 pounds at times