Share this Job

DATA ENGINEER

Date: Nov 5, 2021

Location: JACKSON, MI, US

Company: Consumers Energy

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 Analytics team is looking for a data engineer whose aim is to 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 with SQL, 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 experience with 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.


Nearest Major Market: Jackson Michigan
Nearest Secondary Market: Ann Arbor

Job Segment: Database, Engineer, ERP, Oracle, Computer Science, Technology, Engineering