Join the diverse and dynamic team that powers Michigan's largest energy provider and one of the nation's largest gas and electric combination utilities. Consumers Energy services 6.7 million of Michigan's 10 million residents - caring for our friends and neighbors in all 68 Lower Peninsula counties. We embrace a cleaner and leaner utility vision focused on eliminating energy waste and adding renewable energy from sources such as wind and solar.
At Consumers Energy, we offer more than just a place to work. We foster a culture that supports career development, growth, and stability, and we take pride in offering our co-workers excellent benefits and compensation packages. We are deliberately creating an inclusive culture that makes our diverse team of co-workers feel valued, supported, and empowered every day. We're a company made up of thousands of people, all with different stories to share and work to do, but we stand united in our company purpose: world class performance delivering hometown service.
DEPARTMENT SUMMARY
The Customer Analytics team provides analytic support to Consumers Energy's Customer Operations and Customer Experience Organizations. This support includes ad hoc analysis, Analytics Models, impact analysis, metric ownership, automation, and data migration.
JOB DESCRIPTION/RESPONSIBILITIES
The Customer Data Analyticsteam is looking for a data engineerwhose aim isto work hands-on in designing, transforming, and creating data architectures for the machine learning solutions we build. This means you will have a variety of engagements across different customer teams in the company. You will build, curate, and manage various customer data sets that will be used for advanced analytics.
Responsibilities:
Build critical data processing pipelines to solve ambitious challenges integrating our SAP and various systems.
Collect data from various systems such as SAP ECC, SAP BW and feed into Azure based Core Data Lake
Collaborate with Data Scientists to design scalable implementations of their models
Leverage various continuous delivery practices to deploy, support and operate data pipelines
Advise and educate teammates on how to use Hadoop based distributed storage and cloud computing technologies
Seamlessly incorporate and identify data quality, data reliability, efficiency into your day-to-day work as well as into the delivery process
Write scripts to pull data from internal and external data sources to feed into our data lake with version control
Write database queries using SQL, NoSQL, PySpark, Python, R and other tools to extract and cleanse data to be used as a stand-alone deliverable or used in downstream processes
Advocate your data engineering expertise to the team, speaking at leadership meetings and acting as a mentor for more junior-level data engineers
REQUIREMENTS/QUALIFICIATIONS
Bachelor's degree in Computer Science, IT, Engineering, Mathematics or related field or equivalent combination of education & experience (8 years)
5+ years overall business experience
5+ years' experience withSQL, NoSQL, PySpark, Python, R
2+ years' experience with ETL and scheduling technologies and data pipelining (e.g. Azure Data Factory, Informatica, Apache)
2+ years overall experiencewith data engineering and data warehousing
Experience with relational databases (e.g. SQL server, Oracle, SAP HANA, MemSQL)
Strong communication skills with strong attention to detail
Self-starter and intellectually curious
Proficient with DevOps/Git repository code promotion and change management experience
Preferred:
PowerBI dashboarding experience
Experience in Agile philosophy or scrum methodology
Utility or e-commerce experience a plus
ESSENTIAL FUNCTIONS
Conducts a variety of standard and complex analytical functions: Data mining and cleansing, use case identification and implementation, data analysis, trending and forecasting, predictive modeling, machine learning, visual management creation and communication, statistical research; recommending and implementing modifications to processes, policies, and procedures. Collects, compiles, and analyzes information from various sources on a variety of topics, including operational, performance, budget, and risk analysis. Participates in the development of the corporate and departmental goals; maintains analytical toolsets; implements adjustments as necessary. Prepares executive level reporting, presentations, summaries, and correspondence; creates comprehensive technical records and reports; Prepares staff reporting for presentation to the Board of Directors; Performs cost benefit evaluations of proposed use cases; makes determinations related to the overall benefit of use cases and alternatives; implements policies and procedures accordingly; provides ad-hoc reporting; ensures a high level of accountability on all projects; Performs long-range analytics development planning; forecasts the impacts of potential future events; provides responsible, accurate, and thorough technical and administrative project support to executive leaders; operates variety of office equipment. Observes safe work practices and safety methods; performs other duties as assigned. Regular attendance is expected.
HOURS AND TRAVEL
This position will require a minimum of 40 hours per week spent in an office and/or remote.
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.