CrawlJobs Logo

Systems Analyst Data Integration & ETL

United States, Austin · Job Posted May 30, 2026
Apply Position
Job Link Share

Job Responsibility

  • Design, develop, and maintain ETL mappings and workflows using Informatica Power Center and/or Informatica Intelligent Cloud Services (IICS)
  • Develop complex Snowflake SQL scripts, database views, and materialized views for enterprise analytics solutions
  • Acquire, integrate, and transform data from multiple structured and unstructured data sources
  • Support enterprise data warehousing and dimensional modeling initiatives
  • Automate data acquisition and transformation processes
  • Collaborate with architects and data engineering teams on optimal data design and integration strategies
  • Perform verification, validation, testing, and troubleshooting of ETL workflows and SQL scripts
  • Participate in Agile sprint ceremonies, backlog refinement, and technical planning sessions
  • Create technical documentation, workflow diagrams, mapping documents, and system specifications
  • Develop mockups and collaborate with stakeholders to validate business requirements
  • Analyze changing business requirements and recommend technical enhancements
  • Support deployment, publication, and operational maintenance activities
  • Assist with implementation and configuration of development tools and environments

Requirements

  • 8+ years of experience developing ETL mappings and workflows using Informatica Power Center or IICS
  • 8+ years of experience integrating data from multiple data sources including Oracle, SQL Server, Excel, Access, and Adobe PDF
  • 8+ years of experience designing and developing complex Snowflake SQL scripts
  • Strong experience supporting enterprise data warehousing, analytics, or performance management systems
  • Proven experience writing efficient, scalable, testable code using software development best practices
  • Strong analytical, troubleshooting, and systems analysis skills
  • Experience with technical documentation, data mapping, and diagramming tools such as Visio or Erwin
  • Experience planning and delivering enterprise software platforms across multiple business units
  • Proficiency with Microsoft Office Suite including Word, Excel, PowerPoint, and MS Project

Nice to have

  • Experience working within Agile sprint teams
  • Experience handling healthcare, PHI, or PII data
  • Healthcare industry or HHS agency experience
  • Experience with Python scripting and automation
  • Experience using JIRA
  • Experience with REST or SOAP web services
  • Experience developing with Java and JavaScript
  • Experience with CI/CD pipelines using GitHub and GitHub Actions
  • Experience with MuleSoft development
  • Experience using AI-enabled development tools such as Snowflake Cortex, Snowflake Intelligence, or Informatica Claire
  • Bachelor's degree in Computer Science, Information Systems, Business, or related field

What we offer

  • Medical, dental, and vision coverage
  • Life and disability insurance
  • Additional voluntary benefits

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Systems Analyst Data Integration & ETL

8 matching positions

Lead ETL Data Integration Developer

The Lead ETL Data Integration Developer is responsible for the design, develop, ...
Location
Location
United States , Los Angeles
Salary
Salary:
121056.00 - 199742.00 USD / Year
lacare.org Logo
L.A. Care Health Plan
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree in Computer Science or Related fields
  • like: Statistics, Math, or Business Systems
  • At least 6 years of experience designing, developing, and testing ETL interfaces aligned with defined requirements preferably in a healthcare, or analytical or technological industries
  • At least 3 years of leading process, program, or staff experience
  • Experience in software development and design with strong emphasis on Data warehousing concepts, database design patterns, ETL methodologies, Processing and Transforming massive quantities of Data, Data cleansing, Data quality and Performance Tuning of ETL and database processes
  • Experience with Erwin data modeling toolset
  • Extensive experience in strategizing roadmap projects, data modeling, designing ETL framework and data mart life cycle development and providing technical supervision on implementation of large end-to-end Data Warehouse applications
  • Experience in UNIX Shell / Python Scripting for automation of batch and ETL jobs
  • Strong technical skill to learn, certified and lead team to EDM technology roadmap
  • The Enterprise Data Platforms includes Cloud based Informatica tool, IICS
Job Responsibility
Job Responsibility
  • Responsible for the requirement analysis, design, development, architecture, implementation and support of enterprise-wide databases
  • Participates in requirements gathering sessions with business and technical staff to distill technical requirements from business requests
  • Present ETL documentation and designs to team members and convey complex information in a clear and concise manner
  • Leads the work of assigned staff
  • regularly assigns and checks the work of others, providing guidance, training and feedback on performance to department management
  • Oversees the daily office workflow, develops and recommends enhancements to process and procedures
  • Contributes to the technical decisions, working with managers to provide coaching, counseling and feedback on technical performance and implementations on projects members
  • Provide detailed plans and estimates for all phases of a project
  • Delivers data integration through the implementation of shared databases, modification and optimization of current systems, managing the exchange and storing of data, and making recommendations when upgrades or changes are needed to maintain smooth operations
  • Optimizes data warehouse performance by dealing with any data conflicts that arise and keeping data definitions up to date
