Data Integration Analyst Job at Insight Global in New York

This opening is for a Data Integration Analyst/Data Steward with 5+ years of experience working with data integration and ETL tools, SQL/database management, and data modeling. The ideal candidate will have strong problem-solving skills, strong SQL skills with knowledge of both relational and NoSQL databases. The analyst must have a strong attention to data quality and governance, have experience acting as the primary negotiator of conflicts in definition and implementation between data systems, and can create and speak to documentation of the data contained in constituent systems to other groups of u .

Key Responsibilities:
Analyze and document the flow of data through various systems, from the initial source to the final destination.
Build and maintain comprehensive documentation of data flows, mappings, and integration processes, updating documents as systems or API requirements evolve.
Identify and understand the data fields that are passed from upstream systems, and map the data fields into the API structure as appropriate, differentiating between required and optional fields.
Collaborate with Business Stakeholders and Vendor to clarify data needs, issues, and integration progress.
Work closely with Business Analysts, Quality Analysts, and Developers to ensure the mapped data is correctly implemented within the applications interface to the vendor API, data validation rules are followed so that incoming data meets quality standards, and any data issues or discrepancies are resolved with upstream system owners.

Hourly Rate for this position is $44/hr

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

At least 5 Year of experience with Data Integration projects, on top of a background in data management, data quality, or a related field.
Proficiency with Data Mapping, Data Quality, Data Integration, and data transformation techniques.
Strong SQL experience with both relational and NoSQL databases for querying and analyzing data.
Detail-oriented mindset to ensure accurate data mapping and validation.
Understanding of data formats such as JSON, XML, and CSV.
Strong analytical abilities to understand complex data flows and transactional processes.
Ability to communicate technical details to non-technical stakeholders and collaborate with cross-functional teams.

Nice to Have Skills & Experience

Experience involving third-party vendors and API integrations is a plus.
Familiarity with API structures, particularly RESTful APIs.
Banking domain and/or fraud experience a plus.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.