Are you interested in working for the nation's leading fire protection company and beginning a rewarding and satisfying career that helps save the lives of thousands each year? Do you want to be a part of a growing and expanding team of industry experts? If so, exploring career opportunities with Summit Companies may be right for you! This is an on-site position. JOB SUMMARY: The Data Integration Specialist will have a strong background in data integration, with experience in collecting, cleaning, transforming, and loading data from various external sources into internal systems. The Data Integration Specialist will play a crucial role in ensuring the accuracy, consistency, and reliability of our data. The primary focus of this position will be developing a long-term strategy for intake, processing, cleansing, and loading of acquisition data. ESSENTIAL JOB DUTIES: Data Integration: Manage and execute the integration of data from various external sources and acquisitions into internal source systems, ensuring seamless data flow and minimal disruption. Data Quality Assurance: Perform data quality checks to ensure that data being integrated is accurate, complete, and meets the company's standards before loading into internal systems. Data Mapping & Transformation: Work closely with data analysts and business stakeholders to understand data requirements and develop data mapping and transformation logic to meet those needs. Troubleshooting & Issue Resolution: Identify and troubleshoot data integration issues, ensuring timely resolution to maintain the integrity and reliability of data systems. Collaboration: Collaborate with data engineers, database administrators, and business units to ensure successful data integration that supports business objectives. Documentation: Create and maintain detailed documentation of data integration processes, data flows, and data mappings to support ongoing operations and future projects. Relationship building: Working with sellers to understand their source data and how it needs to be loaded, working with the sellers to fill-in the gaps Other duties may be assigned. QUALIFICATIONS The qualifications listed below are representative of the elements required to perform the job successfully, however in some cases, an equivalent combination of Education, Training, Certifications and Experience may meet the job qualifications. Education, Training, Certifications: High school Diploma, or equivalent, required. Bachelor's degree in Computer Science, Information Systems, or a related field, preferred. Experience, Knowledge, Skill Requirements: 7+ years of experience in data integration, data quality, SQL development, data mining or related roles, strongly preferred. Three or more years of experience working with data from a variety of different platform sources, preferred. Proficient in SQL and experience with data warehousing concepts, strongly preferred. Experience with data integration and ETL tools, preferably in an Azure environment, strongly preferred. Strong understanding of data mapping, transformation, and data quality practices. Experience with cloud platforms like AWS, or Google Cloud is a plus. Proven ability to collaborate with multidisciplinary teams of business analysts, developers, and subject-matter experts, including business partners who have little data knowledge. Excellent project management skills and strong ability to prioritize, preferred. Strong attention to detail and a commitment to data accuracy. Excellent problem-solving and troubleshooting abilities. Ability to work independently and as part of a collaborative team in a fast-paced, dynamic environment. Communication Skills: Must have the ability to effectively read, write and communicate in English with employees and customers. Systems and Software Skills: Strong proficiency in SQL and scripting languages such as Python or Java. Other Qualifications: Valid driver's license with acceptable driving record required. Must be able to comply with SFPH's Drug and Alcohol policy and Background screening requirements, which may also include customer specific requirements based on contractual agreement. Occasional travel required, up to 10%. PHYSICAL & WORK ENVIRONMENT REQUIREMENTS Reasonable accommodations may be made to enable individuals with disabilities to perform Essential Job Duties. Physical Requirements: While performing the duties of this job, the employee is required to sit for long periods. Employee will occasionally be required to bend, kneel, balance, lift <20lb, walk, stand, ascend/descend stairs, drive, twist, and reach above and below shoulders. Work Environment: Employee will consistently be required to work indoors in an office setting, work alone and with others. Office settings are mild to moderate temperatures. Summit Companies, through its subsidiaries, is a full-service provider for fire detection, suppression, and security with a full suite of capabilities that includes design, installation, testing, inspections, and maintenance. We serve customers across many verticals on a local, regional, and national scale. We're proud of our well-deserved reputation for quality work that's completed by our talented and experienced installation workforce. Summit Companies is a dynamic organization with endless growth opportunities spanning over 100 locations in more than 30 states. Our company is consistently recognized for service excellence in the fire protection industry. Summit Companies supports trade skills and workforce development by hosting Recognized Apprenticeships and on-the-job training (OJT) programs for new career-seekers. Many members of our leadership team serve as chair on NFPA code compliance committees, serve on regional safety boards, and support technical education in local schools. Summit Companies supports employees in their professional development by offering continued development, training, and education by encouraging NICET and other career-advancing certifications. We continually strive to be the Employer of Choice for highly motivated team members who want to succeed in a high-growth environment. We encourage initiative, independence, diversity, and personal career growth. The combination of experience, knowledge, and customer service is the key to our performance and helps us achieve our goal of providing the highest quality of fire protection services to protect lives and property. Benefits Summit Companies offers extensive training opportunities, career advancement, competitive pay, bonus opportunities, along with an industry leading and affordable benefits package for eligible employees. Our benefits package includes: Paid Vacation and Holidays Medical Insurance Dental Insurance Vision Insurance 401(k) Plan with Company Match Flexible Spending Accounts Long-Term Disability - Employer Paid Short-Term Disability - Employer Paid Additional Voluntary Ancillary Benefits such as Accident and Hospital Indemnity Life Insurance for Team Members and Dependents Employee Assistance... For full info follow application link. We are an Equal Opportunity and Affirmative Action Employer and comply with all applicable federal, state, and local fair employment practices laws. All qualified applications will receive consideration of employment without regard to race, color, religion, creed, national origin or ancestry, ethnicity, sex (including pregnancy), sexual orientation, gender (including gender nonconformity and status as a transgender or transsexual individual), age, physical or mental disability, citizenship, past, current, or prospective service in the uniformed services, genetic information, marital status, status with regard to public assistance, membership or activity in a local commission, familial status, or any other characteristic protected by federal, state or local laws.