Senior Analyst, System Integration

Eversource will not offer immigration-related sponsorship for this position. Applicants who require immigration sponsorship—either now or in the future—should not apply. This includes, but is not limited to, direct company sponsorship, listing Eversource as the employer of record on immigration documents, or any work authorization that requires company involvement or documentation (e.g., H-1B, OPT, STEM OPT, CPT, TN, J-1, O-1, etc.).

Provide key assistance in the creation of System Integration solutions to support the respective business. Responsible for meeting with internal customers to gain a better understanding of their business needs, define report requirements, and develop business intelligence reports to help drive action. Furthermore, this position will improve and expand the internal infrastructure of Eversource enterprise reporting.

Eversource supports work-life balance by offering hybrid schedules for certain roles. Eligibility is based on job responsibilities, operational needs, nature of work and team dynamics. Current guidelines require employees to work at least three days in the office, including Tuesdays and Wednesdays, with the third day set by the employee and supervisor based on department needs. These guidelines apply to roles approved for remote work and are subject to change, based on managerial discretion and work performance.

All applicants must be able to work up to five days in the office if needed (for example: emergencies, training, or other business needs) or should the policy change.

• Leads the mapping of system data architecture related to Eversource Gas and drives the design of a comprehensive data reporting solution.
• Collaborates with stakeholders to ensure seamless integration of Eversource Gas data with Eversource business goals and develops robust monitoring plans for front‑end development.
• Takes ownership of requirements gathering, risk traceability, and validation for the implementation of Eversource Gas systems.
• Serves as the primary point of contact for managing reporting requests from internal management and external clients, providing expert guidance and support.
• Defines and drives Eversource Gas database reporting requirements, identifies gaps, and delivers in‑depth analysis and timely updates to management.
• Conducts in‑depth meetings with internal customers to gain a comprehensive understanding of their business needs, collaborating to identify and implement best practice solutions and define report requirements.
• Develops and maintains complex SQL queries and data automation scripts.
• Establishes strong links between data and business processes and requirements to ensure accurate requirement definition.
• Creates advanced Power BI charts for automated business insights, leveraging advanced features and functionalities.
• Validates results and proactively reconciles discrepancies by gaining a deep understanding of the data and end user workflow.
• Utilizes a wide range of tools and methodologies to create sophisticated reports with actionable information, incorporating advanced data analysis techniques.
• Designs, implements, and maintains highly interactive reports, dashboards, and other business intelligence tools, ensuring optimal performance and user experience.
• Proactively monitors the performance of reports and provides strategic recommendations to optimize or enhance the design.
• Takes ownership of data integrity monitoring and actively resolves discrepancies between the data warehouse and other sources.
• Develops and maintains comprehensive documentation, including requirements, design, and end‑user manuals.
• Provides expert‑level end‑user training and support, acting as a mentor and resource for junior team members.

Technical Knowledge/Skill:

• Expertise in Microsoft Power Platform, including advanced proficiency in Power BI, Power Apps, and Microsoft Flow. Strong knowledge of DAX and Power Query is essential.
• In‑depth knowledge of Gateway services and expertise in managing user and app security.
• Extensive experience with Oracle SQL Server and demonstrated ability to…