Programmer Analyst

Macomb County Government

1d

About The Position

Under direction, this position partners with customers and IT team members to identify and implement technology solutions that improve business processes. The role evaluates, designs, develops, tests, debugs, documents and maintains programs while installing and supporting system application software for customers. The position manages multiple projects within complex systems and may serve as the primary resource for those systems or for an entire small system. The successful candidate maintains strong knowledge of current development methodologies and programming techniques and applies that expertise to create innovative, effective solutions.

Requirements

• Associate’s Degree from an accredited college or university in Computer Science, Management Information Systems or a directly related field
• One (1) year SQL database experience
• Possession of a valid Michigan driver’s license and operable, insured automobile for authorized travel
• Maintain compliance with all applicable Criminal Justice Information Services (CJIS) Security Policy and Health Insurance Portability and Accountability Act (HIPAA) requirements, including successful completion of background checks, trainings, and periodic recertifications, as a condition of continued employment
• Knowledge of: Current application & web development, database, infrastructure and networking standards as well as associated industry trends
• Web based technologies and standards
• Change control process and adherence to it
• Security standards including data encryption, Zero Trust principles, and least privileged access
• Web Accessibility Guidelines Overview (WCAG) standards
• Skill in: Building solutions with Microsoft 365 and Power Platform (Power Apps, Power Automate, Power BI, Dataverse) and SharePoint Online
• SQL, SQL Procedures, Microsoft .NET and .NET Core frameworks, C# and ASP.NET (MVC), Visual Studio and Visual Studio Code, SQL Server, SSMS, SSIS, SSRS, PowerShell, Git or Azure DevOps for source control and CI/CD
• Designing and implementing API based integrations (REST/SOAP), batch processing, and ETL/data pipelines, SSIS, Microsoft Graph API, Web API
• Technical aptitude, including the ability to think logically during problem resolution, root cause analysis and corrective actions
• Communication, problem resolution and follow-through skills
• Ability to: Work proactively, both independently and within cross-functional IT team, to resolve problems and communicate effectively with customers and department staff
• Navigate complex business scenarios and define solutions with customers to deliver business value
• Think strategically and drive solutions that are cost justified and show measurable business value
• Use interpersonal skills that foster a team, cooperative and service-oriented environment
• Maintain knowledge of information technology through attendance of seminars, workshops and other mediums to stay current and drive new solutions
• Establish and maintain effective service-oriented relationships with co-workers, elected officials, Executive’s Office, department heads, vendors and the public
• Document clear and concise procedural documentation
• Mentor peers and other supporting team members
• Support continuous improvement by identifying opportunities to enhance systems and operational needs
• Adhere to Information Technology policies and procedures
• Work in an environment which embraces the county’s Dignity Campaign
• Effectively speak, write and understand the English language
• Understand and carry out oral and/or written instructions
• Accurately organize and maintain paper documents and electronic files
• Maintain the confidentiality of information and professional boundaries
• Work independently

Nice To Haves

• Bachelor’s degree from an accredited college or university in Computer Science, Management Information Systems or a directly related field
• Knowledge of Microsoft .NET and .NET Core frameworks, C# and ASP.NET (MVC, Web API), Visual Studio and Visual Studio Code, SQL Server, SSMS, SSI, SSRS, Power Platform (Power Apps, Power Automate, Power BI, Dataverse), Git or Azure DevOps for source control and CI/CD, Microsoft Graph API, PowerShell, and SharePoint Online
• Knowledge and understanding of Web based technologies and standards
• Effectively speak, write and understand a language other than English is preferred

Responsibilities

• Designs, develops, installs and maintains application systems (in-house developed and vendor supplied) in multiple environments, including web applications.
• Analyzes and documents the organization’s current systems and processes during the design phase, as well as anticipates future needs.
• Consults with stakeholders, participants and IT team members to fully understand business requirements and define technical requirements.
• Translates business requirements into optimized, user-friendly technical solutions, working with clients and IT staff to review, design, and validate system needs.
• Provides sound estimates for anticipated time to be spent using technical resources.
• Works independently, and with minimal supervision, to provide quality production support for both in-house developed and vendor-supplied applications.
• Provides quality and timely problem resolution and status information to maintain systems.
• Supports efficient business operations and customer relationships including at times being on-call for programs and systems.
• Develops quality applications/systems, reflecting minimal defects, delivering to specifications, with an intuitive and friendly user interface and compliance with IT application standards.
• Prepares application/system specifications for approval by users, vendors and technical staff, under guidance from senior team members.
• Develops and maintains appropriate system documentation to illustrate design, architecture, source code, installation, and FAQs.
• Facilitates team walk-throughs for design, code and system performance reviews.
• Develops and executes comprehensive test plans and test cases.
• Conducts unit, system/volume and regression testing, developing and maintaining test script, test cases and defect resolutions.
• Improves software through enhancements and ensures that systems evolve as technology changes, including redesign when necessary.
• Develops methodologies and structured programming techniques, such as application and interface designs.
• Maintains familiarity with system business functions and customer goals in order to ensure optimal system solutions are designed for customers.
• Identifies process improvements and submits suggestions to supervisor or other management team members.
• Ensures compliance with departmental policies and standards for production turnover, documentation format, development methodology, programming standards, tools and related procedures, hardware and software installation processes and standards.
• Operates an automobile to perform assigned job functions.
• Performs related duties as assigned.

Benefits

• As part of our total benefit package, Macomb County proudly offers medical, dental, and vision coverage, with no monthly premium to employees for single, two (2) person or family coverage.
• Health care, dental and vision benefits are effective the first day of employment.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree