Lead Developer/ETL Developer III

Job Title: Senior Lead Developer/ETL Developer III

Location: [Maricopa, Arizona] (Local Candidates Only)

Experience Level: Senior (10+ years)

Job Overview:

We are seeking a seasoned Senior IT Contractor with approximately 10 years of experience, specializing in PowerShell automation, SQL Server databases, SSIS integration, and application development. This role emphasizes mentorship, technical documentation, and system transparency, particularly around complex automation environments and data structures. The ideal candidate will support both delivery and knowledge transfer while documenting an extensive portfolio of PowerShell workflows and backend systems.

Key Responsibilities:

• Develop, maintain, and optimize PowerShell scripts across a broad range of infrastructure and data automation tasks, covering over 60+ workflows and their interdependencies.
• Design, implement, and tune SQL Server databases, including writing stored procedures, optimizing queries, and managing performance.
• Create and maintain SSIS packages for ETL operations, ensuring data integrity and scalability across integrated systems.
• Support application development, contributing to backend logic, system integration, and automation enablement.
• Mentor technical leads and team members, fostering a culture of code quality, system understanding, and operational excellence.
• Lead the development of technical documentation, focusing on:
  • Comprehensive Entity Relationship Diagrams (ERDs) reflecting data models, relationships, and schema structures.
  • Full workflow and dependency overviews for 60+ PowerShell scripts, clearly mapping triggers, data flow, and integration points.
  • System design documents, deployment guides, process diagrams, and support runbooks.
• Promote and enforce documentation standards to ensure future scalability and supportability of enterprise systems.

Required Skills & Experience:

• Deep expertise in PowerShell scripting, with a proven ability to document and manage large-scale automation environments.
• Strong SQL Server experience, including T-SQL, schema design, performance tuning, and ERD creation.
• Solid background in SSIS development and data pipeline design.
• Application development skills in .NET, C#, or equivalent platforms.
• Demonstrated experience mentoring developers or technical leads.
• Exceptional technical writing and documentation skills, particularly in workflow mapping and data modeling.
• Ability to analyze and reverse-engineer undocumented systems and translate them into clear, maintainable documentation.

Focus Areas:

1. PowerShell Analysis: Ability to decode and analyze 62+ PowerShell scripts, clearly identifying workflows, dependencies, and logic.
2. Technical Documentation: Strong ability to document workflows, processes, and dependencies, supported by examples of their own work.