What are the responsibilities and job description for the ETL developer position at Keanesoft?
Job Details
Job Title: ETL Developer III
Duration: Long term
Location: Phoenix, Arizona (Need locals)
Hybrid
Primary Skills : SQL, PowerShell, application, SSIS, T-SQL
Job Description:
Position Description
Job Overview: We are seeking a seasoned Senior IT Contractor (no less than 10 years of experience) with expert-level skills in PowerShell automation, SQL Server databases, SSIS integration, and application development. This role places a strong emphasis on 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, with a special focus on: o Comprehensive Entity Relationship Diagrams (ERDs) reflecting data models, relationships, and schema structures. o Full workflow and dependency overviews for 60 PowerShell scripts, clearly mapping triggers, data flow, and integration points. o System design documents, deployment guides, process diagrams, and support runbooks. Promote and enforce documentation standards to ensure future scalability and supportability of enterprise systems.
Skills Required:
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.
Experience Required:
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. No less than 10 years of experience.
Regards,
Krishna
Business Development Lead
| IT Ideology |
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.
