Principal Strategy Database Specialist - Utility (Data Reporting, Extraction- SQL, Python, DAX & Visualization - Power BI)

Overview

Lead data mining, analytics, and CRM strategy for utility customers

Key Responsibilities

• data mining
• predictive modeling
• crm database
• data warehouse
• forecasting
• strategic planning

Tasks

-Manage, support, and perform customer intelligence analyses, campaign targeting/segmentation strategies, campaign response analyses, and analytic strategies for corporate research and customer relationship management initiatives. -Analyze customer transactional data using advanced data mining techniques in support of process improvement initiatives using tools such as SPSS or SAS. -Advise, plan and collaborate with directors, managers, business specialists and analysts by accessing and analyzing strategic customer and marketing information. Advise, counsel and support the development of strategic business plans, marketing plans and product/program implementation plans. -Plan, direct and coordinate the development and utilization of ComEd Customer Data Warehouses. Build, modify, monitor and maintain a CRM database system. -Recommend, develop, implement and monitor predictive models for new product/program penetration, account acquisition, profitability, segmentation and retention. -Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis (e.g., operational effectiveness, budget, resource, workload, workforce and capacity utilization, competitor, etc.). -Manage operating budget associated with customer data warehouses and external data services. -Advise and counsel corporate officers, directors, managers and business specialists on analytical findings and recommend courses of action that redirect resources to increase penetration of existing products and services, launch new products and services, respond to competitive challenges, drive customer satisfaction, or assist with overall emerging business issues. -Support business unit strategic planning. -Develop and maintain the ComEd Customer Data Warehouses, the primary depository of internal customer and externally purchased customer data. It is the role of this position to provide internal customers with data and analysis that best positions the company going forward. -Provide expert analytical and operational support to the business unit. -Provide strategic data mining, database marketing and related consulting services to all ComEd organizations.

Requirements

• sql
• microsoft office
• bachelor's
• master's
• consulting
• energy systems

What You Bring

-Experience: Consulting experience (8-10 years) in customer analysis, customer relationship management, marketing communications or marketing research. Experience in segmentation analysis and strategy, database analysis and implementation and relational database extraction/manipulation. Proficient in relational database query languages such as SQL. -Communication Skills: Ability to translate data analysis and findings into coherent conclusions and actionable recommendations to executives. Ability to translate executive vision and guidance into methods and analytics. Excellent oral and written communication skills. -Technical Knowledge: Working knowledge of data manipulation / analytical tools for use in mainframe and client / server environments. Computer literate in Microsoft Office Suite of products. Business knowledge of statistical analysis and statistical applications in business situations. -Education: Bachelor's degree required in market research, marketing, statistics, computer science or equivalent business experience. -5+ years experience with energy company specific systems and data, including billing systems, outage management systems. -Integration of business knowledge and functional priorities to address complex problems and non-standard situations -Master's degree in Computer Science/Information Systems Management, Business Administration, Market Research or Marketing. -Analytical Abilities: Proven ability to manage and conduct data analysis, extrapolate and integrate the data, draw conclusions, and provide clear, concise, actionable information. Proven ability to apply findings to both strategic and tactical business plans and resilient in changing or uncertain situations.

People Also Searched For

Benefits

-Medical, dental and vision insurance -401(k) match and annual company contribution -Referral bonus program -Employee Assistance Program and resources for mental and emotional support -Annual Bonus for eligible positions: 20% -Generous paid time off options, including vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave or parental leave -Life and disability insurance -Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement -Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $102,400.00/Yr. – $140,800.00/Yr.

About Exelon

-Exelon operates as America's largest regulated energy delivery company, formed from the merger of two century-old utilities in 2000. -It focuses on modernizing infrastructure and enhancing grid resilience through continuous investment. -The company's portfolio includes major utilities such as ComEd, BGE, PECO, Pepco, and others, covering vast transmission and distribution systems. -In 2022, Exelon spun off its power generation arm while maintaining full ownership of its transmission and distribution networks. -Exelon’s strategic initiatives often influence the mid-Atlantic and Midwest energy markets, shaping the regional energy landscape.

Sector Specialisms