Sr Data and Business Analyst

Landis+Gyr•Milton, GA

3d•$92,000 - $116,300•Onsite

About The Position

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.

Requirements

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.
Bachelor's degree in Business, Information Systems, Data Analytics, Computer Science, Engineering, or a related field preferred.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.
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.
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.