1,739 Connected Data jobs in the United States

Data Integration Lead

The Data Integration Lead is a pivotal role within our organization, responsible for driving the execution, enablement, and adoption of our comprehensive Data Transformation Plan. This role is crucial in supporting various use cases through seamless collaboration with Functions, Regions, and Lines of Business. The successful candidate will possess a unique blend of technical acumen, strong interpersonal skills, and project management expertise, thriving under pressure to meet stringent deadlines. This position demands a highly analytical mind capable of filtering, prioritizing, and validating complex, dynamic material from diverse sources to support business requirements, address data issues, and facilitate in-depth analysis. We seek an intellectually curious, highly motivated self-starter and problem-solver with an unwavering focus and the agility to adapt within a dynamic environment.

Key Responsibilities

• Stakeholder Relationship Management: Cultivate and maintain robust relationships with key stakeholders across the organization, actively facilitating and executing day-to-day activities and meetings to ensure alignment and progress.

• Project Oversight & Risk Management: Proactively examine and evaluate project status, meticulously identifying potential risks and issues. You will be responsible for escalating critical concerns, proposing necessary changes, and offering viable solutions to project leads.

• Governance & Presentation Excellence: Determine the appropriateness of content and materials for Governance forums, providing expert guidance on revisions and refinements to ensure clarity, accuracy, and impact.

• Program & Project Leadership: Manage the day-to-day operations of overall programs and projects, including overseeing associated dependencies. This involves effectively allocating and coordinating work within the team or across project groups to optimize efficiency and outcomes.

• SDLC Lifecycle Coordination: Collaborate closely with business and technology partners throughout the Software Development Life Cycle (SDLC). Specifically, you will steer the definition of business and functional requirements, oversee User Acceptance Testing (UAT) planning and execution, and facilitate seamless implementation.

• Issue Resolution & Policy Adherence: Support the timely resolution of project issues by devising and offering innovative solutions to complex problems. You will also provide expert interpretation and advice on policies, guidelines, and processes to ensure compliance and effective execution.

• Cross-Functional Liaison & Subject Matter Expertise: Act as a central liaison with multiple Data teams and departments, serving as a primary subject matter expert for the planning and analysis of project deliverables and processes.

• Independent Data Analysis & Reconciliation: Independently conduct thorough data analysis and reconciliations. You will execute tasks that directly contribute to various data initiatives, including but not limited to data requirements gathering, issues management, development of Data Quality rules, data lineage tracking, Data Governance frameworks, and taxonomy definition.

• Business Requirements & Process Mapping: Develop clear and concise business requirements, meticulously mapping current and future state processes to drive operational efficiency and strategic alignment.

• Strategic Design & Process Improvement Contribution: Contribute tactically to the strategic design and implementation of process improvement projects across various lines of business and functions, working in close partnership with Technology, Operations, and other support organizations.

• Risk Assessment & Compliance: Appropriately assess risk in all business decisions, demonstrating particular consideration for the firm's reputation and safeguarding our clients and assets. This includes driving compliance with applicable laws, rules, and regulations, adhering strictly to company policy, applying sound ethical judgment in personal behavior, conduct, and business practices, and proactively escalating, managing, and transparently reporting any control issues.

Qualifications

• Experience: Minimum of 6 years of relevant experience in Business Analysis, Financial/Regulatory Reporting (e.g., 15c3-3), and/or Business Transformation.

• Project Management: Demonstrated experience in managing and successfully implementing projects from inception to completion.

• Domain Knowledge (Preferred): Knowledge of Finance products such as Securities Financing Transactions (SFTs), FX, Fixed Income, Equities, Derivatives, and Loans is a significant advantage. Experience in financial control, accounting, and/or risk management is also a plus.

• Adaptability: Proven ability to be nimble, adjust priorities effectively, and thrive in a fast-paced, evolving environment.

• Integration & Strategic Thinking: Possesses a comprehensive understanding of how individual contributions and departmental functions collectively integrate to achieve overarching business objectives.

• Data Acumen: Familiarity with core data concepts, data controls, Data Quality measurement methodologies, and data lineage principles.

• Communication & Influence: Exceptional communication skills, with the ability to develop and deliver multi-mode communications that resonate with diverse audiences. Proven capability to drive consensus and influence relationships across all organizational levels.

Education

• Bachelor's/University degree or equivalent practical experience.

