SSIS Developer/Systems Analyst

Overview

Remote
$90 - $100
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

ssis
system analyst
etl
azure
data factory
snowflake

Job Details

Essential Job Duties

  • SSIS / ETL ( 50%)
    • Design, develop, and maintain automated ETL solutions with Microsoft SSIS (project/deployment model, configurations, parameterization, robust error handling and logging).
    • Orchestrate data movement between SQL Server, Oracle, and Snowflake; where appropriate, integrate Azure Data Factory/Informatica and file automation (e.g., GoAnywhere/MuleSoft).
    • Implement CDC/incremental patterns; tune performance via staging/partitioning, set-based SQL, and workload scheduling to meet SLAs.
    • Follow change management and code migration processes (Azure DevOps/Git); promote from Dev Test/QA Prod with auditable approvals.
    • Troubleshoot build/run failures; create runbooks; monitor and optimize ETL runtimes and job dependencies.
  • System Analyst ( 50%)
    • Elicit and document data & reporting requirements (KPIs, filters, delivery cadence) and translate into functional/data specifications.
    • Produce and maintain S2T mappings, business rules, data dictionaries, and lineage/flow diagrams (current future state) spanning staging, integration, and presentation/reporting layers.
    • Define and execute data quality and reconciliation controls (row counts, checksums/hashes, referential integrity, threshold/exception reports); validate loads back to sources (SQL Server/Oracle/mainframe).
    • Support UAT for data changes/reports (test scenarios, expected results, sign-offs); coordinate remediation and re-tests.
    • Review database/report performance and suggest alternatives (indexing/partitioning/materialized views, pre-aggregations) to meet SLA and usability goals.
    • Communicate progress/risks/issues promptly; mentor junior staff; coordinate with SMEs, DBAs, ETL engineers, and reporting teams (Power BI/SSRS).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.