Job Location: Lansing, MI (Hybrid – 2 days onsite)
Note: Candidates must be currently local within a commutable distance to Lansing, MI, as interviews will be conducted in person.
---
Job Description:
The State of Michigan is seeking an experienced PowerBuilder Developer and IT Analyst with expertise in PowerBuilder (version 7 or higher), T-SQL query writing, and data management for Sybase and MS SQL Server databases. The ideal candidate should have strong skills in source control technologies (TFS/Azure DevOps, Git) and be capable of handling unit testing, documentation, testing, production support, and change management.
Key Responsibilities:
- PowerBuilder Development – Modify and maintain PowerBuilder source code to analyze and document application data processes.
- T-SQL Query Writing – Write and optimize complex queries to extract and manipulate data for Sybase and MS SQL Server databases.
- Data Management – Perform data profiling, mapping, validation, and analysis to ensure data integrity and support data migration.
Source Control Management – Work with TFS/Azure DevOps or Git to maintain version control and track changes.
Unit Testing & Documentation – Conduct unit tests, document test cases, and update system specifications to support program modifications.
Testing & Production Support – Collaborate with business analysts and clients to support testing scenarios and resolve production issues by performing root cause analysis.
Change Management – Follow change control procedures to implement and manage application updates efficiently.
---
Requirements
Required Skills & Experience:
PowerBuilder Development (version 7 or higher) – 5+ years
T-SQL Query Writing (Sybase/MS SQL Server) – 10+ years
Data Management (profiling, mapping, validation, analysis) – 10+ years
Source Control (TFS/Azure DevOps, Git) – 5+ years
Unit Testing & Documentation – 10+ years
Testing & Production Support – 5+ years
Change Management – 5+ years
---
Minimum Qualifications:
Some college education in Computer Science, IT, Computer Engineering, or related fields
Experience working in a hybrid office environment
Willingness to learn and adapt to new technologies
---
This role requires a strong understanding of database management, system design patterns, and best practices in software development. The candidate must possess excellent troubleshooting skills and be able to communicate technical concepts effectively with both technical and business teams.