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

Systems Analyst 3

Understands business objectives and problems, identifies alternative solutions, ...
Location
Location
United States , Austin
Salary
Salary:
Not provided
honorvettech.com Logo
HonorVet Technologies
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS.
  • Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.
  • Experience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient
  • Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
  • Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
  • Experience in planning and delivering software platforms used across multiple products and organizational units.
  • Proven ability to write well designed, testable, efficient code by using best software development practices
Job Responsibility
Job Responsibility
  • Filling the role of a technical leader, leading an agile development team through a project.
  • Data acquisition from a variety of data sources for multiple uses.
  • Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle.
  • Developing automation with Informatica Power Center/IICS to pull data from external data sources and transform it to fit into a dimensional model.
  • Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design.
  • Verification and validation of SQL scripts, Informatica automation and database views.
  • Developing automated means of performing verification and validation.
  • Participating in all sprint ceremonies
  • Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies.
  • Develop mockups and work with customers for validation
Read More
Arrow Right

Data Analyst

Data Analyst position in the Asset Management team at METLEN Energy & Metals, fo...
Location
Location
Salary
Salary:
Not provided
https://www.metlengroup.com Logo
Metlen Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Data Science, Statistics, Computer Science, Renewable Energy, or related field
  • Master's preferred
  • Minimum 3 years' experience as a Data Analyst in renewables or utilities
  • Solid understanding of solar plants and BESS systems, including monitoring, design, and performance metrics
  • Strong Python skills for data analysis, ETL pipelines, and modeling
  • Proficient in Power BI and Excel for data visualization and reporting
  • Experience with predictive analytics or machine learning is a plus
  • Detail-oriented with strong problem-solving and communication skills
  • Able to work independently and collaboratively with cross-functional teams
  • Fluent in English
Job Responsibility
Job Responsibility
  • Monitor plant performance and operational status through SCADA systems
  • Collect, process, and analyse data from solar plants, BESS, and HV substations
  • Develop and maintain dashboards and reports using Power BI or similar tools
  • Design APIs for data integration from external platforms
  • Analyse KPIs to track energy efficiency, performance, and cost-effectiveness
  • Identify and resolve data discrepancies, ensuring data accuracy and integrity
  • Prepare clear reports and visual insights for technical and non-technical stakeholders
  • Collaborate with engineers, operations managers, and other teams to align data with business and regulatory requirements
What we offer
What we offer
  • Competitive Salary & Benefits package
  • Cooperation, creativity and innovation: we adopt flexible cooperation models to achieve fast results and increased productivity
Read More
Arrow Right

Data Analyst

As a Data Analyst at 1X, you will play a central role in building the data infra...
Location
Location
United States , Hayward
Salary
Salary:
110000.00 - 165000.00 USD / Year
1x.tech Logo
1X Technologies
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Industrial Engineering, Manufacturing Engineering, Supply Chain, Data Science, or a related field
  • 2–5+ years of experience in manufacturing, operations, or analytics roles
  • Strong SQL skills, along with one or more scripting languages (Python, R), and experience working with APIs
  • Experience with data visualization tools (e.g., Power BI, Tableau, Looker, Retool, Sigma)
  • Strong understanding of manufacturing or supply chain data structures (work orders, BOMs, routings, inventory, purchase orders)
  • Leadership capabilities and ability to deliver independently and communicate with executives
  • Familiarity with data pipelines and ETL tools (Airbyte, dbt, Fivetran, Airflow, or similar) is a plus
Job Responsibility
Job Responsibility
  • Develop and maintain dashboards and reports to monitor manufacturing, supply chain, and inventory KPIs (e.g., OEE, yield, cycle time, material variance, on-time delivery, supplier performance)
  • Write SQL and Python scripts to clean, aggregate, and model data for analysis and visualization
  • Partner with operations leaders to define metrics and data models that reflect real-world production processes
  • Identify automation opportunities across the supply chain (e.g., data syncs, quality alerts, order tracking)
  • Ensure data accuracy and governance, supporting digital traceability and manufacturing genealogy
  • Collaborate with IT and software teams to integrate data sources and deploy analytics tools (Power BI, Sigma, Looker, or similar)
  • Support ad-hoc analyses to drive continuous improvement projects and cost-reduction initiatives
  • Build ETL data pipelines to extract data from ERP/MRP, MES, and inventory systems (e.g., Odoo or custom databases)
What we offer
What we offer
  • Health, dental, and vision insurance
  • 401(k) with company match
  • Paid time off and holidays
  • Fulltime
Read More
Arrow Right

Ts/sci cleared data management analyst

Tecolote is seeking a TS/SCI Cleared Data Management Analyst to be part of a tea...
Location
Location
United States , Washington
Salary
Salary:
70000.00 - 140000.00 USD / Year
tecolote.com Logo
Tecolote Research
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • BA/BS in Mathematics, Computer Science, Information Technology or similar
  • CompTIA Security+
  • 5 + years of programming experience, 2 years may be used for a master’s degree
  • Excellent written/verbal communication, analytical, and coding skills
  • Familiar with process documentation, and error reporting
  • Software integration onto network systems
  • SQL servers, in particular table generation, data ingestions, stored procedure manipulation, and front-end integration
  • Cybersecurity and system hardening
  • DoD IT systems
  • SQL, Python, Java
Job Responsibility
Job Responsibility
  • Work with the design team to create a viable system architecture for future research and decision support
  • Assist in daily back end error resolutions
  • Standard business processes of databasing and ETL functions
  • Work with IT team to implement cybersecurity policy
  • Conduct system scanning and regular metrics reporting
  • Recommend system improvements
