Clean Energy Senior Specialist - Digital Products (Analytics)

　　Job Info

　　111507

　　Posting Expiration Date: Feb 25, 2024

　　Schedule Type: Full-Time

　　Minimum Salary: $125000

　　Maximum Salary: $135000

　　Organization: Customer Energy Solutions

　　Department: Digital Products&Demo Projects

　　Section: CES Digital Products

　　Location: NY-New York-4 Irving Pl Headquarters

　　Similar Jobs

　　Technical Associate (https://careers.coned.com/jobs/13882598-technical-associate)

　　Operating Supervisor - Various Location

　　Analyst - Cost Management and Performance (https://careers.coned.com/jobs/13877133-analyst)

　　Clerical Assistant L1-2, EH&S Lab Services

　　Data Analyst (https://careers.coned.com/jobs/13873962-data-analyst)

　　Job Description

　　Mission Statement

　　Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) employees are required to follow health, safety, and environmental policies, EEO, Standards of Business Conduct, and all other applicable company policy and procedures. We all share a responsibility to advance the company’s mission by excelling at our three corporate priorities – safety of our people and the public, operational excellence in all that we do, and ensuring the best possible customer experience.Core Responsibilities

　　Gather requirements and translate business requirement to technical requirement and solution.

　　Creates user stories with relevant acceptance criteria.

　　Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM.

　　Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.

　　Writing SQL queries to pull, manipulate data and validate complex queries.

　　Develop ETL/DW best practices and participate as a reviewer and contributor in requirement, design and code reviews.

　　Data cleaning, perform exploratory data analysis, create statistical models, Machine Learning models for predictive analytics solutions and evaluation metrics.

　　As the ETL/BI Developer you will be coding, testing, debugging, implementing, and documenting moderately complex programs.

　　Working as a part of a team to manage and deliver quality and robust system enhancements to critical systems, as required by the business.

　　Create test scripts and testing plans with Scrum Masters, developers, test leads, and log bugs in system for UAT.

　　Detail oriented with effective multitasking and prioritization skills.

　　Gather requirements and translate business requirement to technical requirement and solution.

　　Creates user stories with relevant acceptance criteria.

　　Required Education/Experience

　　Bachelor's Degree in Computer Science, Data Science or equivalent and 3 years work experience or

　　Associate's Degree and 4 years work experience or

　　High School Diploma/GED 5 years work experience in the fields of Computer Science, Data Science or related disciplines.

　　Preferred Education/Experience

　　Master's Degree in Computer Science, Data Science or equivalent and and 2 years of experience.Relevant Work Experience

　　Prior experience with ODI ELT /SSIS ETL of data using flat files/DB2/Salesforce/Oracle NoSQL as source. Required

　　Hands-on experience in troubleshooting data issues arising out of the ELT/ETL process. Required

　　Design and develop SQL Server/ORACLE stored procedures, functions, views and triggers to be used during the ELT/ETL process. Required

　　Robust and practical expertise in PL/SQL. Required

　　Builds data transformations with SSIS including importing data from files, moving data from one database platform to another. Required

　　Design, implement and maintain database objects (tables, views, indexes) and database security. Required

　　Proficient with ETL/ELT tools such as Microsoft SSIS/ORACLE ODI. Required

　　Proven experience as an SSIS developer/ODI Developer or in a similar ETL-focused role. Required

　　Troubleshooting skills to diagnose and rectify errors in ETL processes. Required

　　Familiarity with performance optimization techniques for ETL processes. Required

　　Knowledge of database systems, data modeling, and data architecture. Required

　　Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations. Preferred

　　Experience with data warehousing concepts and dimensional modeling. Preferred

　　Creative problem-solving skills to address complex data integration challenges. Preferred

　　Knowledge of and work experience with energy efficiency and demand side management initiatives. Preferred

　　Experience working in a fast paced, changing environment. Preferred

　　Preferred Qualifications

　　The selected candidate will be working with a cross functional team of product owners, engineers, and program managers to develop and implement data-driven solutions that optimize and improve the performance of our clean energy products and services.Skills & Ability

　　Demonstrated problem solving skills

　　Articulate and responsive to colleagues

　　Strong verbal communication and listening skills

　　Ability to simultaneously handle multiple priorities

　　Demonstrates a high level of accuracy, even under pressure

　　Excellent organizational skills

　　Proactively approaches responsibilities

　　Possesses strong technical aptitude

　　Licenses & Certifications

　　Driver's License Required

　　Project Management Professional (PMP) Preferred

　　Certified Project Management (CPM) Preferred

　　Other Physical Demands

　　Must be able to respond to Company emergencies by performing a System Emergency Assignment to restore service to our customers.

　　Must be able and willing to travel within Company service territory, as needed.

　　Technical Difficulty Statement

　　For technical issues, please contact us at [email protected]Equal Opportunity Employer

　　Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) are equal opportunity employers. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of the individual’s actual or perceived disability, protected veteran status, race, color, creed, religion, sex, age, national origin, gender, gender identity, gender expression, genetic information, marital status, sexual orientation, citizenship, domestic violence victim status, or any other actual or perceived status protected by law.