2,978 Data Integration jobs in the United States

Client: Options Clearing Corporation

Location: Hybrid downtown Chicago

Interview Mode: Virtual 2 rounds

• Contingent Worker - RCR-956 TDM-6
• I. WORK TO BE PERFORMED:
  • Responsible for the design, development, implementation, and maintenance of new and existing Data Integration processes within the Strategic Data Platform and other data solutions implementations.
  • Design, develop, maintain, enhance, and monitor Data Integration processes sourcing data from various structured and semi-structured data sources, transforming as per provided business rules or data mappings, and loading into target databases/services including DB2, AWS S3, and Apache Iceberg.
  • Serve as a subject matter expert on multiple data integration projects, ensuring consistent design and efficient data processing.
  • Play a leading role in Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations.
  • Provide Level 2 and Level 3 technical support to mission-critical applications.
  • Perform process improvement and re-engineering with an understanding of technical data problems and solutions as they relate to the current and future business environment.
  • Analyze complex distributed production deployments and make recommendations to optimize performance.
  • Design and develop innovative data solutions for demanding business situations.
  • Develop and document Data Integration standards and procedures.
  • Design reusable and portable Data Integration components.
  • Transform flat delimited files into multiple formats, including Parquet, JSON, and Protobuf.
  • Play a supporting role in Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations.
  • Investigate production Data Integration issues and work to determine the root cause of problems.
  • Work with the DBA teams to fix performance issues as required.
  • Work with the QA team to address testing issues as they occur.
  • Work with the Data Quality/Data Governance team to ensure required data quality and data integrity standards are met.
  • Design reusable Data Integration components.
  • Participate in daily Scrum standups. Update task status in Jira.
  • Conduct Code reviews and incorporate suggested improvements/fixes.
  • Perform other duties as assigned.
• II. SKILL AND EXPERIENCE REQUIRED:
  • 3+ years in IT application development, with at least 2 years in Data Integration (ETL) Development, using tools such as DataStage, Python, SQL and Unix Shell Scripting.
  • Experienced practitioner with a proven track record of implementing mid-scale to large-scale Data Integration (ETL) solutions, performing data analysis and profiling, interacting with client management, and designing and architecting dynamic ETL solutions.
  • Working knowledge for Data Types and Databases including Relational, Dimensional, Vertical and No SQL databases.
  • Hands-on experience with data cleansing and data visualization and familiarity with Hadoop Ecosystem.
  • Experience with platforms such as Hive and Trino/Starburst.
  • Strong conceptual knowledge of file formats such as JSON, Parquet and Protobuf.
  • Capable of writing and optimizing SQL queries and stored procedures.
  • Exposure to AWS Services including but not limited S3, PostgreSQL, Apache Iceberg and Kafka.
  • Ideal candidate would have worked on a Scrum Team and familiar with using tools such as Jira and Git.
  • Experience developing containerized Data Integration solutions using Kubernetes, Rancher, and CI/CD pipelines using Harness, Jenkins and Artifactory is a plus.
  • Experience working with scheduling tools such as UC4, Control-M, or Autosys is a plus.
  • Experience working with Cloud ecosystems (AWS, Azure, GCP, AWS preferred) in multi-availability zone, multi-region deployments.
  • Experience in database performance optimization techniques, multidimensional database designs, and physical database implementations for databases including DB2 and Apache Iceberg is a plus.
  • Strong verbal/written communication skills.
  • Ability to interact with business users and to develop positive working relationships.
  • AWS Certified Solution Architect Associate Level is a plus.
  • Big data related certification is a plus.

• Design, implement, and maintain data integration workflows across insurance platforms (e.g., policy administration, claims, billing, CRM, reporting systems).
• Develop and manage the submission of insurance data calls, including regulatory, statistical, and reinsurance reporting.
• Collaborate with internal teams (e.g., Actuarial, Claims, Underwriting, Compliance) to gather data requirements and ensure data accuracy.
• Build and optimize ETL (Extract, Transform, Load) processes to automate data extraction and submission.
• Ensure adherence to industry data standards (e.g., ACORD, ISO, NAIC) and internal data governance policies.
• Coordinate data exchanges with external entities such as vendors, reinsurers, MGAs, and regulatory bodies.
• Create and maintain technical documentation, including data mappings, integration specifications, and process diagrams.
• Support system upgrades, migrations, and testing activities related to data interfaces.
• Monitor integration processes and proactively resolve data quality issues, transmission errors, and performance bottlenecks.
• Provide timely and accurate data extracts for audits and regulatory examinations.

• Minimum of 3 years' experience in data integration, ETL development, or application programming, preferably in the insurance sector.
• Proficiency in SQL and relational databases (e.g., SQL Server, Oracle, MySQL).
• Hands-on experience with ETL tools (e.g., Informatica, Talend, SSIS) and APIs/web services (REST, SOAP).
• Familiarity with insurance operations and regulatory reporting (e.g., NAIC, state-level data calls).
• Understanding of data formats such as XML, JSON, CSV, and EDI.
• Ability to interpret and work with insurance data structures (e.g., policy, claims, premium, loss).
• Strong analytical and problem-solving skills with keen attention to detail.
• Capable of working independently and collaboratively across teams.
• Excellent communication skills, both technical and non-technical.

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
• Experience with insurance platforms such as Guidewire, Duck Creek, Majesco, or custom-built systems.
• Knowledge of data governance, privacy regulations (e.g., GLBA), and cybersecurity best practices.
• Familiarity with business intelligence tools like Power BI or Tableau is a plus.

* Develop detailed technical specifications and designs for waterfall/XP projects / system enhancements.

* Provide application domain knowledge to the ADM team.

* Manage unstable applications / systems by helping to resolve incidents and issues.

* Support infrastructure first build with Solution Architects and Infrastructure Engineers.

* Review, guide, troubleshoot and resolve contentious issues escalated during implementation.

* Evaluate integration of SaaS / COTS packages to current environment.

* Develop operating procedures and user manuals for transition into routine operations.

* Enable building of knowledge databases for technology, solutions and domain areas.

* Work with architecture, application services, infrastructure, release management and other relevant stakeholders to enable a smooth deployment.

* Continuously work on capturing and transferring tacit knowledge to vendors and knowledge management systems.

Required Job Qualifications

*Bachelor Degree and 2 years Information Technology OR Technical Certification and/or College Courses and 4 year Information Technology experience OR 6 years Information Technology experience.

* Knowledge of application configuration

* Knowledge of Big Data Analytics - HAVeN / HADOOP/ Autonomy / Vertica

* Knowledge of Cloud computing / SaaS / IaaS / PaaS technologies

* Knowledge of Integration Technologies - Tibco/Informatica/CAS

* Knowledge of Mobile technologies - Phonegap / iOS / Android / Java / HTML5

* Knowledge of Scripting Languages - BASH / PERL / PYTHON / RUBY

* Service Oriented Architecture - SOAP / REST

* Web Technologies - HTML/CSS/Java/ASP.Net/PHP/Ruby/C#

* Rapid prototyping

* Requirements definition & management

* SDLC Methodology - Agile / Scrum / Iterative Development

* System Performance management

* Conceptual thinking

* Creative thinking

* Problem solving and analytical thinking

* Strong oral/written communication skills

Preferred Job Qualifications:

* Bachelor Degree in Computer Science or Information Technology related

* Ability to execute

• We are seeking a highly skilled Automation & Data Integration Developer who excels in PowerShell, Python, and working with RESTful APIs.
• This role is responsible for building and maintaining automated solutions that pull and process data from major platforms like Google Workspace, Microsoft 365, and Slack.
• Ideal candidates will have strong experience in scripting, data collection, and writing complex queries to extract meaningful insights from various systems.

• Design, develop, and maintain scripts in PowerShell and Python for automation and data extraction.
• Integrate with third-party APIs (Google, Microsoft, Slack, etc.) using RESTful calls to collect structured and unstructured data.
• Write efficient and scalable queries for processing and analyzing collected data.
• Automate manual workflows by building reliable and reusable code.
• Develop internal dashboards or reporting tools to surface collected data where appropriate.
• Troubleshoot API issues, maintain authentication/authorization flows (OAuth, tokens), and ensure data security best practices.
• Document processes, scripts, and integration logic for internal stakeholders and team members.

• 5+ years of experience in scripting with PowerShell and Python.
• Strong experience working with REST APIs including handling authentication, rate limits*** and pagination.
• Experience pulling and transforming data from Google Workspace APIs, Microsoft Graph APIs, and Slack APIs.
• Proficiency in writing SQL or NoSQL queries for data extraction and manipulation.
• Experience with logging, monitoring, and handling API errors and timeouts.
• Familiarity with JSON, XML, and other data interchange formats.
• Excellent problem-solving and debugging skills.
• Strong written and verbal communication skills.

• Experience with data warehousing or data pipeline tools (e.g., Airflow, dbt, Azure Data Factory).
• Exposure to cloud environments (e.g., GCP, Azure, AWS).
• Familiarity with DevOps principles, Git, and CI/CD tools.
• Prior work with enterprise security, compliance, or audit teams is a plus.

• Design, develop, test, deploy, and maintain data integration processes between disparate systems.
• Understand and translate business needs into data models.
• Collaborate with team members and stakeholders to understand and address data needs.
• Manage and maintain knowledge management systems, ensuring they are up-to-date and accessible to all relevant stakeholders.
• Ensure compliance with data governance, data security, and privacy policies.
• Prepare data for prescriptive and predictive modeling.
• Implement data flow solutions for real-time and batch data processing.
• Create and maintain documentation related to data integration processes and workflows.
• Resolve data-related problems and ensure data quality and integrity.
• Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability, and value.
• Conduct data analysis to identify trends, insights, and areas for improvement in knowledge management practices.

• 5-8 years of experience in data integration, data development, or similar experience.
• BS in Computer Science, Engineering, or relevant field
• Strong background in data analysis, with the ability to interpret and present data effectively.
• Proven experience in developing and implementing knowledge management strategies and systems.
• Proficiency in knowledge management tools and software.
• Strong understanding of data governance and security best practices.
• Proven work experience as a Data Integration Developer, Data Analysis, or similar role.
• Proficiency in SharePoint and Power BI.
• Knowledge of data warehousing, data modeling and data architecture.
• Proven track record of enhancing knowledge sharing, improving data accessibility, and fostering a culture of continuous learning.
• Excellent communication skills.
• Ability to translate complex concepts into clear, user-friendly content.
• Excellent interpersonal skills.
• Strong organizational and project management skills.
• Ability to work collaboratively with cross-functional teams.

• Masters (or higher) in Computer Science, Engineering, or relevant field
• Experience in a government agency/organization.
• Experience with change management and/or organizational development.
• Experience in the implementation and use of analytic tools to measure knowledge management system effectiveness.

• MUST have an active Secret Security Clearance or higher

• ETL Design & Development
  • Design and implement scalable ETL pipelines across platforms including Deltek Vantagepoint, Salesforce, Salesforce Marketing Cloud, IronClad, HubSpot, and Microsoft SQL Server.
  • Build and maintain automated data flows using tools such as Workato, CData, and SQL Server Integration Services (SSIS).
  • Write complex SQL queries, stored procedures, and scripts for data extraction, transformation, and validation.
  • Push and stage data using SQL Server to support integration efforts.
• Integration Management & Operations
  • Monitor and troubleshoot data pipelines to ensure consistent and reliable performance.
  • Provide production support for existing ETL processes, including issue resolution and root cause analysis.
  • Perform performance tuning and optimization of ETL and data integration processes.
• Collaboration & Project Coordination
  • Partner with business and technical stakeholders to define data requirements and deliver integrated, high-quality data solutions.
  • Collaborate with cross-functional teams using project management tools such as Jira to manage timelines and deliverables.
  • Communicate issues, risks, and status updates proactively to leadership.
• Governance, Documentation & Testing
  • Develop and maintain technical documentation, including data flow diagrams, process maps, and integration specifications.
  • Contribute to the enforcement of data governance and quality standards.
  • Conduct software reviews and support testing activities to ensure data integrity and functionality.
• All other duties as assigned.

• Strong experience in data integration, ETL development, and enterprise platforms such as Salesforce, Deltek Vantagepoint, and Salesforce Marketing Cloud.
• Proficiency in SQL and experience working with enterprise data warehouses, APIs, and integration tools such as Workato, CData, and SSIS.
• Familiarity with legal and marketing tech platforms such as IronClad and HubSpot.
• Solid understanding of integration design patterns, agile development practices, and the use of tools like Jira for task management.
• Proficiency in Microsoft Office tools, including Word and Excel.
• Strong analytical, problem-solving, and troubleshooting skills with keen attention to data accuracy and detail.
• Effective communicator with the ability to collaborate across technical and non-technical teams.
• Ability to organize, prioritize, and manage multiple projects in a fast-paced environment while maintaining quality and accuracy.
• Proactive, adaptable, and self-motivated with a desire for continuous learning and improvement.
• Discreet and professional in handling confidential and sensitive information.
• Ability to mentor junior team members and contribute to team development.

• Understand and communicate integration specifications and plans for implementation with clients.
• Use technologies including SQL and Microsoft Excel to solve complex problems.
• Demonstrate proficiency with data integration & configuration/ ETL.
• Gain a deeper understanding of common data types and source systems including General Ledger, Payroll, Patient Accounting, Patient Billing, etc.
• Partner with clients as a trusted advisor to implement best practices within healthcare finance and clinical data.
• Collaborate with Strata's Technical and Engineering Teams to ensure the product is aligned with client's needs.
• Lead client training to ensure clients understand specific features and functions related to StrataJazz®
• Communicate proactively with Strata team members, managers, and project managers on issues and risks that may arise during the project life cycle. Develop and execute action plans to mitigate risks proactively.
• Meaningfully contribute to operational improvement and strategic growth projects to enable Strata to continue to scale operations and continually improve our level of service to clients.
• Work in an Agile environment and learn one of the most widely used and effective methodologies for building and implementing high quality, feature-rich software.

