ETL Developer III - ETLDEV 0514 NP#01

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
No Travel Required

Skills

Writing
Reverse Engineering
Scripting
Stored Procedures
System Integration
Operational Excellence
Knowledge Transfer
Transact-SQL
Windows PowerShell
Pivotal
Project Delivery
Management
Mentorship
Microsoft SQL Server
Microsoft SSIS
Performance Tuning
Database
Database Architecture
Documentation
ERD
Extract
Transform
Load
.NET
Analytical Skill
Application Development
C#
Data Flow
Data Integration
Scalability
Systems Design
Technical Writing
Workflow
ETL

Job Details

Job Title: ETL Developer III
Location: Phoenix, AZ

Position Overview: A leading organization is seeking a highly experienced Senior IT Contractor to take on a critical role in automation, data integration, and technical documentation. This position requires a minimum of 10 years of experience and deep expertise in PowerShell scripting, SQL Server, SSIS, and application development. The successful candidate will not only contribute to project delivery but also play a pivotal role in knowledge transfer and documentation of complex systems and workflows.

Key Responsibilities:

  • Develop and maintain PowerShell automation scripts across 60+ interconnected workflows.

  • Design and optimize SQL Server databases, including stored procedures, performance tuning, and advanced query writing.

  • Build and maintain robust SSIS packages to support scalable and reliable ETL processes.

  • Contribute to application development, focusing on backend logic and automation enablement using platforms like .NET or C#.

  • Mentor team members and technical leads to foster code quality, technical understanding, and operational excellence.

  • Lead the creation and maintenance of comprehensive technical documentation including:

    • Entity Relationship Diagrams (ERDs) representing detailed data models and schema structures.

    • Workflow and dependency mappings for all PowerShell scripts, including triggers, data flows, and system integration points.

    • System design documents, deployment guides, process diagrams, and runbooks.

  • Promote best practices in documentation to ensure system scalability, transparency, and long-term supportability.

Required Skills & Experience:

  • Extensive hands-on expertise in PowerShell scripting with the ability to manage and document large-scale automation.

  • Strong proficiency in SQL Server, including T-SQL, database architecture, and ERD creation.

  • Solid experience with SSIS and end-to-end data pipeline design.

  • Proficient in application development with technologies such as .NET and C#.

  • Proven experience mentoring developers or leading technical teams.

  • Outstanding technical writing skills, especially in documenting undocumented or complex systems.

  • Strong analytical skills to reverse-engineer existing systems and create clear, maintainable documentation.

  • Minimum of 10 years of relevant professional experience.

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.