Data Integration Engineer


**100% Remote Description: Paychex is at the start of their data transformation and are looking to build a team to do the initial analysis, cleansing and migration of their corporate data. All of their current data is unstructured and scattered throughout different technologies. These people will be responsible for cleaning up the data based on the concepts that have already been defined and get it migrated and ready for consumption. You will be working with other teams to figure it out and writing code to clean it. Responsible for developing data integration processes to support Paychex data initiatives aimed at assuring accuracy and consistency of critical business data across Paychex systems. Requires depth and breadth of experience in data and database technologies including proficient SQL and software development. Provides technical support during critical and non-critical business hours. -Develops an understanding of the assigned data environment through data profiling and analysis using enterprise data tools to assess quality and cleanliness of data. Identify opportunities to improve data quality. - Using enterprise data platform and tools, develops batch and streaming integration jobs. - Build solutions to extract, cleanse, transform, enrich, load and validate all required data for the successful implementation of data migration. - Documents data integration and data quality results and requirements, proposed solutions, and code to provide traceability from requirements through code implementation. Develop data monitoring solutions based on defined data quality business rules. - Consults with infrastructure and application architects to integrate solutions into the Paychex environment to ensure consistency with Paychex architecture and standards, along with Integration Best Practices. - Coordinates the management of data tools and platform so that software patches and software/hardware upgrades are planned and executed appropriately. - Work with Data Management Organization and data owners to establish and progress towards data management maturity and data quality index. - Works with capacity planning and performance testing groups to ensure that solutions perform to Service Level Agreements. Skills: Integration, Sql, Data, Data integration, Data modeling Top Skills Details: 1) 5 years of experience in Software engineering with a focus on data integration, data processing, data quality, data migration and data governance. DataFlux Data Management Studio and server experience preferred 2) 3 years of experience in SQL development 3) 3 years of experience with Oracle, SQL Server and NoSQL databases.(Oracle preferred) Additional Skills & Qualifications: 2 years of experience with cloud technologies.(Microsoft Azure Data Factory preferred) About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.