Lead Developer/ETL Developer III
Lead Developer/ETL Developer III
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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:
- PowerShell Analysis: Ability to decode and analyze 62 PowerShell scripts clearly identifying workflows dependencies and logic.
- Technical Documentation: Strong ability to document workflows processes and dependencies supported by examples of their own work.
Employment Type
Full Time