What we offer
What we offer
  • Company Paid Major Medical Insurance for employees and family members
  • Dental Insurance for employees and family members
  • Vision Insurance for employees (employee-paid for family members)
  • Group Life Insurance
  • Accidental Death and Dismemberment Insurance
  • Travel Accident Insurance
  • Long-Term Disability
  • Voluntary Short-Term Disability
  • Supplemental Life Insurance
  • Flexible Spending Account (pre-tax deferrals for health care expenses)
  • Fulltime
Read More
Arrow Right

Data Analyst

Analyze and configure computer systems management and integrate functions, workf...
Location
Location
United States , Piscataway
Salary
Salary:
Not provided
itlize.com Logo
Itlize Global
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Master’s degree in Science, Technology, or Engineering (any) is required.
Job Responsibility
Job Responsibility
  • Analyze and configure computer systems management and integrate functions, workflow
  • Automate and setup AWS S3 lifecycle
  • Create scorecards and dashboards utilizing stack bars, bar graphs, scattered plots, and geographical maps
  • Develop data ETL pipeline using SSIS, Python and ODI
  • Migrate SQL Server database backup and output files to AWS S3 using AWS CLI
  • Design rich data visualizations to model data with Tableau
What we offer
What we offer
  • Referring employee will be eligible to receive an award of $1000.00 for the successful referral
Read More
Arrow Right

Senior Data Engineer ETL Lead

The Sr Data Engineer ETL Lead is a senior level position responsible for establi...
Location
Location
United States , Irving
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of relevant experience in Apps Development or systems analysis role
  • Extensive experience system analysis and in programming of software applications
  • Experience in managing and implementing successful projects
  • Subject Matter Expert (SME) in at least one area of Applications Development
  • Ability to adjust priorities quickly as circumstances dictate
  • Demonstrated leadership and project management skills
  • Consistently demonstrates clear and concise written and verbal communication
  • Bachelor’s degree in Computer Science or equivalent /University degree or equivalent experience
  • Data Warehouse/ETL design and development methodologies knowledge and experience required
  • ETL expertise on AbInitio tool (EME, GDE, Co-op) bringing together all components like Unix, Oracle, Storage
Job Responsibility
Job Responsibility
  • Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
  • Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
  • Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
  • Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
  • Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
  • Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
  • Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
What we offer
What we offer
  • Medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • paid time off packages including vacation, sick leave and paid holidays
  • Fulltime
Read More
Arrow Right

Data Architect

Logic Loops is currently seeking a Data Architect to join our team in Norfolk, V...
Location
Location
United States , Norfolk
Salary
Salary:
Not provided
logic-loops.com Logo
Logic Loops
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years working across one or more relevant industries
  • Expertise in application data architecture and supporting implementation
  • Data migration planning project experience
  • Source to target mapping
  • 3+ years of experience working with ETL/ELT for data migration
  • Understanding of enterprise service bus architectures and rest services
  • Integration of data using a publish/subscribe model
  • 3+ years involvement in the design of bi-directional data movement (front bridge/back bridge)
  • Past or current experience in ETL development using Informatica and/or Microsoft SSIS
  • Subject area data modeling for OLTP, normalized models, domains
Job Responsibility
Job Responsibility
  • Gather project data requirements with business analysts
  • Determine data migration, application data, and data feed requirements
  • Design ETL
  • Develop data flow and models to support data feeds, geospatial
  • Integration, data migration, and application data dictionary
  • Develop data dictionary and classification and publish to metadata with analysts
  • Assist in building a library for common terms and definitions in coordination with business analysts
  • Collaborate with enterprise architects, analysts, and project management
  • Analyze the automation scripts and evaluate their test data dependencies
  • Determine the best solution for each script
Read More
Arrow Right

Technical Business Analyst

The Technical Business Analyst (TBA) serves as the vital bridge between business...
Location
Location
India , Chennai
Salary
Salary:
Not provided
toppanmerrill.com Logo
Toppan Merrill
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3-5 years of experience as a Technical Business Analyst in IT development or data-driven environments
  • Strong understanding of ETL concepts and system integration
  • Hands-on experience with SQL, REST/SOAP APIs, JSON/XML, and data analysis
  • Familiarity with Agile/Scrum methodologies and tools such as Jira, Confluence, or Azure DevOps
  • Knowledge of UML, BPM tools, data warehousing and data governance/data quality frameworks
  • Excellent analytical, problem-solving, and critical-thinking abilities
  • Strong communication skills for both technical and non-technical audiences
  • High attention to detail with the ability to manage multiple priorities
  • Strong ownership mindset and accountability for deliverables
  • Flexibility to work during US business hours, including late evenings
Job Responsibility
Job Responsibility
  • Collaborate with business stakeholders to gather, analyze, and document requirements, user stories, and acceptance criteria
  • Translate complex business needs into detailed functional and technical specifications
  • Work with solution architects and developers to design scalable and secure systems
  • Develop process models, data flow diagrams, interface specifications, and integration mappings
  • Identify opportunities to optimize and automate data and ETL processes
  • Perform detailed analysis of data flows, ETL pipelines, and system integrations
  • Support data migration, API design, and integration initiatives
  • Configure and maintain ETL tools/platforms to support business requirements and data integration needs
  • Monitor and troubleshoot ETL jobs, ensuring data accuracy and integrity
  • Develop and maintain documentation for ETL workflows, mappings, and transformations
  • Fulltime
Read More
Arrow Right