Data Integration Specialist

Micrologic is looking for a skilled Data Integration Specialist to handle the technical aspects of importing, transforming, and validating data from various sources into our systems. This role focuses on data accuracy, integrity, and system compatibility, with a strong emphasis on SQL, Excel, and data transformation processes., * Import, cleanse, and transform data from multiple vendor sources (e.g., DRB, ICS, Washify) while performing data manipulation to ensure consistency, accuracy, and compliance within target systems.

• Develop and execute SQL queries to validate, analyze, and manage data effectively.
• Analyze datasets to identify anomalies, duplicates, and missing information, implementing corrective measures to ensure data accuracy and integrity.
• Identify and resolve database issues, including inconsistencies, missing records, and duplicates.
• Conduct rigorous data quality checks to verify completeness and accuracy of integrated data.
• Collaborate with technical teams and client success teams to ensure smooth integration and alignment with system requirements.
• Maintain documentation of data integration processes, mappings, and transformation rules.
• Generate reports summarizing integration results, data quality metrics, and any issues encountered.

• Bachelor’s degree in Business Administration, Operations Management, or a related field
• 3+ years hands-on experience with data integration, data transformation, or ETL processes.
• Advanced proficiency in Excel, including formulas, pivot tables, and data analysis.
• Strong SQL skills for querying, analyzing, and manipulating complex datasets.
• Experience working with multiple vendor data formats or systems.
• Exceptional attention to detail, analytical skills, and problem-solving ability.

COMPUTER SKILLS REQUIRED:

• Proficiency with Microsoft Office Suite
• Strong Excel skills (pivot tables, VLOOKUP, charts, formulas) for data analysis and reporting
• ETL/Data Integration
• Ability to quickly learn and adapt to new business software platforms, * Data Integration: 3 years (Required)
• Data Transformation: 3 years (Required)
• ETL: 3 years (Required)
• Microsoft Excel: 3 years (Required)
• Formulas, Pivot Tables, VLOOKUPS, Charts, Formulas, etc.: 3 years (Required)
• SQL: 3 years (Required)

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Micrologic Associates is a leading technology solutions provider for the car wash and related industries. We build the systems our customers run their businesses on, empowering them to grow more profitable washes through smarter products, dependable service, and a team that has their back. Our product suite includes all the software needed to run and grow a wash, along with the related hardware and support services that keep it all running.