Contract Powershell Developer Jobs in Iowa (NOW HIRING)

Job Description

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations.

Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants.

Hollstadt Consulting is an equal opportunity employer including disability/veteran.

Role

Data Migration Developer

Location

Hybrid - Las Vegas, NV

Contract

6 months (extensions as needed)

Rate

$65/hour W2

Position Summary

The Data Migration Developer will support the integration program by designing, developing, and executing automated data conversion and migration solutions. This role is primarily focused on Passenger Service System migration activities, including data analysis, mapping, transformation, validation, and reconciliation between legacy and target platforms.

Working closely with business, IT, integration, and vendor teams, the developer will create repeatable migration processes, conversion utilities, and validation tools that enable accurate, traceable, and efficient movement of critical airline data. Additional work may extend to airline operational platforms such as crew, maintenance, flight operations, loyalty, and other enterprise systems.

Primary Focus

• Passenger Service System data conversion and migration

Program Context

• Integration

Core Technologies

• Microsoft SQL Server, T-SQL, SSIS or comparable ETL tooling, PowerShell, source control

Likely Data Domains

• Customers, reservations, inventory, schedules, fares, fees, ancillaries, loyalty, and operational reference data

Working Model

• Hands-on development role supporting analysis, automation, testing, cutover, and reconciliation

Data Analysis and Mapping

• Analyze source and target system data structures, schemas, interfaces, and business rules.
• Develop source-to-target mapping documents and transformation specifications.
• Perform data profiling, quality assessments, and gap analysis.
• Work with business and technical stakeholders to define migration requirements and conversion logic.

Data Migration Development

• Design, develop, and support automated data migration and conversion processes.
• Create and optimize SQL scripts, stored procedures, ETL processes, and migration utilities.
• Develop repeatable migration frameworks supporting multiple test and production migration cycles.
• Automate transformation, cleansing, enrichment, and validation activities.

Validation and Reconciliation

• Develop automated reconciliation and data quality checks.
• Validate migration accuracy, completeness, and data integrity.
• Investigate and resolve migration defects, exceptions, and discrepancies.
• Support testing activities, including mock conversions and user acceptance testing.

Integration and Cutover Support

• Participate in migration planning, rehearsals, and production cutover activities.
• Collaborate with application teams, vendors, and project stakeholders to resolve data issues.
• Support documentation, runbooks, and migration readiness reviews.

Required Qualifications

• 5+ years of experience in data migration, database development, ETL, or systems integration.
• Advanced SQL and Microsoft SQL Server development experience.
• Strong experience with T-SQL, stored procedures, views, functions, query optimization, data modeling, and performance tuning.
• Experience developing ETL or ELT solutions and data transformation processes.
• Experience with SQL Server Integration Services or comparable ETL tooling.
• Experience developing automation using SQL, PowerShell, Python, or similar technologies.
• Strong understanding of data mapping, data quality, validation, and reconciliation techniques.
• Excellent analytical, troubleshooting, verbal communication, and written communication skills.

Preferred Qualifications

• Experience with airline technology platforms and airline data models.
• Experience supporting Passenger Service Systems, preferably Navitaire New Skies or a similar reservation platform.
• Experience supporting mergers, acquisitions, or large-scale enterprise integration programs.
• Experience migrating reservation, customer, loyalty, inventory, fare, ancillary, and operational data.
• Experience with Azure SQL, Azure Data Factory, Microsoft Fabric, Power BI, MongoDB, REST APIs, or Azure DevOps.
• Familiarity with airline operational systems such as maintenance, crew scheduling, flight operations, and loyalty platforms.

Technical Skills Required

• Microsoft SQL Server
• T-SQL
• SQL Server Management Studio
• SSIS
• ETL/ELT Development
• Data Modeling
• Data Reconciliation
• Git / Source Control
• PowerShell

Preferred

• Azure SQL
• Power BI
• Python
• MongoDB
• REST APIs
• Azure DevOps

Success Measures

• Deliver automated, repeatable migration processes.
• Achieve high levels of migration accuracy and reconciliation.
• Reduce manual effort through automation.
• Successfully support PSS and airline operational system migration activities.
• Produce high-quality migration documentation, validation evidence, and cutover support artifacts.

Benefits

• Medical
• Dental
• Vision
• Life insurance
• Short-term disability
• Long-term disability
• Paid sick leave
• Retirement benefits

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

We appreciate and reward loyalty

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we’ll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we’ll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team – so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.