Senior Data Integration Specialist

1 week ago


Austin, Texas, United States Assyst Full time

Job Overview

">

We are seeking an experienced ETL Developer to join our team in Austin, Texas. As a key member of our data analytics team, you will design, develop, and maintain ETL processes for enterprise-level data solutions.

Responsibilities

  • Develop mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
  • Automate data acquisition and integration from multiple data sources, including Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF.
  • Transform source data to fit into a dimensional model and create efficient database views/materialized views in Oracle.
  • Work with the Data Engineering Team to design and implement optimal data models and acquisition strategies.
  • Collaborate with architects and team members to implement designs, resolve technical problems, and validate solutions.
  • Participate in requirements and design sessions to interpret and address new business needs.
  • Design and develop complex, fast, and efficient SQL scripts to transform and integrate data.
  • Verify and validate SQL scripts, database views, and ETL workflows.
  • Develop automated solutions for testing, verification, and validation.
  • Actively participate in Agile sprint ceremonies, including backlog grooming, sprint planning, and retrospectives.
  • Utilize Agile methodologies to deliver iterative solutions.
  • Use tools like JIRA to manage sprint tasks and progress.
  • Enhance and maintain a Java-based web application providing Tableau dashboards.
  • Design and implement mockups for user validation.
  • Develop dashboards and reports using Tableau, connecting to external data sources.
  • Produce and maintain technical documentation, diagrams, and specifications.
  • Support and enhance the data integration hub infrastructure.
  • Assist with the implementation and configuration of development tools.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.
  • 8+ years of experience developing ETL mappings and workflows using Informatica IICS, IDMC, or Power Center.
  • Strong SQL scripting skills and experience designing efficient, complex SQL scripts.
  • Proven experience acquiring and integrating data from diverse sources for use in data visualization tools like Tableau.
  • Hands-on experience designing and developing scripts using Python.
  • Strong analytical skills and experience as a system analyst for data analytics, performance management, or data warehousing projects.
  • Ability to troubleshoot and resolve ETL and data integration issues effectively.
  • Proficiency with technical writing and diagramming tools like Visio and Erwin.
  • Experience working in Agile sprint teams and familiarity with JIRA software.
  • Advanced knowledge of Microsoft Office Suite (Word, Excel, PowerPoint) and MS Project.
  • Experience in planning and delivering software platforms across multiple organizational units.
  • Strong oral and written communication skills.

Estimated Salary Range: $120,000 - $150,000 per year

Location: Austin, Texas



  • Austin, Texas, United States MMC Group LP Full time

    Job OverviewWe are seeking an experienced Data Integration Specialist to join our team at MMC Group LP. As a key member of our data analytics team, you will be responsible for designing and developing complex data integration solutions using Informatica IICS and Power Center.About the RoleEstimated Salary: $120,000 - $180,000 per year, depending on...


  • Austin, Texas, United States Unreal Gigs Full time

    Senior Data Analytics Specialist Job SummaryWe are looking for an experienced Senior Data Analytics Specialist to lead our data science initiatives at Unreal Gigs. This role comes with a salary of $120,000 per year.Responsibilities:Advanced Data Techniques and Tools:Utilize advanced machine learning techniques, such as ensemble methods, time-series analysis,...


  • Austin, Texas, United States Bickham Services Unlimited, LLC Full time

    Job Title: Data Integration Specialist Location: Austin, TX (Hybrid - 4 days remote, 1 day on-site on Tuesdays) Type: Full-Time Contract Duration: 8 months Schedule: Monday to Friday, 8:00 AM - 5:00 PM Estimated Salary: $120,000 per yearAbout the Role:Lead the design, development, and implementation of a data integration hub.Support ETL processes, data...


  • Austin, Texas, United States Humana Full time

    About the RoleWe are seeking an experienced Senior Data Quality/Integrity Engineer to join our Quality Systems Integration (QSI) team at Humana, Inc. This key role will involve leveraging expertise in clinical data, market trends, and healthcare to develop and execute a comprehensive supplemental and lab data strategy.Key responsibilities include developing...


  • Austin, Texas, United States BEPC Inc. - Business Excellence Professional Consulting Full time

    BECPC is seeking an experienced Cloud Data Integration Specialist to join our team in Austin, TX.The successful candidate will have a strong background in SQL, PL/SQL, and cloud technologies, with expertise in Snowflake administration and data warehousing concepts.We offer a competitive salary of $88/hour, plus benefits including medical, dental, vision, and...


  • Austin, Texas, United States Saxon Global Full time

    About Saxon GlobalWe are a leading provider of integration solutions, and we're looking for a skilled professional to join our team.Job DescriptionWe're seeking an experienced Senior Integration Solutions Specialist to design, implement, and maintain complex integration solutions using the MuleSoft Anypoint Platform. The ideal candidate will have a strong...


  • Austin, Texas, United States DirectViz Solutions Full time

    Job SummaryWe are seeking a Senior Integration Specialist to support our program and project activities through technical analyses, reviews, and process improvements. As a key member of our team, you will play a crucial role in ensuring the successful integration of our systems.About DirectViz SolutionsDirectViz Solutions is a rapidly growing government...


  • Austin, Texas, United States Bickham Services Unlimited, LLC Full time

    **Job Title:** Senior IT Systems Specialist**Location:** Remote, Texas**Estimated Salary:** $120,000 - $160,000 per yearWe are seeking a skilled Senior IT Systems Specialist to support the migration of integrated resident information systems (IRIS) to a new SaaS solution. The ideal candidate will play a critical role in analyzing business needs, designing...


  • Austin, Texas, United States SysMind Tech Full time

    Job DescriptionSysMind Tech is seeking a highly skilled Senior Enterprise Integration Specialist to join our team.About the RoleWe are looking for an experienced professional with a strong background in enterprise application integration, Mendix development, and business process management. The ideal candidate will have a deep understanding of integration...


  • Austin, Texas, United States Saxon Global Full time

    Job Title:Senior Data Protection SpecialistAbout the Role:We are seeking a highly skilled Data Protection Specialist to join our team at Saxon Global. As a key member of our organization, you will be responsible for designing and implementing data protection solutions across various industries.Key Responsibilities:Design and implement data protection...


  • Austin, Texas, United States Diverse Lynx Full time

    Job DescriptionIn this Senior Tableau CRM Developer with Data Integration Focus role, you will be responsible for connecting Tableau CRM to various data sources, performing data cleaning, transformation, and preparation for analysis, and designing and developing interactive dashboards and reports. You will also be required to customize Tableau CRM...


  • Austin, Texas, United States Indotronix International Corporation Full time

    Job RequirementsWe are seeking a highly skilled Senior Big Data Specialist to join our team at Indotronix International Corporation. The ideal candidate will have extensive experience in designing, developing, and maintaining large-scale big data systems.Key requirements include:8+ years of experience in data engineering, data science, or a related...


  • Austin, Texas, United States Pinnacle Group Full time

    Pinnacle Group is a leading consulting firm seeking a skilled Senior Data Science Specialist to join our team. As a key member of our data science group, you will work on a wide range of projects, from predictive modeling to data visualization.This is a full-time position with a competitive salary of $72.50 per hour, plus benefits including medical, dental,...


  • Austin, Texas, United States Siri InfoSolutions Inc Full time

    About UsSiri InfoSolutions Inc is a leading provider of innovative solutions in the field of finance and accounting.Job SummaryWe are seeking an experienced Senior SAP Vertex Integration Specialist to join our team. As a key member of our team, you will be responsible for designing, implementing, and maintaining complex SAP FI and Vertex integrations.Key...


  • Austin, Texas, United States ShiftCode Analytics Full time

    About Our CompanyShiftCode Analytics is a forward-thinking organization that uses data-driven insights to drive innovation.We are currently seeking an experienced Senior Big Data Specialist to join our team and help us build the next generation of data systems.Job OverviewThe successful candidate will have a deep understanding of big data technologies,...


  • Austin, Texas, United States The Dignify Solutions LLC Full time

    Job Title: Data Integration ProfessionalJob Summary:The Dignify Solutions LLC is seeking an experienced Data Integration Professional to join our team. As a key member of our implementation team, you will work closely with clients to design, build, and implement data integration solutions using Anaplan. Your expertise in data integration, business analytics,...


  • Austin, Texas, United States V Group Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Data Solutions Specialist to join our team at V Group Inc. in Austin, TX. This is a contract position with a minimum duration of 8 months.Job SummaryThe successful candidate will have extensive experience in database administration and data warehousing, as well as strong knowledge of business intelligence...

  • Data Architect

    2 days ago


    Austin, Texas, United States Futran Tech Solutions Pvt. Ltd. Full time

    Data Architect - Big Data SpecialistFutran Tech Solutions Pvt. Ltd. seeks an experienced Data Architect to spearhead the design and implementation of our big data strategy. This senior-level position requires a deep understanding of big data technologies, including relational databases, NoSQL databases, and data warehouses. The successful candidate will have...


  • Austin, Texas, United States Brookdale Senior Living Full time

    Company OverviewBROOKDALE SENIOR LIVING is a leader in senior care, providing a supportive and engaging environment for our residents. We are committed to making lives better, including your own.Salary$14.50 - $18.12 per hourJob DescriptionWe are seeking a compassionate and dedicated Senior Care Specialist to join our team at Brookdale Senior Living. As a...


  • Austin, Texas, United States Futran Tech Solutions Pvt. Ltd. Full time

    Senior Data Solutions Specialist Job DescriptionWe are seeking a highly experienced Senior Data Solutions Specialist to join our team at Futran Tech Solutions Pvt. Ltd. As a Senior Data Solutions Specialist, you will be responsible for designing, developing, and implementing scalable and reliable data solutions to support our business needs.Compensation...