Job Description
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 SUMMARYThe 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.JOB DESCRIPTION/RESPONSIBILITIESThe 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-systemCollect data from various systems such as SAP ECC, SAP BW and feed into Azure based Core Data LakeCollaborate with Data Scientists to design scalable implementations of their modelsLeverage various continuous delivery practices to deploy, support and operate data pipelinesAdvise and educate teammates on how to use Hadoop based distributed storage and cloud computing technologiesSeamlessly incorporate and identify data quality, data reliability, efficiency into your day-to-day work as well as into the delivery processWrite scripts to pull data from internal and external data sources to feed into our data lake with version controlWrite 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 engineersThis position will be in Royal Oak, MI. but the candidate will be able to work remotely on a permanent basis.REQUIREMENTS/QUALIFICIATIONS•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, Python2+ 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 apartStrong experience with DevOps/Git repository code promotion and change management experience2+ years overall experience with data engineering and data warehousing on Azure Data Lake, Blob Storage, Data BricksNice to have PowerBI dashboarding experienceAbility to express humility and patienceStrong communication skills with strong attention to detailSelf-starter and intellectually curiousExperience in Agile philosophy or scrum methodology a plusUtility or e-commerce experience a plusMust be a fit with our team cultureESSENTIAL FUNCTIONSConducts 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 TRAVELMeet travel requirements of the position. Work a flexible schedule, which may include evenings, weekends, holidays and overtime.PHYSICAL DEMANDSThe 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... For full info follow application link.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.