Job Family Group:

Data Governance

Job Family:

Data Integration

Time Type:

Full time

Primary Location:

Tampa Florida United States

Primary Location Full Time Salary Range:

$113,840.00 - $170,760.00

In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.

Most Relevant Skills

Change Management, Data Governance, Data Management, Data Quality, Emerging Tools and Technologies, Internal Controls, IT Implementation and Integration, Management Reporting, Program Management, Risk Management.

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

Anticipated Posting Close Date:

Sep 10, 2025

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi ( .

View Citi’s EEO Policy Statement ( and the Know Your Rights ( poster.

Citi is an equal opportunity and affirmative action employer.

Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

Trident Consulting is seeking " Data Integration Lead " for one of our clients in " Newark, NJ "

Role - Data Integration Lead
Location : Newark, NJ - onsite
Fulltime

Skills : ETL Strong + Python

We're seeking a Data Engineer to support data management initiatives. This role involves building robust data pipelines, integrating market and trade data, and ensuring high-quality data delivery for trading, risk, and compliance functions.
Required Skills
• Strong proficiency in Python, SQL, and data modeling.
• Experience with capital markets data (e.g., equities, fixed income, derivatives).
• Hands-on experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of data governance frameworks and metadata management.
• Experience with Kafka, Spark, Airflow, or similar tools for data orchestration.
Key Responsibilities
• Design and implement scalable data pipelines for market, reference, and transactional data.
• Develop ETL processes to ingest data from trading platforms, market data providers, and internal systems.
• Collaborate with trading desks, risk teams, and compliance to understand data requirements.
• Ensure data integrity, lineage, and governance across systems.
• Optimize data storage and retrieval for real-time and batch processing.
• Support regulatory reporting and analytics through reliable data infrastructure.
• Maintain documentation and contribute to data architecture decisions.
Note : Please submit the profile using below matrix - Skills Years of Experience Rating ( Out of 5 ) ETL Python SQL Data Modelling Capital Market Equity Fixed Income Derivatives Cloud (AWS or Azure)

About Trident
Trident Consulting is a premier IT staffing firm providing high-impact workforce solutions to Fortune 500 and mid-market clients. Since 2005, we've specialized in sourcing elite technology and engineering talent for contract, direct hire, and managed services roles. Our expertise spans cloud, AI/ML, cybersecurity, and data analytics, supported by a 3M+ candidate database and a 78% fill ratio. With a highly engaged leadership team and a reputation for delivering hard-to-fill, niche talent, we help organizations build agile, high-performing teams that drive innovation and business success.

Some of our recent awards include:
Trailblazer Women Award 2025 by Consulate General of India in San Francisco
Ranked as the #1 Women Owned Business Enterprise in the large category by ITServe.
Received the TechServe Excellence award.
Consistently ranked in the Inc. 5000 list of fastest-growing private companies in America
Recognized in the SF Business Times as one of the Largest Bay Area BIPOC/Minority-Owned Businesses in 2022

• Design, develop, and deploy incremental and full load pipelines using SSIS, Spark, Runbooks and Azure Data Factory to ingest data into landing, raw, and curated layers of the Data Vault.
• Build CDC (change data capture) solutions to minimize latency for downstream reporting and ML features.
• Automate schema evolution and metadata population for hubs, links, and satellites.
• Implement validation rules, unit tests, and data quality frameworks to enforce referential integrity and conformance to business rules.
• Maintain a requirements traceability matrix and publish data lineage documentation Metadata Management / SSAS models.
• Partner with Business Analysts to translate user stories into technical interfaces and mapping specs.
• Provide regular knowledge transfer sessions and production support, serving as Tier 2 escalation for data integration incidents.
• Create CI/CD pipelines (Azure DevOps, Git) to version ETL code, infrastructure as code, and automated tests.
• Develop PowerShell/.NET utilities to orchestrate jobs, manage secrets, and push metrics to Grafana or Azure Monitor.
• Benchmark and tune Spark, SQL, and SSIS performance; recommend index strategies, partitioning, and cluster sizing strategies for cost/performance balance.
• Stay current with emerging integration patterns (e.g., event driven architectures, Delta Lake) and propose pilots for adoption.
• Demonstrates high level of quality work, attendance and appearance.
• Demonstrates high degree of professionalism in communication, attitude and teamwork with customers, peers and management.
• Adhere to all local, federal and state laws in addition to Company policies, procedures, and practices.
• Performs any other duties that may be assigned by management.

• Provide functional support for critical business applications and integrations, escalating technical issues to development teams as needed.
• Contribute to data-catalog enrichment, data-dictionary curation, and SLA reporting.
• Mentor developers on ETL best practices and Data Vault modeling.
• Demonstrates high level of quality work, attendance and appearance
• Adheres to all Company Policies & Procedures and Safety Regulations
• Adheres to local, state and federal laws
• Perform other duties as assigned in alignment with evolving business priorities.
• Understands and complies with all company rules and regulations
• No direct reports; may lead ad-hoc project teams or vendor resources during integration projects.

• Strong communication, customer service, time management and organizational skills.
• Bachelor's in Computer Science, Information Systems, or related field.
• 4+ years building data integration with MS SQL, SSIS, or Spark; 2+ years with cloud based ETL platforms.
• Strong T SQL, Python/Scala for Spark, PowerShell/.NET scripting; working knowledge of MongoDB aggregation, SSAS tabular models, and Git CI/CD.
• Data Vault 2.0 certification a plus.
• Excellent problem solving, communication, and stakeholder management abilities.

• Ensure Effective Communication - Listens carefully and attentively to others' opinions and ideas. Communicates information clearly, concisely, and professionally.
• Establish Trust - Follows through on commitments. Is honest and direct with others. Promotes a culture of respect for, commitment to, and compliance with Company values, beliefs, and standards. Ensures the protection of confidential information.

• Competitive hourly salary.
• Merchandise discount: 50% off of Exclusive Brands and 40% off of third-party brands.
• Paid Time Off plan for year-round Boot Barn Partners.**
• Medical, Dental, Vision and Life Insurance.**
• 401(k) plan with generous company matching.
• Flexible schedules and work/life balance.
• Opportunities for growth at every level - we are opening 50+ new stores each year.

• Standing, walking and squatting less than fifty percent of the work shift.
• Required to lift, move and carry up to 40 pounds.
• Ability to read, count and write to accurately complete all documentation and reports.
• Must be able to see, hear and speak in order to communicate with partners and customers.
• Specific vision abilities include close vision, distance vision, peripheral vision, depth perception and ability to adjust focus.
• Manual dexterity required using hands to finger; handle, feel and type; reach with hands and arms.

• The workspace is clean, orderly, properly lighted and ventilated with the proper safety compliance.
• Noise levels are considered moderate.

• Develop and maintain a strategic plan for integrating healthcare data (claims, enrollment, etc.) into organizational systems, aligning with business needs, compliance requirements, and technological capabilities.
• Ensure all data transactions comply with relevant standards (e.g., HIPAA, HITECH), monitoring for regulatory updates and implementing necessary changes.
• Coordinate with IT, Operations, and other teams to integrate data into billing and other core systems, including the development and management of interfaces or APIs.
• Lead data mapping and transformation activities, working with analysts and developers to validate, normalize, enrich, and ensure compatibility with internal data models.
• Implement robust error handling and monitoring processes to guarantee the accuracy and reliability of integrated data, swiftly resolving issues such as formatting errors or missing information.
• Optimize integration processes for performance and efficiency, considering data volume, processing speed, and system resource utilization.
• Collaborate with infrastructure and security teams to implement security measures (encryption, access controls, audit trails) that protect sensitive healthcare data and ensure regulatory compliance.
• Communicate effectively with internal stakeholders (IT, Operations, Security, Compliance) and external partners to align integration efforts with organizational objectives.
• Manage relationships with third-party vendors, ensuring service level agreements (SLAs) are met and vendor solutions support integration needs.
• Continuously evaluate and improve integration processes, technologies, and workflows to enhance efficiency, accuracy, and performance.
• Serve as a liaison between the organization and its clients (e.g., insurance companies, healthcare providers), understanding their requirements, preferences, and expectations for data transactions.
• Collaborate with account management teams to gather client requirements, translate them into technical specifications, and ensure integration processes meet client needs (e.g., custom 837 claims, 834 enrollment files).
• Facilitate client onboarding, ensuring smooth integration of transactions, and provide training and support as needed.
• Proactively communicate with clients regarding integration project status, upcoming changes, and issue resolution to maintain strong relationships and high satisfaction.
• Identify opportunities for account growth and retention by expanding services based on client needs and industry trends.
• Solicit and incorporate client feedback to drive continuous improvement of integration workflows, tools, and services.

• Bachelor's degree in Computer Science, Information Systems, Healthcare Informatics, or a
• related field (Master's preferred).
• 5+ years of experience in data integration, preferably within the healthcare sector.
• Strong knowledge of healthcare data standards (e.g., HIPAA, HITECH, X12, HL7).
• Experience with system integration, data mapping, ETL processes, and API development.
• Familiarity with healthcare claims (837), enrollment files (834), and related transaction sets.
• Proven ability to manage cross-functional teams and vendor relationships.
• Excellent communication, analytical, and problem-solving skills.
• Experience in client-facing roles and a demonstrated commitment to client satisfaction.

• Experience working with large-scale data pipelines and cloud infrastructure ( cloud ETL tools like Glue etc., and Data Warehousing solutions like Redshift etc., )
• Knowledge of Deploying and maintaining cloud-based infrastructure for data workflows (e.g., AWS, GCP, Azure, RedShift)
• Strong technical expertise in Cloud applications, Data ingestion, and Data Lake architecture.
• 5 years of extensive hands-on experience in building ETL interfaces using DataStage version 11.3 and higher version to aggregate, cleanse and migrate data across enterprise-wide Big Data, and Data Warehousing systems using staged data processing techniques, patterns, and best practices.
• Combined 4 years of experience of advanced SQL and stored procedures (in DB2, SQL Server, and Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability, and security of DATASTAGE ETL Platform

• Extensive hands-on experience in building ETL interfaces using DataStage version 11.7 to aggregate, cleanse and migrate data across enterprise-wide Big Data, and Data Warehousing systems using staged data processing techniques, patterns and best practices.
• Setting up interfaces from DataStage server to different platforms/tools like Hadoop Data Lake, SAS executions, MicroStrategy Command Manager etc.
• Experience working with large-scale data pipelines and cloud infrastructure ( cloud ETL tools like Glue etc., and Data Warehousing solutions like Redshift etc.)
• Strong technical expertise in Cloud applications, Data ingestion, and Data Lake architecture.
• Strong experience in full life cycle management of capturing, versioning and migrating various DataStage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as Data Stage, or other equivalent tools (including open source) by establishing standards, guidelines and best practices.
• Combined experience of advanced SQL and stored procedures (in DB2, SQL Server, and Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of DataStage ETL Platform.
• Proficiency on working with Unix and Linux servers, jobs scheduling, as well as script languages such as C, shell script (sh), AWK, and sed.
• Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns.
• Working knowledge of DataStage Administration and best practices is highly recommended.
• Technical knowledge in predictive analytics architecture and in development and deployment of predictive models is a plus.

• Strong analytical skills with the ability to analyze information identify and formulate solutions to problems. Provides more in-depth analysis with a high-level view of goals and end deliverables.
• Over 5 years of proven work experience in DataStage, with version 11.0 or above, including over two years of DataStage version 11.7 is a must.
• Over 3 years of proven work experience on scripting languages such as Perl, Shell, and Linux/Unix servers, files structure, and scheduling.
• Complete work within a reasonable time frame under the supervision of a manager or team lead.
• Plan and manage all aspects of the support function.
• Extensive knowledge of and proven experience with data processing systems, and methods of developing, testing and moving solutions to implementation.
• Strong knowledge in project management practices and ability to document processes and procedures as needed.
• Work collaboratively with other support team members and independently on assigned tasks and deliverables with minimum supervision
• Communicate effectively with users at all levels, from data entry technicians up to senior management, verbally and in writing.
• Self-motivated, working closely and actively communicating with person to accomplish time critical tasks and deliverables
• Ask questions and share information gained with other support team members, recording and documenting this knowledge
• Elicit and gather user requirements and/or problem description information, and record this information accurately
• Listen carefully and act upon user requirements
• Convey and explain complex problems and solutions in an understandable language to both technical and non-technical persons
• Present technical solutions to management and decision makers
• Follow the lead of others on assigned projects as well as take the lead when deemed appropriate
• Think creatively and critically, analyzing complex problems, weighing multiple solutions, and carefully selecting solutions appropriate to the business needs, project scope, and available resources
• Take responsibility for the integrity of the solution