What we offer
What we offer
  • Paid Time Off (PTO)
  • Tuition Reimbursement
  • Retirement Plans
  • Medical, Dental and Vision
  • Wellness Program
  • Volunteer Time Off (VTO)
  • Fulltime
Read More
Arrow Right

Data Systems & Integration Engineer

Location
Location
United States , Colorado Springs
Salary
Salary:
75000.00 - 90000.00 USD / Year
Vladimir Jones
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Engineering, Information Systems, or related field. Master's degree preferred.
  • Proven experience in data engineering, software development, or related roles.
  • Proficiency in programming languages commonly used in data engineering (e.g., Python, Java, Scala, etc.).
  • Use data analytics software (SQL, SAS, R, etc.) to clean and organize large data sets to be used in analyses
  • Design, diagnose, and deploy statistical models to analyze and interpret data using a statistical software package such as R, SAS, or Stata
  • Strong knowledge of database systems, data modeling techniques, and SQL proficiency.
  • Proficiency with ETL tools commonly used in data engineering (e.g., SSIS, Databricks, etc.).
  • Experience with big data technologies and frameworks (e.g., Hadoop, Spark, Kafka, etc.).
  • Familiarity with cloud platforms and services (e.g., AWS, Azure, Google Cloud Platform, etc.).
  • Excellent problem-solving skills and attention to detail.
Job Responsibility
Job Responsibility
  • Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
  • Develop robust ETL (Extract, Transform, Load) processes to integrate data from diverse sources into our data ecosystem.
  • Implement data validation and quality checks to ensure accuracy and consistency.
  • Design and maintain data models, schemas, and database structures to support analytical and operational use cases.
  • Optimize data storage and retrieval mechanisms for performance and scalability.
  • Evaluate and implement data storage solutions, including relational databases, NoSQL databases, data lakes, and cloud storage services.
  • Maintain dataset integrity and optimize builds to work in AI Agent and BI Visualizations.
  • Build and maintain integrations with internal and external data sources and APIs.
  • Integrate agency AI initiatives into workflow processes and dataflows.
  • Implement RESTful APIs and web services for data access and consumption.
What we offer
What we offer
  • 401k + employer match
  • Medical, Dental, Vision
  • Life and short-term disability (100% employer paid)
  • Voluntary long-term disability
  • EAP
  • 9 paid holidays
  • PTO, Floating Holiday, Volunteering Day
  • Education reimbursement
  • Employee referral program
  • Employee recognition program where points turn into money!
  • Fulltime
Read More
Arrow Right

Data Engineer / Systems Analyst III - Emerging Technologies

We are seeking an experienced Data Engineer / Systems Analyst III to support a m...
Location
Location
United States , Austin
Salary
Salary:
Not provided
mmcgrp.com Logo
MMC Group LP
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years of experience developing ETL mappings and workflows using Informatica PowerCenter or Informatica IICS
  • 8+ years of experience integrating data from multiple data sources and technologies including Oracle, SQL Server, Excel, Microsoft Access, Adobe PDF
  • 8+ years of experience designing and developing complex Snowflake SQL scripts
  • 8+ years of experience supporting data analytics, performance management, or enterprise data warehouse initiatives
  • Strong analytical, troubleshooting, and systems analysis skills
  • Experience producing technical documentation, diagrams, and data mappings
  • Experience with Visio, Erwin, Microsoft Office Suite, and MS Project
  • Proven ability to write scalable, testable, and efficient code
  • Experience delivering enterprise software solutions across multiple business units
Job Responsibility
Job Responsibility
  • Lead and contribute to Agile data engineering and systems analysis initiatives
  • Design, develop, and maintain complex ETL workflows and data integration processes
  • Acquire and integrate data from multiple enterprise and external data sources
  • Develop advanced Snowflake SQL scripts optimized for scalability and performance
  • Create dimensional data models, database views, and materialized views
  • Develop and automate data workflows using Informatica PowerCenter and/or Informatica IICS
  • Collaborate with architects, developers, analysts, and stakeholders to design optimal data solutions
  • Participate in sprint planning, standups, retrospectives, and other Agile ceremonies
  • Conduct validation, testing, troubleshooting, and performance optimization
  • Produce technical documentation, diagrams, specifications, and mapping documents
What we offer
What we offer
  • Medical, dental, and vision coverage
  • Life and disability insurance
  • Additional voluntary benefits
  • Fulltime
Read More
Arrow Right

Sap Data Analyst - Data Migration