• Professional and/or academic background in SQL and relational database concepts
• Experience leading clients through complex projects
• You'd really wow us if you have:
  • Professional experience implementing cloud-based technology
  • Experience working with Electronic Medical Records, General Ledgers, Patient Billing, or Payroll data

• We connect with positive intent.
• We are helpful.
• We own it.
• We get better every day.
• We are humble.

The Data Integration Manager will be responsible for overseeing a team of engineers and managing multiple large projects related to data integration across the enterprise. The role involves streamlining HL7 integration, collaborating with technical architects, and ensuring efficient data conversion and migration workflows. The ideal candidate will have a strong technical background in healthcare, integration methodologies, and hands-on leadership experience. Key Responsibilities: • Effectively manage multiple large projects simultaneously with strong organizational and planning skills. • Collaborate with leaders and architects to define the integration roadmap. • Provide oversight and leadership to a diverse team to foster creative problem-solving and innovation. • Demonstrate expertise in message-oriented middleware, HL7 standards, and integration methodologies. • Lead research on emerging technologies and drive innovation in data integration and engineering. • Manage the life cycle of the data conversion and migration platform (installation, upgrade, patching, and maintenance). • Participate in key technical and design discussions with technical architects and leads. • Leverage automation technologies to deliver environments rapidly and maintain configuration management across the enterprise. • Streamline HL7 integration and conversion workflows to mitigate redundancies. Required Qualifications: • 8+ years of direct technical expertise and hands-on experience in data integration. • 3+ years of managerial experience. • Expertise in healthcare integration standards and technologies such as HL7, FHIR, and Epic EHR. • Strong knowledge of Enterprise File Transfer Services, Enterprise API Integration, and Microservices Architecture. • Proficiency in message-oriented middleware, Web Services, SOAP, XML, JSON, REST, and related technologies. Preferred Qualifications: • Experience building and leading a Center of Excellence team in Architecture, Security, Observability, and DevOps. • Proven ability to create a customer-centric, delivery-focused, and results-driven team. Primary Skills: • HL7, FHIR, Enterprise File Transfer Services, Enterprise API Integration, Microservices Architecture, Epic EHR. #J-18808-Ljbffr

• Identifies training and development needs within the district.
• Conducts training sessions on school data including use of platforms and use of local and state assessment data.
• Supports schools in the use and interpretation of state and local assessment data.
• Conceptualizes and writes new reporting in Cognos to support school and district data collection and strategic planning.
• Participates in report writing training in IBM Cognos.
• Stays up to date with current state accountability rules and updates district reporting as necessary.
• Drafts research reports on set topics throughout the school year
• Develops presentation materials around research report topics.
• Facilitate training using techniques that maximize learner participation, comprehension and application of the material.
• Supports the creation and visualization of district instructional focus tools and collaborates with schools to rework or design tools to improve usability and ensure systems and tools meet user needs.
• Collaborates with school-based and district personnel on data analysis and planning.
• Receives, prepares or completes various forms, reports, correspondence, lists, procedures, spreadsheets, or other documents.
• Serves as the point of contact for schools by compiling, interpreting, and presenting student-level data to aid in understanding and planning.
• Supports strategic projects by developing data collection and observation tools, KPIs, and dashboards/reports for monitoring key performance indicators.
• Conducts meetings with school administration to regarding assessment data.
• May operate a motor vehicle to conduct various work activities.
• Prepares or completes various documents, reports, and correspondence as required.
• Performs general/clerical tasks, which may include answering telephone calls, typing documents, making copies, sending/receiving faxes, filing documentation, processing incoming/outgoing mail, or running errands.
• Operates a computer to enter, retrieve, review or modify data; verifies accuracy of entered data and makes corrections; performs basic maintenance of office/computer equipment.
• Complies with applicable district, state, and federal codes, laws, rules, regulations, standards, policies and procedures.
• Adheres to the Teacher Code of Ethics as defined by Tennessee Law and Code of Professional Conduct as defined by Board Policy 5.6011.
• Acts in a professional, respectful, and welcoming manner at all times.
• Creates a customer-focused climate and provides quality services and support to schools, community, businesses, Superintendent of Schools, Board of Education, and other stakeholders.
• Works collaboratively with all stakeholders.
• Follows established procedures to ensure assigned areas are safe.
• Maintains confidentiality.
• Attends work and arrives to work on time.
• Performs other related duties as assigned.

• Bachelor's Degree in a related field;
• Three (3) years working with educational data and visualization;
• Or any equivalent combination of education, training, and experience that provides the required knowledge, skills, and abilities for this job.
• Teaching licensed preferred.

• Ability to use a variety of software applications to generate reports.
• Ability to identify and communicate trends in data.
• Ability to analyze data and make corrections to ensure the integrity of the data.
• Ability to communicate effectively verbally and in writing.
• Ability to work with a team and complete routine task independently.
• Ability to work independently with minimum supervision.