Consumers Energy SR DATA ENGINEER in Adrian|Allegan|Alma|Armada|Athens|Bad Axe|Battle Creek|Bay City|Bellevue|Benzonia|Big Rapids|Birch Run|Boyne City|Bronson|Cadillac|Caro|Charlevoix|Charlotte|Cheboygan|Clare|Clinton Township|Covert|Dearborn|East Tawas|Erie|Essexville|Filer City|Flint|Fremo, 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 Marketing Intelligence Data Science team provides innovative advanced analytic support to Consumers Energy’s Customer Experience department, especially Marketing. The support includes ad-hoc analysis, building predictive and prescriptive analytical models, generating actionable insights, and data migration.
The Marketing Intelligence Data Science team is looking for a senior level data engineer whose aim is to work hands-on in designing, transforming and creating data architectures for the machine learning solutions we build. Every mission we’ll embark on will have concrete deliverables and deadlines. This means you will have a variety of engagements across different product teams such as Energy Services, Demand Side Management, and Energy Waste Reduction. You will build, curate, and manage various customer data sets that will be used for advanced analytics.
Build critical data processing pipelines to solve ambitious challenges integrating our SAP and Azure eco-system
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, Scala, Python 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
This position will be in Royal Oak, MI. but the candidate will be able to work remotely on a permanent basis.
Bachelor’s degree in Computer Science, IT, Engineering, Mathematics or related field or equivalent combination of education & experience
5+ years overall business experience
5+ years’ experience with SQL, NoSQL, PySpark, Python
2+ years’ experience with ETL and scheduling technologies and data pipelining (e.g. Azure Data Factory, Informatica, Apache)
Experience with relational databases (e.g. SQL server, Oracle, SAP HANA, MemSQL)
Preferred: The following skills will set you apart
Strong experience with DevOps/Git repository code promotion and change management experience
2+ years overall experience with data engineering and data warehousing on Azure Data Lake, Blob Storage, Data Bricks
Nice to have PowerBI dashboarding experience
Ability to express humility and patience
Strong communication skills with strong attention to detail
Self-starter and intellectually curious
Experience in Agile philosophy or scrum methodology a plus
Utility or e-commerce experience a plus
Must be a fit with our team culture
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
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: 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.
Position will be filled at the appropriate salary grade based upon the skills, knowledge, and experience of the selected candidate.
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.