Share this Job

Data Engineer(Remote in MI)

Date: Apr 29, 2021

Location: Livonia, MI, US

Company: Consumers Energy

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.

 

DEPARTMENT SUMMARY

The Sales Strategy & Performance team, as part of Sales Operations, provides advanced analytic support to Consumers Energy’s Customer Experience department, especially Commercial & Industrial Sales department.  The support includes performance management, target establishment, forecasting, visual management development and process improvements.

 

JOB DESCRIPTION/RESPONSIBILITIES

The role is responsible for developing, maintaining, managing and executing on critical and accurate visual management used by the Business Customer Care organization, and provides efficient and effective counter measures to identified gaps utilizing their problem-solving skills. This includes sales/business reporting, business intelligence, business analytics, early detection of gaps, and accurate forecasting. This role is the primary business point of contact, book of proof, for reporting data inquires, and sales analytics management.   Additionally, the role is responsible to oversee the metrics and provide performance reporting to sales professionals, sales leadership, and organizational targets. The role provides the team guidance with data entry standards and reporting within the CRM, as well as resolving technical issues, acting as liaison between Sales and IT to request and implement system/data changes, and answering Sales data requests. The position partners with external and internal teams including Marketing, Products, Customer Strategy, Data & Performance to understand their goals and identify ongoing performance improvements through complex data extracts and quantitative analyses.  A key component of the role includes passion around modeling (sales & financial), and leveraging technology including CRM or alternative tools, to drive efficiencies, growth, and customer experience.

This position will be in Livonia, MI., but the candidate will be able to work remotely.

 

Required Qualifications:

  • Bachelor’s degree in Computer Science, IT, Engineering, Mathematics, Statistics or related field or equivalent combination of education & experience
  • 3+ years overall relevant business experience related to business/financial reporting
  • 3+ years’ experience with relational databases (e.g. SQL server, Oracle, SAP HANA, MemSQL)
  • Work experience with MS Power BI or equivalent visual management software
  • Working knowledge of Microsoft Dynamics, SAP, eTracker (or similar), and other system extracts
  • Work experience with MS Office (Excel, PowerPoint, Word) 
     
     
    Preferred Qualifications:
     
  • Advanced degree
  • 2+ years overall experience with data engineering and data warehousing
  • Ability to express humility and patience
  • Strong communication skills with strong attention to detail
  • Self-starter and intellectually curious
  • Utility or e-commerce experience a plus
  • Must be a fit with our team culture
     
     
    ESSENTIAL FUNCTIONS
  • Identify risk, gaps, and opportunities to business goals and strategies
  • Leverage technology to deliver world class service
  • Strong Problem-Solving identification and resolution skills
  • Superior data analysis
  • Identify business opportunities - business acumen
  • Builds a strong knowledge of the business, internal and external trends
  • Effective communicator and writer
  • Validation of strategic and tactical plans
  • Teamwork internally and externally
  • Daily report out
  • Root cause analysis and counter measures
  • Any other duties and projects to support sales operations and performance
     

 

HOURS AND TRAVEL

Meet travel requirements of the position. Work a flexible schedule, which may include evenings, weekends, holidays, and overtime.

 

 

PHYSICAL DEMANDS

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: drive, sit, stand, walk, stoop, kneel, crouch, crawl, and use hands to finger, handle, or feel objects. The employee frequently is required to talk and hear.   The employee must lift and move up to twenty pounds. The recommended maximum weight for employees to lift without the aid of other employees or a lifting device is 35 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.


Nearest Major Market: Livonia
Nearest Secondary Market: Detroit

Job Segment: Database, Engineer, ERP, Oracle, Sales Operations, Technology, Engineering, Sales