Sr. Lead Business Intelligence Analyst

Position Title:

Sr. Lead Business Intelligence Analyst

Position Type:

Regular

Hiring Range:

Pay Frequency:

Annual

A. POSITION PURPOSE

With minimal supervision, provide technical and functional support, training and documentation for all administrative offices using ERP reporting tools.

B.   ESSENTIAL DUTIES AND RESPONSIBILITIES

• Provide technical support for ERP and Lakehouse reporting tools
• Provide functional support for ERP and Lakehouse reporting tools
• Provide infrastructure support for ERP and Lakehouse reporting
• Provide training and documentation for ERP and Lakehouse reporting tools

C.   SPECIFIC RESPONSIBILITIES

Provide Technical Support for ERP and Lakehouse  reporting tools

Manage security

• Conduct periodic review of existing setups
• Create and test new security roles and permission lists to meet needs
• Resolve end user access and security issues as reported through the IT Service Center
• Work with the CISO to security policies such as timeouts, password configuration and training

Support reporting needs

• Teach power users how to write their own reports
• Troubleshoot complex private queries and reports
• Streamline and promote common menu-driven reports
• Design, build, and maintain custom reports, dashboards and analytics for end-users in various offices.
• Design, build, and maintain Prism data sources and custom Prism reports.
• Access legacy data via SQL 
• Create views in Lakehouse.

Conduct change management and new function integration and testing

• Monitor new updates and releases and determine impact
• Conduct initial testing prior to user testing

Manage primary troubleshooting of application and data issues and/or errors

• Triage incoming user error reports
• Identify and help resolve issues related to data and setups
• Replicate and document reported problem
• Report problems to vendor as necessary
• Document and report problems to IT Developers with any possible causes and solutions
• Use system tools to identify source of problem

Provide support for upgrades and projects

• Perform Fit/Gap analysis
• Assist with the development of test plans and scripts
• Coordinate and manage end user upgrade testing

2. Provide Functional Support for ERP and Lakehouse reporting tools

Evaluate functional procedures and work with end users to identify and implement enhancements

• Review current business practices
• Manage requests and translate business requirements to functional specifications working in close collaboration with the Technical Team and business users.
• Investigate and prototype new reporting functionality

Assist user community with functional responsibilities

• Coordinate batch processes among end user offices
• Provide support to power users with functional questions and issues

3.   Provide Infrastructure Support for ERP and Lakehouse Reporting

A. Design, develop, and implement high-performance, scalable, and secure APIs for real-time and batch data ingestion into the lakehouse.

• Work with various data sources, including relational databases, NoSQL databases, streaming platforms (e.g., Kafka, Kinesis), SaaS applications, and third-party APIs.
• Ensure APIs adhere to RESTful principles and organizational standards for security, reliability, and maintainability.
• Develop and optimize data ingestion processes, including data validation, transformation, and loading into lakehouse formats
• Implement robust error handling, retry mechanisms, monitoring, and logging for all ingestion APIs.
• Collaborate with data engineers to define data schemas, partitioning strategies, and storage optimizations within the lakehouse.
• Partner with source system owners to understand data structures, access methods, and ingestion requirements.