Analyst, System Integration (HYBRID)
12/13/2024Locations Berlin, Connecticut; Auburn, Massachusetts
Job Description
Analyst, System Integration (HYBRID)
12/13/2024Locations: Berlin, Connecticut; Auburn, Massachusetts
The Analyst, System Integration plays a key role in the development and implementation of data-driven solutions to support business needs within Eversource Gas. This position is responsible for collaborating with stakeholders to understand requirements, design and develop reports and dashboards using Power BI and SQL, and ensure the accurate and efficient delivery of information to drive informed decision-making.This is a hybrid position. The first three months will be full-time in the office.
Essential Functions:
- Collaborate with Business Stakeholders: Work closely with business users to understand their reporting and data analysis needs, gather requirements, and translate them into technical specifications.
- Data Modeling and ETL: Develop and maintain data models, utilizing Power Query (M) to extract, transform, and load data from various sources into Power BI datasets.
- Report and Dashboard Development: Design, develop, and deploy interactive reports and dashboards in Power BI, utilizing best practices in data visualization and user experience design.
- SQL Development: Write and optimize SQL queries to extract and manipulate data from Oracle SQL Server databases.
- Data Analysis and Validation: Analyze data, identify trends and patterns, and validate results to ensure accuracy and integrity.
- Performance Optimization: Monitor report performance and optimize Power BI reports and dashboards for efficient data retrieval and rendering.
- Documentation and Training: Create and maintain clear and concise documentation for reports and dashboards, including data sources, calculations, and user guides. Provide training and support to end users on report usage and functionality.
- Data Governance and Quality: Adhere to data governance standards and contribute to data quality initiatives.
- Stay Current: Keep abreast of the latest Power BI features, functionalities, and best practices.
Technical Knowledge/Skill/Education/Licenses/Certifications:
- Power BI Expertise: Proficiency in Power BI Desktop and Power BI Service, including data modeling, DAX calculations, data visualization, and report publishing.
- SQL Proficiency: Strong SQL skills, including the ability to write complex queries, stored procedures, and functions in Oracle SQL Server.
- Data Analysis: Understanding of data analysis techniques and methodologies.
- Data Visualization: Ability to create effective and insightful data visualizations.
- Communication Skills: Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical audiences.
- Three (3) to five (5) years business and technical experience
Education:
- Bachelor’s Degree in Business Administration, Computer Science, Information Technology, Engineering, related discipline or equivalent experience.
Compensation and Benefits:
- Eversource offers a competitive total rewards program. The annual salary range for this position is $85600.00 to $95110.00, plus incentive. Salary is commensurate with your experience. Check out the career site for an overview of benefits.
Working Conditions:
- Must be available to work emergency restoration assignment as required.
- Must be available to travel between MA/CT/NH as necessary.
- Work is performed primarily in an office environment which includes sitting, standing and general movement throughout the office area.
Mental Aspects:
- Work includes requirements gathering, analyzing, designing, implementing, presenting, project management and support.
- Works in an environment that often requires the performance of multiple simultaneous activities, where deadlines need to be met and work is performed under pressure while involving significant business commitments and results.
Leadership Behaviors/Competencies:
Set and Communicate Direction and Priorities
- Know the business plan and how your role connects to it
- Identify problems, issues; take responsibility for resolution
- Set high standards for self; deliver quality performance
- Raise ideas for improvement
- Communicate, communicate, communicate
Build Trusting Relationships
- Follow through on commitments made to manager, colleagues, and customers.
- Address difficult or controversial issues and encourage others to do the same.
- Have honest dialogue with others
Manage and Develop People
- Set performance goals that align with department and company goals
- Meet regularly with your supervisor/manager to discuss your performance
- Seek opportunities to develop skills and gain knowledge through on the job opportunities, i.e. working on projects, attending meetings, etc.
Foster Teamwork and Cross-functional Collaboration
- Work collaboratively within and across the organization to achieve “One Company” and other goals
- Recognize and address cross functional implications of your work
Create a Diverse, Inclusive Workforce
- Incorporate the diverse ideas and perspectives of team, colleagues, and customers in your work
Lead Change
- Proactively seek out opportunities to improve business performance and customer service.
- Respond positively to new demands or circumstances
- Exhibit a “can-do” attitude to support changes in priorities and work processes
Focus on the Customer
- Deliver superior service to our customers, both internal and external, in a reliable, attentive, courteous, quality, proactive and timely manner
Please submit a resume with your application.
#gasajd
#LI-RG1
Worker Type:
RegularNumber of Openings:
1EEO Statement
Eversource Energy is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, sexual orientation, gender identity, national origin, religion, disability status, or protected veteran status.
VEVRRA Federal Contractor
Emergency Response:
Responding to emergency situations to meet customers’ needs is part of every employee’s role. If employed, you will be given an Emergency Restoration assignment. This means you may be called to assist during an emergency outside of your normal responsibilities, work hours and location.
Overview
If you are looking for a hands-on career or the opportunity to lead a team, then Operations may be for you. They are the main source of providing our customers with the essential product that makes their lives easier—power. Whether you're working with electricity or natural gas, you'll use your mechanical skills in a hands-on job and deliver results to our customers on a daily basis. You'll work collaboratively with a variety of people and departments and learn about different parts of the business while making a big impact for our customers and communities. You'll receive a variety of training to help you learn how to do your job safely. Training typically includes classroom instruction, e-learning, field simulations and on-the-job learning with a peer coach.
-
Job Level - Entry, Mid,
Senior, Executive -
Travel between CT/MA/NH
may be required
About us
Success Profile
What makes a successful Gas Operations team member?
Check out the top traits we're looking for and see if you have the right mix.
- Collaborative
- Focused
- Team Player
- Adaptable
- Detail Oriented
- Positive
Culture
- We are dedicated to our employees and customers
- Safety is a core value at Eversource
- We live out our mission of delivering reliable energy
- We are committed to creating an inclusive workplace where all employees, customers and stakeholders are respected and valued
Career Path
-
Entry Level DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Skilled Craft Worker DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Crew Leads DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Foreman DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Supervisor DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Manager DO NOT FORGET TO ADD ACCESSIBILITY TEXT
-
Director DO NOT FORGET TO ADD ACCESSIBILITY TEXT
Job Description
Analyst, System Integration (HYBRID)
12/13/2024Locations: Berlin, Connecticut; Auburn, Massachusetts
The Analyst, System Integration plays a key role in the development and implementation of data-driven solutions to support business needs within Eversource Gas. This position is responsible for collaborating with stakeholders to understand requirements, design and develop reports and dashboards using Power BI and SQL, and ensure the accurate and efficient delivery of information to drive informed decision-making.This is a hybrid position. The first three months will be full-time in the office.
Essential Functions:
- Collaborate with Business Stakeholders: Work closely with business users to understand their reporting and data analysis needs, gather requirements, and translate them into technical specifications.
- Data Modeling and ETL: Develop and maintain data models, utilizing Power Query (M) to extract, transform, and load data from various sources into Power BI datasets.
- Report and Dashboard Development: Design, develop, and deploy interactive reports and dashboards in Power BI, utilizing best practices in data visualization and user experience design.
- SQL Development: Write and optimize SQL queries to extract and manipulate data from Oracle SQL Server databases.
- Data Analysis and Validation: Analyze data, identify trends and patterns, and validate results to ensure accuracy and integrity.
- Performance Optimization: Monitor report performance and optimize Power BI reports and dashboards for efficient data retrieval and rendering.
- Documentation and Training: Create and maintain clear and concise documentation for reports and dashboards, including data sources, calculations, and user guides. Provide training and support to end users on report usage and functionality.
- Data Governance and Quality: Adhere to data governance standards and contribute to data quality initiatives.
- Stay Current: Keep abreast of the latest Power BI features, functionalities, and best practices.
Technical Knowledge/Skill/Education/Licenses/Certifications:
- Power BI Expertise: Proficiency in Power BI Desktop and Power BI Service, including data modeling, DAX calculations, data visualization, and report publishing.
- SQL Proficiency: Strong SQL skills, including the ability to write complex queries, stored procedures, and functions in Oracle SQL Server.
- Data Analysis: Understanding of data analysis techniques and methodologies.
- Data Visualization: Ability to create effective and insightful data visualizations.
- Communication Skills: Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical audiences.
- Three (3) to five (5) years business and technical experience
Education:
- Bachelor’s Degree in Business Administration, Computer Science, Information Technology, Engineering, related discipline or equivalent experience.
Compensation and Benefits:
- Eversource offers a competitive total rewards program. The annual salary range for this position is $85600.00 to $95110.00, plus incentive. Salary is commensurate with your experience. Check out the career site for an overview of benefits.
Working Conditions:
- Must be available to work emergency restoration assignment as required.
- Must be available to travel between MA/CT/NH as necessary.
- Work is performed primarily in an office environment which includes sitting, standing and general movement throughout the office area.
Mental Aspects:
- Work includes requirements gathering, analyzing, designing, implementing, presenting, project management and support.
- Works in an environment that often requires the performance of multiple simultaneous activities, where deadlines need to be met and work is performed under pressure while involving significant business commitments and results.
Leadership Behaviors/Competencies:
Set and Communicate Direction and Priorities
- Know the business plan and how your role connects to it
- Identify problems, issues; take responsibility for resolution
- Set high standards for self; deliver quality performance
- Raise ideas for improvement
- Communicate, communicate, communicate
Build Trusting Relationships
- Follow through on commitments made to manager, colleagues, and customers.
- Address difficult or controversial issues and encourage others to do the same.
- Have honest dialogue with others
Manage and Develop People
- Set performance goals that align with department and company goals
- Meet regularly with your supervisor/manager to discuss your performance
- Seek opportunities to develop skills and gain knowledge through on the job opportunities, i.e. working on projects, attending meetings, etc.
Foster Teamwork and Cross-functional Collaboration
- Work collaboratively within and across the organization to achieve “One Company” and other goals
- Recognize and address cross functional implications of your work
Create a Diverse, Inclusive Workforce
- Incorporate the diverse ideas and perspectives of team, colleagues, and customers in your work
Lead Change
- Proactively seek out opportunities to improve business performance and customer service.
- Respond positively to new demands or circumstances
- Exhibit a “can-do” attitude to support changes in priorities and work processes
Focus on the Customer
- Deliver superior service to our customers, both internal and external, in a reliable, attentive, courteous, quality, proactive and timely manner
Please submit a resume with your application.
#gasajd
#LI-RG1
Worker Type:
RegularNumber of Openings:
1EEO Statement
Eversource Energy is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, sexual orientation, gender identity, national origin, religion, disability status, or protected veteran status.
VEVRRA Federal Contractor
Emergency Response:
Responding to emergency situations to meet customers’ needs is part of every employee’s role. If employed, you will be given an Emergency Restoration assignment. This means you may be called to assist during an emergency outside of your normal responsibilities, work hours and location.
Benefits
Eversource employees are committed to providing reliable energy and superior customer service—and that's why we are committed to providing our employees with a highly competitive total rewards package. In addition to wages and salaries, the benefit programs Eversource offers its employees and family members are a significant part of the total rewards.
Healthcare, Wellness & Disability Protection for you and your Family
- Comprehensive Medical, Prescription, Dental, and Vision Plans, choose the coverage that is right for you and your family
- High deductible health plan option, with generous health savings account (HSA), employer contribution, ($500 individual; $1,000 employee +1 or more)
- Company-paid employee life and accident insurance and options to purchase additional coverage for you and your family
- An award-winning Wellness Program provides up to $200 annually for employees and spouses to adopt and maintain healthy lifestyles
- Health and Dependent care reimbursement accounts
- Sick Time, Short-Term & Long-Term Disability Plans
Work/Life Balance Benefit Programs
- Employee Assistance Program (EAP)
- Multi-faceted Behavioral Health Program
- Care@Work Program (child/elder care), membership/stipend for emergency services
- Adoption Assistance (eligible employees)
- Tuition Reimbursement, Student Loan Refinancing & Student Debt Counselling
- Voluntary benefits platform to access discounted home & auto, identity protection and pet insurance
- Charity donation gift matching
- Volunteer hours at local charities with rewards to our Wellness Program
- Generous time off
- Business Resource Groups for social connection and career development
Retirement Benefits for a Secure Future
- 401k: Up to 100% Employer Match on first 3% of employee's contributions
- K-Vantage: Additional Employer Contribution to the 401k based on age and years of service (2.5% to 6.5%)
- Med-Vantage HRA: Age 40+, receive annual $1,000 contribution to an HRA for post-employment qualified medical expenses
Early Career Opportunites:
Associate Development Programs & Internship Opportunities
It's an exciting time to work in the Energy Industry! Are you interested in working in a growing, dynamic field that's helping to build the clean energy grid of the future? We also have summer internship opportunities in these areas that are great segues into the full time Development Programs upon graduation.
- Gas Engineering Development Program
- Transmission Development Program
- Associate Construction Representative Program
- Engineering Professional Development Program