> Markdown version of [/jobs/ext/3428540-data-integration-lead](https://www.wearedevelopers.com/jobs/ext/3428540-data-integration-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Integration Lead - **Company:** Micrologic Associates, LLC - **Location:** Parsippany-Troy Hills, NJ, United States - **Experience:** Expert - **Salary:** $80,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Amazon Web Services, Data Analysis, Databases, Data Cleansing, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Visualization, Excel Formulas, Python (Programming Language), Software Requirements Analysis, SQL Databases, Systems Integration, Technical Data Management Systems, Data Import/Export, Information Technology - **Published:** September 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6b63efcc835c55d5 ## About the Role * Three or more years of experience with Python, SQL, and data visualization/exploration tools * Familiarity with the AWS ecosystem, specifically Redshift and RDS Communication skills, especially for explaining technical concepts to nontechnical business leaders * Ability to work on a dynamic, research-oriented team that has concurrent projects Preferred skills and qualifications * Bachelor's degree (or equivalent) in computer science, information technology, engineering, or related discipline * Experience in building or maintaining ETL processes * Experience with complex data migrations, integrations, or customer conversions * Professional certification in a relevant technical field * Experience troubleshooting data quality and database issues ## Description Data Import Process Management: * Initiate the data import process by coordinating with relevant parties, including account managers, vendors, and internal development teams. * Establish timelines and lead times for each party involved in the data import process. Communicate effectively with customers to obtain necessary data in the required format. Review and validate data templates provided by customers, ensuring all mandatory fields are accurately filled out. Template Management: * Manage data templates for various vendors, including DRB, ICS, Washify, and others. * Ensure all mandatory fields are included in the templates and provide guidance to customers for completion if needed. Technical Data Analysis: * Conduct pre-data analysis using advanced Excel functions to identify anomalies, duplicates, and missing data. * Utilize Excel extensively for data cleansing, manipulation, and transformation to meet system requirements. Database Management and SQL Usage: * Utilize SQL queries to analyze and manipulate data during the import process. * Identify and resolve database issues related to data import, including duplicate records and missing information. * Collaborate with the development team to ensure data integrity and system compatibility. Quality Assurance: * Perform quality checks on imported data to ensure accuracy and completeness. * Address any discrepancies or errors identified during the import process in a timely manner. Communication: * Act as a liaison between account managers, development teams, and customers throughout the data import process. * Provide regular updates on the progress of data imports and address any concerns or issues raised by stakeholders. Documentation and Reporting: * Maintain detailed documentation of data import processes, including templates, guidelines, and troubleshooting procedures. * Generate reports summarizing import activities, data integrity, and any issues encountered during the process. ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)