This position has opportunities to work in a virtual/onsite hybrid work environment. Consumers Energy has facilities all around the state of Michigan (Lower Peninsula only). Candidate must be located within 60 miles of a Consumers Energy Service Center OR willing to relocate.
General Summary
Typically employees in this job are required to design or maintain technology systems, to utilize various computer software programs, and to design, develop and/or provide advice and counsel on the processes and procedures the software supports. This role includes Application Development, Infrastructure, Information Security, and Architecture.
May have supervisory responsibility for non-exempt employees or contractors; limited budgetary responsibility or impact (in both size and scope). Leadership skills are developing; day-to-day supervisory activities are evaluated on a frequent basis by area/department management.
Essential Functions
Works closely with department managers and users to define and analyze business and operational problems, process improvement opportunities and requirements
Uses operational and business mandates and legal requirements
Identifies and analyzes complex, ambiguous and/or conflicting business process issues
Advises department managers on applications development, enhancement and maintenance issues
Explains technology and process options and assists managers in analysis and decision making
Analyzes management information needs and recommends data and reporting processes
Coordinates the development of department priorities and works within IT to align initiatives to these priorities
Facilitates user meetings and joint development sessions
Works with users to reengineer work processes
Analyzes functional business requirements and translates user expectations into detailed business requirements, specifications and success criteria; works with managers to develop conceptual proposals for business process automation initiatives
Recommends work process and/or operational changes to complement system functionalities
Serves as an advocate for department needs with IT
Stays abreast of developments in departmental processes to anticipate emerging technology needs
Develops significant application/hardware solutions to problems
Analyzes and troubleshoots complex and sometimes urgent applications problems and errors
Takes action or communicates solutions to problems
Answers technical questions and provides guidance to users on system functionalities and methods for correcting problems
Data analytics and Reporting
Use data from various sources (SQL Server, spreadsheets, JSON, etc) to build reports to be used by the business. Tools used for these reports include but are not limited to Python, SQL Server Mgmt Studio, Excel, and Power BI
Software Development including Coding/Programming
Coding and reviewing software/web development using VB .Net, SQL, Python, VBA, JavaScript, and HTML/CSS as well as developing JSON REST and SOAP services with other business partners including IT / SAP
Software Troubleshooting
Replicate and identify bugs as reported by users in production or testing environments, communicate the issue, and resolve them
Technical Support to the business
Support the users when they are finding it difficult to understand how the software and technology works from a technical and business standpoint
Requirements/Qualifications
Bachelor’s degree in Computer Science, Engineering, Statistics, or Mathematics
At least 1 year of applicable experience
Experience in lieu of education will be considered (9+ years)
Ability to independently evaluate, select & apply information technology theory.
Knowledge and/or experience in utility operations
Excellent communication skills
Ability to solve a range of straightforward problems
Basic knowledge of SQL, Python, C#, .NET, and similar programming languages