Talent.com
Senior SSIS Developer / Data Integration Analyst

Senior SSIS Developer / Data Integration Analyst

MaddisoftAustin, TX, Texas, USA
1 day ago
Job type
  • Full-time
Job description

Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. - U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Looking for W2 CONTRACT, Send in resume along with LinkedIn profile without which applications will not be considered. Call us NOW!

  • Visa sponsorship is available for this position.

Job Title : Senior SSIS Developer / Data Integration Analyst

Location : Remote

Job Description

The Senior SSIS Developer / Data Integration Analyst will perform highly advanced ETL development, data analysis, and documentation to move, validate, and reconcile data across SQL Server, Oracle, Snowflake, and mainframe systems. This role requires expertise in SSIS (SQL Server Integration Services) , data warehousing , and ETL architecture , including incremental / CDC patterns , data quality , and report validation .

The candidate will design and maintain SSIS packages, optimize data workflows, ensure data integrity, and collaborate across teams to improve system performance and reliability.

Essential Job Duties

SSIS / ETL (≈50%)

  • Design, develop, and maintain automated ETL solutions using Microsoft SSIS (project / deployment model, configurations, parameterization, error handling, logging).
  • Orchestrate data movement between SQL Server , Oracle , and Snowflake ; integrate with Azure Data Factory , Informatica , and file automation tools like GoAnywhere / MuleSoft as needed.
  • Implement CDC / incremental patterns and tune performance using staging, partitioning, and set-based SQL to meet SLAs.
  • Follow established change management and code migration processes using Azure DevOps / Git ; promote code through Dev → Test / QA → Prod environments with audit trails.
  • Troubleshoot build / run failures; create runbooks ; monitor and optimize ETL runtimes and job dependencies.

    • System Analysis (≈50%)

  • Elicit and document data and reporting requirements (KPIs, filters, delivery cadence) and translate them into functional / data specifications.
  • Produce and maintain source-to-target mappings (S2T) , business rules, data dictionaries, and lineage / flow diagrams covering staging, integration, and reporting layers.
  • Define and execute data quality and reconciliation controls (row counts, checksums, referential integrity, threshold / exception reports).
  • Validate data loads against source systems ( SQL Server, Oracle, mainframe ).
  • Support UAT for data and reporting changes — create test scenarios, expected results, coordinate remediation, and retesting.
  • Review database / report performance and suggest alternatives (indexing, partitioning, materialized views, pre-aggregations).
  • Communicate progress, risks, and issues clearly; mentor junior staff; collaborate with SMEs, DBAs, ETL engineers, and reporting teams (Power BI / SSRS).
  • Maintain audit-ready documentation in SharePoint, Confluence, or Azure DevOps.

    • Additional Responsibilities

  • Develop automated ETL solutions using Microsoft SSIS and Oracle platforms .
  • Analyze application functionality and interpret project requirements to create technical specifications for ETL development.
  • Determine database requirements by analyzing business operations, reviewing objectives, and evaluating current systems.
  • Establish and follow development standards (coding, documentation, testing) to ensure maintainable and high-quality solutions.
  • Collaborate with business stakeholders to align development efforts with business needs.
  • Lead the development and maintenance of technical documentation ensuring completeness and clarity.
  • Ensure project schedules are met and communicate delays or risks proactively.
  • Follow change management and deployment processes.
  • Mentor junior staff in ETL development, testing, and deployment.
  • Collaborate with other developers and analysts on solution design and testing.
  • Apply best practices in data warehouse design and database optimization.
  • Review and assess all database change requests for potential downstream effects on ETLs.
  • Consult data dictionaries to identify dependencies and ensure metadata accuracy.
  • Review and optimize database performance ; suggest alternative solutions as needed.
  • Create and maintain technical process and interface documentation as part of ongoing release efforts.
  • Review work from others, troubleshoot issues, and provide feedback to ensure on-time delivery.
  • Promote code from development to production environments.
  • Use GitHub or equivalent version control systems effectively.
  • Experience with Oil & Gas systems and working with state agencies is a plus.
  • Perform related work as assigned.
    • Create a job alert for this search

    Senior Data Analyst • Austin, TX, Texas, USA

    Related jobs
    • Promoted
    Senior Data Analyst

    Senior Data Analyst

    SafeLeaseAustin, TX, US
    Full-time
    SafeLease is an insurance technology company that specializes in commercial real estate.We focus on insurance products for the self-storage industry but are rapidly expanding our suite of services....Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Analyst - Client Facing

    Senior Data Analyst - Client Facing

    EverlywellAustin, TX, US
    Full-time
    Everly Health's mission is to transform lives with modern, diagnostics-driven care, and we believe that the future of healthcare is meeting people where they are. Headquartered in Austin, Texas,...Show moreLast updated: 13 days ago
    • Promoted
    Delivery Driver - Get Paid Today!

    Delivery Driver - Get Paid Today!

    Favor DeliveryElgin, TX, US
    Full-time
    Favor is Texas’ hometown food delivery app—born and bred right here, and proudly part of the H-E-B family.Are you ready to help your neighbors get grocery staples, warm meals, refreshin...Show moreLast updated: 2 days ago
    • Promoted
    Survey Taker : Earn up to $25 per survey (Remote)

    Survey Taker : Earn up to $25 per survey (Remote)

    Earn HausLockhart, TX, US
    Remote
    Full-time +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...Show moreLast updated: 1 day ago
    • Promoted
    Information Technology Professional

    Information Technology Professional

    U.S. NavyBuda, TX, US
    Full-time +1
    To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.At any given moment, hundreds of complex networked computer systems are operating in tandem to keep ships and su...Show moreLast updated: 1 day ago
    • Promoted
    CT Tech

    CT Tech

    AscensionKyle, TX, US
    Full-time
    Full time Day 40 hours (Monday - Friday 8 : 00 a.Ascension Seton Medical Center Hays.Various health insurance options & wellness plans. Retirement benefits including employer match plans.Long-term & s...Show moreLast updated: 14 days ago
    • Promoted
    • New!
    Amazon Delivery Driver - Flexible Shifts - Earn $15.00 - $20.00 / hr

    Amazon Delivery Driver - Flexible Shifts - Earn $15.00 - $20.00 / hr

    Amazon FlexManchaca, TX, US
    Full-time
    Amazon delivery partner opportunity – Earn $15.It's simple! Use your vehicle and smartphone to earn extra money delivering with a brand you trust. With Amazon Flex, you only deliver when y...Show moreLast updated: 19 hours ago
    • Promoted
    Senior Data Analyst – Product Analytics (Ref : 192376)

    Senior Data Analyst – Product Analytics (Ref : 192376)

    Forsyth BarnesAustin, Texas Metropolitan Area, United States
    Full-time
    Senior Data Analyst – Product Analytics.Up to $150K USD Base + Benefits.Digital Consumer / Marketplace.We are seeking a Senior Data Analyst to join a high-impact Product Analytics team within a fas...Show moreLast updated: 6 days ago
    • Promoted
    Senior Systems Analyst

    Senior Systems Analyst

    Contact Government Services, LLCAustin, TX, US
    Full-time
    Employment Type : Full Time, Senior-level.Department : Information Technology.CGS is seeking a Senior Systems Analyst to join our team supporting a wide-ranging technical support initiative for a lar...Show moreLast updated: 13 days ago
    • Promoted
    Delivery Driver - Flexible Schedule

    Delivery Driver - Flexible Schedule

    DoorDashLeander, TX, United States
    Full-time +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...Show moreLast updated: 30+ days ago
    • Promoted
    Delivery Driver

    Delivery Driver

    DoorDashLeander, TX, United States
    Full-time +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...Show moreLast updated: 30+ days ago
    • Promoted
    Center Standards Officer (200502)

    Center Standards Officer (200502)

    Job CorpsSan Marcos, TX, US
    Full-time
    Responsible for providing oversight and direction for the Center Standards team.Ensures the accurate administration of the Center's Behavior Management System to ensure PRH compliance.Provides ...Show moreLast updated: 30+ days ago
    • Promoted
    Online Survey Participant : Work Remote and Earn Up To $25 Per Survey

    Online Survey Participant : Work Remote and Earn Up To $25 Per Survey

    Earn HausElgin, TX, US
    Remote
    Full-time +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...Show moreLast updated: 1 day ago
    • Promoted
    Senior Data Analyst

    Senior Data Analyst

    El Buen SamaritanoAustin, TX, US
    Full-time
    For more than 35 years, El Buen Samaritano has been a trusted community resource for Latino immigrant families and other underserved communities in Central Texas. Through food access, health literac...Show moreLast updated: 13 days ago
    • Promoted
    Moms Ultimate Job : Earn Up to $75,000+ from Home as a Surrogate!

    Moms Ultimate Job : Earn Up to $75,000+ from Home as a Surrogate!

    Physician's SurrogacyBastrop, TX, US
    Full-time +2
    Earn up to $75,000 as a stay-at-home mom or as a second job.Sign up today and earn $1,200 bonus.What qualities make you a great Surrogate?. Experienced no complications during your own pregnancy.Hea...Show moreLast updated: 1 day ago
    • Promoted
    Support Specialist for Data Entry Administrative Assistant

    Support Specialist for Data Entry Administrative Assistant

    United Global TechnologiesTaylor, TX, US
    Full-time
    Support Specialist for HEAVY data entry, administration, schedules, meetings, minutes, and even some project coordination is helpful. Interfaces with Market Participants regularly for project update...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Systems Analyst

    Senior Systems Analyst

    VisaAustin, TX, US
    Full-time
    Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more t...Show moreLast updated: 30+ days ago
    • Promoted
    Lead Specialist Inbound Leads (Strong English Fluency Required)

    Lead Specialist Inbound Leads (Strong English Fluency Required)

    CENTRAL TEXAS CLIMATE CONTROL INCLeander, TX, US
    Full-time
    Are you a motivated communicator who thrives on results and loves turning leads into booked appointments or closed deals? Join one of the fastest-growing HVAC teams in Central Texas and help homeow...Show moreLast updated: 28 days ago