Senior SSIS/ETL Developer

Overview

Allied Consultants, Inc is a proudly Austin based firm with over 33 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Senior SSIS/ETL Developer to play a key role within a high-impact technical services team.

 

At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:

• Highly competitive pay rates
• Local support staff for responsive, personal service
• Comprehensive benefits package, including:
  • Medical insurance (with employer cost sharing)
  • Life insurance
  • A 401(K) plan with company match
  • Flexible spending through a cafeteria plan

Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.

 

Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Responsibilities

**Location of job: Remote**

 

Major responsibilities include performing highly advanced (senior-level) SSIS development (packages, configurations, parameterization, error handling, logging) and equally advanced data analysis and documentation to move and validate critical agency data among SQL Server, Oracle, Snowflake, and mainframe sources. Requires strong SSIS design, configuration management (Azure DevOps/Git), SQL Server/Oracle/Snowflake skills, and knowledge of data warehouse/ETL design including incremental/CDC patterns, data quality and reconciliation, and report validation. The candidate will review existing bridges, propose performance/reliability improvements, and communicate technical findings to technical and non-technical stakeholders. Awareness of the broader stack (Informatica, MuleSoft, COBOL, Java, Salesforce, C#/.NET Core, Oracle, Snowflake, GoAnywhere) is beneficial. 

 

Other responsibilities may include coordination of or performing requested research and the analysis required for work proposals, software and systems modifications, and new projects. Overseeing the analysis, designs, plans, diagrams, and verifying procedures for existing and proposed applications. Provides technical advice, assistance, and recommendations in matters related to programming operations and problems, including Production issues.

 

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).

Maintain organi