Consumers Energy IT Data Analyst in Multiple Locations, Michigan
Join a diverse and dynamic team that makes and delivers the most valuable services in the world: electricity and natural gas. At Consumers Energy, our customers are at the heart of everything we do. Our employees work around the clock to provide service to our customers in honor of our history and to fulfill our promise to Michigan - Count on Us! Consumers Energy, the principal subsidiary of CMS Energy and headquartered in Jackson, Michigan, provides natural gas and electricity to nearly 6.8 million of Michigan's 10 million residents in all 68 Lower Peninsula counties.
The IT Regulatory, Financial & Performance team is looking for a data analyst to collaborate with co-workers to collect and analyze data for the IT organization to support rate case filings and strategic financial data-driven decisions. The person who fills this role will have the opportunity to engage across different teams within the IT organization and company to improve quality and efficiency of data. This role will build, analyze and manage various financial data sets that will be used for analysis and regulatory filings.
Acquire data from primary or secondary data sources and maintain database/data systems
Maintain and implement database changes, data collection and other strategies that optimize efficiency and quality of data
Interpret data, analyze results using various techniques, provide visualizations and ongoing reports
Maintain and implement data governance best practices
Bachelor’s Degree in Science, Mathematics, Statistics, or related field or equivalent experience.
Strong analytical and problem-solving skills with the ability to collect, organize, analyze, and disseminate information with attention to detail and accuracy
Proficiency in Microsoft Excel
Ability to access, read, interpret, and execute SQL and Python code
Reporting and data visualization skills using software like Tableau, PowerBI
Knowledge of data management best practices
Ability to QA and troubleshoot data
Strong verbal and written communication skills
Ability to set and meet deadlines
Ability to fit in our Company culture
Works closely with department managers, co-workers, and peers to define and analyze business and operational problems, process improvement opportunities and requirements; analyzes operational and business mandates and legal requirements; identifies and analyzes complex, ambiguous and/or conflicting business process issues; advises department leaders on technology related projects; 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. Develops and refines business models and relationship diagrams; evaluates methods of improving efficiency and cost effectiveness of business, technical and operational processes; 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 Information Systems 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. Participates in the development of statements of work for RFPs/RFIs; participates in evaluating vendor applications and solutions; coordinates department review of vendor deliverables for accuracy and completeness, ensuring that department needs and requirements have been met. Develops significant application/hardware solutions to problems and addresses change request issues that require assignment of resources. Analyzes and troubleshoots complex 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. Develops training materials and handouts; conducts user applications training classes and one-on-one training sessions; develops and maintains user documentation. Designs and generates custom reports to meet user needs; uses reporting tools to extract user-required data. Plans and coordinates the deployment of new technologies for client solutions; coordinates user acceptance testing and the resolution of problems identified. Regular attendance is expected.
Hours and Travel
Meet travel requirements of the position. Work a flexible schedule, which may include evenings, weekends, holidays and overtime.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, stand, walk, stoop, kneel, crouch, crawl, and use hands to finger, handle, or feel objects. The employee frequently is required to talk or hear. The employee must lift and move up to twenty pounds. Specific vision abilities required by this job include close vision, color vision, depth perception, and the ability to adjust focus. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate.
All qualified applicants will not be discriminated against and will receive consideration for employment without regard to protected veteran status, disability, race, color, religion, sex, sexual orientation, gender identity or national origin.