Location
Location
Canada , Calgary
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
August 15, 2026
Flip Icon
Requirements
Requirements
  • 3–7 years of professional experience in data analysis or data migration roles, specifically within large-scale SAP or ERP transformation programs
  • Proven experience supporting SAP data migration projects (ECC to S/4HANA path is highly preferred)
  • Hands-on experience using SAP BODS (or equivalent enterprise ETL tools) alongside MS Power BI for dashboard development
  • Advanced Excel skills (pivots, VLOOKUPs/XLOOKUPs, data profiling filters) with a demonstrable history of producing clear data quality and exception reports
  • Solid familiarity with SAP ECC and S/4HANA data tables, master data characteristics, and relational dependencies
  • Thorough understanding of data profiling, mapping, cleansing, validation, and reconciliation frameworks
  • Experience navigating full mock runs, defect triage, re-runs, and cutover readiness activities
  • Detail-Oriented
  • Excellent communication skills
  • Strong organizational and time management skills
Job Responsibility
Job Responsibility
  • Support end-to-end data migration activities transferring data from SAP ECC and other legacy source systems to SAP S/4HANA
  • Analyze source system data to thoroughly assess completeness, accuracy, and technical readiness
  • Maintain and update critical data migration artifacts, including Source-to-Target mappings, data validation rules, transformation logic, and comprehensive data object/structure documentation
  • Develop a deep operational understanding of business process data sets across ECC, S/4HANA, and integrated peripheral systems
  • Execute and support data migration mock cycles (Mock 1, Mock 2, etc.) including re-runs and stabilization activities
  • Analyze migration run results, manage data defects, and drive exceptions through to final resolution
  • Produce, review, and validate data quality reports, exception logs, and reconciliation results to support go/no-go data readiness assessments
  • Collaborate closely with Data Stewards to review, validate, and support hands-on data cleansing outcomes and remediation planning
  • Identify recurring data quality trends and contribute directly to root-cause analysis
  • Provide functional oversight and unit testing for data migration objects built in SAP BODS
Read More
Arrow Right

Data Engineer - Data Integration

Data Engineer - Data Integration, IBM Corporation, Armonk, NY and various unanti...
Location
Location
United States , Armonk, NY and various unanticipated client sites throughout the US
Salary
Salary:
167835.00 - 216700.00 USD / Year
nytimes.com Logo
The New York Times
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Master's degree or equivalent in Computer Science or related (employer will accept a bachelor's degree plus five (5) years of progressive experience in lieu of a master's degree) and one (1) year of experience as a Data Engineer or related
  • One (1) year of experience must include utilizing Google Cloud Platform (Google Big Query, Cloud Storage, Google Looker), Procedural language/Structured Query Language (PL/SQL), Informatica, DataStage, Data Integration, Data Warehousing, Database Design / Modelling, Data Visualization (Power BI/ Crystal reports)
Job Responsibility
Job Responsibility
  • Manage the end-to-end delivery of data migration projects, implementing ETL/ELT concepts and leveraging ETL tools such as Informatica and DataStage, and cloud platforms like Google Cloud
  • Design and build end-to-end data pipelines to extract, integrate, transform, and load data from diverse source systems into target environments such as databases, data warehouses, or data marts
  • Collaborate with clients to define data mapping and transformation rules, ensuring accurate application prior to loading
  • Normalize data and establish relational structures to support system migrations
  • Develop processes for data cleaning, filtering, aggregation, and augmentation to maintain data integrity
  • Implement validation checks and data quality controls to ensure accuracy and consistency across systems
  • Create, maintain, and optimize SQL procedures, functions, triggers, and ETL/ELT processes
  • Develop, debug, and maintain ETL jobs while applying query optimization techniques - such as indexing, clustering, partitioning, and use of analytical functions - to enhance performance on large datasets
  • Partner with data analysts, data scientists, and business stakeholders to understand requirements and ensure delivery of the right data
  • Capture fallouts and prepare reports using Excel, Power BI, Looker, Crystal Reports, etc
  • Fulltime
Read More
Arrow Right
New

Data Analyst

We are looking for a Data Analyst to join a non-profit organization in a contrac...
Location
Location
United States , Centreville
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience in data analysis with a strong background in building and maintaining data pipelines or integration workflows
  • Working knowledge of ETL or ELT development, SQL, stored procedures, and data transformation techniques
  • Ability to identify data issues, perform root-cause analysis, and implement controls that improve data accuracy
  • Familiarity with data warehousing, data lakes, and performance tuning for databases or reporting environments
  • Experience supporting business intelligence reporting with reliable datasets for tools such as Power BI or Tableau
  • Understanding of data governance, security practices, and retention requirements in a structured environment
  • Exposure to modern cloud data platforms such as Azure Data Factory, Synapse, Snowflake, Databricks, or related technologies
  • Knowledge of fraud analytics, fraud investigation, anti-fraud practices, or suspected fraud analysis is valued
Job Responsibility
Job Responsibility
  • Develop and support data integration workflows that move information from internal systems, cloud environments, and external applications into centralized reporting platforms
  • Create, refine, and maintain scalable data pipelines that deliver accurate and timely datasets for analytics, operational reporting, and business intelligence tools
  • Investigate data inconsistencies, resolve processing issues, and establish validation checks to improve reliability and integrity across data assets
  • Contribute to data warehouse and data lake efforts by shaping transformation rules, supporting data models, and improving overall processing performance
  • Partner with stakeholders to understand reporting and analytical needs, then translate those needs into efficient and sustainable data solutions
  • Prepare and maintain clear technical documentation covering data mappings, process logic, workflow design, and integration steps
  • Enhance database and query performance while supporting scheduling, automation, and operational stability for recurring data jobs
  • Provide dependable data support for visualization and reporting platforms such as Power BI, Tableau, and similar business intelligence tools
  • Participate in data migration, application integration, and master data management initiatives as part of broader enterprise data projects
  • Help uphold data governance, security, and retention standards across integration and reporting processes
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • 401(k) plan
Read More
Arrow Right

Data Analyst

We are seeking a detail-oriented Data Analyst to join our Data & AI team. In thi...
Location
Location
Bulgaria , Sofia; Varna
Salary
Salary:
Not provided
mypos.com Logo
myPOS
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proven experience (3-5 years) in data analytics, process-oriented or a similar role
  • Proficiency in PowerBI (dashboards and extensive DAX experience), SQL, excellent knowledge of MS Excel
  • Working knowledge of data modeling and ETL processes
  • Ability to interpret complex data sets and translate them into clear, actionable insights that support operational performance and business growth
  • Solid understanding of business strategies, market trends, and how data can be leveraged to optimise outcomes
  • Ability to analyse data to improve customer satisfaction and create seamless customer experience
  • Familiarity with data lakes, data warehouses and cloud platforms (preferably GCP)
  • Strong stakeholder management skills with the ability to effectively communicate data insights to non-technical audiences and leadership team
  • Bachelor’s degree in Business, Data Science, Economics, or a related field
Job Responsibility
Job Responsibility
  • Analyse operational data to identify trends, inefficiencies, and opportunities
  • Build and maintain interactive dashboards and automated reports using PowerBI
  • Leverage understanding of database design, data modeling principles, and SQL to structure data effectively
  • Identify manual processes and propose data-driven automation solutions
  • Analyse historical performance data to support workforce and capacity planning
  • Collaborate with data engineers or independently design efficient ETL processes
  • Perform on-demand analysis to support urgent business questions
  • Work with diverse business teams to understand analytical needs, translate them into technical requirements
  • Lead BI projects from conception to completion
  • Monitor data integrity across systems
What we offer
What we offer
  • Vibrant international team operating in hi-tech environment
  • Annual salary reviews, promotions and performance bonuses
  • myPOS Academy for upskilling and training
  • Unlimited access to courses on LinkedIn Learning
  • Annual individual training and development budget
  • Refer a friend bonus
  • Teambuilding, social activities and networks on a multi-national level
  • Excellent compensation package
  • 25 days annual paid leave (+1 day per year up to 30)
  • Full Luxury package health insurance including dental care and optical glasses
  • Fulltime
Read More
Arrow Right

QA Lead – Integration & Systems Testing

Our client is seeking an experienced QA Lead – Integration & Systems Testing to ...
Location
Location
Canada , Toronto
Salary
Salary:
Not provided
myticas.com Logo
Myticas Consulting
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of Quality Assurance experience
  • Minimum 2 years leading QA teams or QA strategy
  • Strong experience testing System Integrations
  • REST APIs
  • ETL Pipelines
  • Event-driven architectures
  • Experience with Postman
  • RestAssured (or similar)
  • Kafka / messaging platforms
  • SQL data validation
Job Responsibility
Job Responsibility
  • Define and own the end-to-end QA strategy for functional, integration, regression, and non-functional testing
  • Design test scenarios for APIs, ETL processes, Kafka event streams, and AWS Lambda integrations
  • Lead QA activities across SIT, UAT, regression, and production readiness
  • Develop traceability between business requirements, test cases, and defects
  • Validate source-to-target data mapping and data integrity across integration points
  • Manage test environments, test data, and entry/exit criteria
  • Partner with Business Analysts, Technical Leads, and Project Managers to identify quality risks early
  • Manage defect lifecycle using Jira, Zephyr, or similar tools
  • Fulltime
Read More
Arrow Right