Sr Data and Business Analyst

Job description

At Landis+Gyr, we're helping shape the future of energy—making it more intelligent, resilient, and sustainable. As a global energy technology leader, we're accelerating the energy evolution through purposeful innovation and trusted partnerships. Trusted by more than 2,000 utilities worldwide, our intelligent solutions connect devices, data, and decisions across the grid, helping customers modernize infrastructure, optimize operations, and deliver energy that is more reliable, resilient, accessible, safe, and sustainable. Behind every solution is a team of approximately 3,300 employees across more than 40 countries who are passionate about solving complex challenges, driving innovation, and making a meaningful impact for our utility customers and the communities they serve. Join Team Green and help shape the future of intelligent energy. Job Summary Responsible for supporting the R&D organization through business analysis, data analysis, business intelligence, technical solution development, application support, process automation, and project and portfolio management support. This position serves as a key technical and analytical resource supporting the R&D portfolio management environment, including ServiceNow, Microsoft Fabric, Power BI, data integration, reporting, automation, and related business processes. The position works closely with R&D Portfolio/PMO leadership, project managers, business stakeholders, and IT to translate business needs into practical technical solutions. The role requires the ability to understand R&D business processes and portfolio requirements while applying technical expertise to data, systems, integrations, reporting, automation, and continuous improvement. Key Responsibilities and Accountabilities R&D Portfolio Management & ServiceNow • Administer, enhance, and support the R&D ServiceNow environment and related portfolio management capabilities, including project, financial, resource, and time-tracking processes. • Maintain and improve the data and information contained within ServiceNow to support accurate R&D project and portfolio management. • Maintain data quality, system functionality, and reporting capabilities to support accurate portfolio planning, management, and decision-making. • Partner with R&D leadership, IT, and global stakeholders to define requirements, test solutions, resolve issues, and implement system enhancements. • Support the ongoing evolution of ServiceNow as the R&D project and portfolio management environment. • Provide user support, training, documentation, and guidance to promote effective adoption of R&D tools and processes. Business Analysis & Process Improvement • Analyze R&D business processes and requirements to identify opportunities for improved efficiency, data quality, automation, and user experience. • Translate business needs into functional and technical requirements, data solutions, reporting solutions, and technology implementations. • Support the management and organization of R&D requirements within Azure DevOps (ADO), including requirements, work items, backlog management, and traceability. • Partner with R&D stakeholders and IT to establish effective requirements management practices and improve visibility from business requirements through development, testing, and implementation. • Evaluate solution alternatives and make recommendations based on business needs, technical feasibility, sustainability, and value. • Drive continuous improvement through process automation, workflow optimization, data improvements, and effective use of technology. Data, Business Intelligence & Analytics • Design, develop, and maintain data and reporting solutions using Microsoft Fabric, Power BI, APIs, databases, and related technologies. • Build and maintain data pipelines from the ground up, including data ingestion, transformation, business logic, orchestration, and ongoing maintenance. • Develop and maintain ETL solutions using Python and PySpark, including notebook-based data transformations within a medallion architecture (Bronze/Silver/Gold). • Develop and maintain Lakehouse solutions, notebooks, and data pipelines within Microsoft Fabric or equivalent modern data platforms. • Develop advanced Power BI solutions, including DAX, Power Query M, semantic models, and data visualization. • Develop and maintain SQL/T-SQL solutions against warehouse and Lakehouse data. • Design and maintain dimensional data models, including star schemas, fiscal calendar dimensions, and organizational hierarchies. • Develop REST API data ingestion solutions, including incremental/delta loading and upsert patterns. • Develop data models, transformations, calculations, and business logic that provide accurate and actionable information for project managers, portfolio leaders, and executives. • Monitor and investigate data quality, integration, and reporting issues and implement sustainable solutions. Technical Solutions & Integrations • Design, develop, and maintain technical solutions that integrate data and applications across the R&D environment. • Support data integration and troubleshoot API, data, and system issues affecting R&D portfolio management and reporting. • Develop and maintain REST API integrations and associated data ingestion processes. • Partner with IT and system owners to define technical requirements, evaluate solutions, and support implementation. • Prototype and develop technical solutions to address R&D business needs and collaborate with IT and system owners through implementation. • Develop and maintain process automation solutions, including Power Automate workflows, to reduce manual effort and improve compliance and efficiency. • Maintain technical documentation and provide knowledge transfer for systems, data, reporting, and automation solutions. Portfolio & Project Support • Support R&D portfolio and project management activities through analysis of project, financial, resource, schedule, time-tracking, and other management information. • Maintain and analyze project and portfolio information to support planning, forecasting, resource management, financial management, and leadership decision-making. • Serve as a technical and analytical subject matter expert and partner to R&D stakeholders on portfolio management initiatives and new business requirements. • Provide analytical insights and recommendations to support portfolio planning, resource management, financial management, and leadership decision-making. Company Values • Supports and adheres to Company’s core values. • Performs other duties or responsibilities as assigned or required. • Supports and adheres to Company’s Code of Conduct and Ethics Policy. • Represents Company in a positive, professional manner when working with both internal and external customers. Education: Bachelor's degree in Business, Information Systems, Data Analytics, Computer Science, Engineering, or a related field preferred. Experience: 5–7 years of relevant experience in data engineering, business intelligence, data analysis, business analysis, systems analysis, application support, project/portfolio management, or a related technical/business function. Preferred Qualifications: • Advanced Power BI experience, including data modeling, visualization, calculations, and dashboard development. • Experience with Microsoft Fabric or comparable modern data platforms. • Experience working with APIs, data integrations, databases, and data transformation. • Experience with ServiceNow, preferably within project, portfolio, demand, resource, financial, or other enterprise management processes. • Experience developing workflow and process automation solutions, such as Power Automate. • Strong analytical and problem-solving skills with the ability to translate business requirements into technical solutions. • Experience supporting enterprise applications and working with IT teams. • Experience working in a global, cross-functional environment. • Strong written and verbal communication skills, including technical documentation and user training. Working Conditions: Typical indoor office environment with the majority of time spent sitting and working on a computer using keyboard, mouse, and monitor. Occasional use of other devices such as: phone, copier/printer/fax, etc. Physical Requirements: Typical office setting. Required to stand; walk; crouch; or handle objects. Lift and/or move up to 10 pounds. Ability to sit and view computer screen for long periods of time. The ability to see, hear, & speak in English. Reasonable accommodations provided for individuals with disabilities to perform the essential functions. Personal Protection Equipment/Other OHSA Safety Requirements: Ensure the continued efforts and assist in achieving annual goals of health, safety, and environmental policies. Must be current with available OSHA/Safety Training provided by the Company. If required, must be able to work while wearing safety equipment such as hard hats, work boats, gloves, hearing protection, and others. Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as a complete list of all responsibilities, duties, and skills required of personnel classified as such. As a part of the Landis+Gyr family, employees are offered a comprehensive and competitive package of benefits including medical, dental and vision coverage, life insurance, and a 401(k)-retirement plan featuring a generous company match incentive. Additionally, we offer three (3) weeks of Paid Time Off (PTO) as well as eleven (11) paid holidays. We also offer a tuition reimbursement program, optional pet insurance, supplemental medical coverage and a host of other perks to ensure the health, wellness, and enrichment of our team members. Pay is in the range of $92,000- $116,300 per year. The actual base salary offered depends on a variety of factors, which may include, as applicable, the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, and certifications or other professional licenses held. All candidates are encouraged to apply. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We're committed to shaping a better future for everyone. Join Team Green and be part of what's next in energy. #TeamGreen