BI Data Analyst

AgreeYa Solutions - Oakland, CA

Full-time

Oakland, CA

Professional, Scientific, and Technical Services

About the position

The Business Intelligence Analyst (BIA) plays a crucial role in providing technical and analytic support to evaluate and interpret data, collate findings relevant to the business, and share insights that can lead to effective changes in processes, workflows, and overall operations. Under the general supervision of the Information Systems Business Intelligence Deputy Director and the Information Systems Business Intelligence Coordinator, the BIA will assist in making sense of vast volumes of data within the department and other data assets. This position is essential for streamlining processes and staying ahead of industry trends, with a key objective of transforming data into actionable insights that enhance value for both internal and external customers served by the Client. The BIA will support the Client IS Business Intelligence team in knowledge management, technical project management, and overall content organization. Responsibilities include performing and participating in various research studies, data analysis, metrics reporting, facilitation, training, and assessments related to department performance and strategic planning. The BIA will also design, develop, appraise, and conduct orientation for existing and prospective new programs and service offerings, as well as execute various administrative assignments of varying complexity as assigned. In this role, the BIA will be responsible for data extraction and analysis of organizational data, compiling data regarding various challenges, and offering remedies to improve operational processes and systems. The BIA will analyze business requirements and processes, recommend implementations to management, and create and maintain documentation that includes design, requirements, and training materials for the organization. Additionally, the BIA will partner with stakeholders to understand their specific reporting needs and develop solutions using the Microsoft PowerBI platform, providing thought leadership and best practices related to managing an analytics technology platform based on PowerBI, SQL Data Warehouse, and/or Snowflake.

Responsibilities

• Data extraction and analysis of organizational data.
• Compiling data regarding various challenges and offering remedies that improve the operation of processes and systems.
• Analyzing business requirements and processes and recommending them to management for implementation.
• Creating and maintaining documentation that includes the design, requirements, and training materials for the organization.
• Identifying the development needs for the purpose of streamlining and improving the operations of the organization for efficiency and optimization.
• Writing specifications, developing visualization concepts, and contributing to the BI roadmap.
• Partnering with stakeholders to understand their specific reporting needs and requirements, and developing solutions using the Microsoft PowerBI platform.
• Providing thought leadership, best practices, and standards related to effectively managing an analytics technology platform based on PowerBI, SQL Data Warehouse, and/or Snowflake.
• Supporting monitoring and reporting on the BI platform, providing visibility into resource utilization, and identifying areas for improvement.
• Evaluating and reporting on the effectiveness and usability of solutions based on quantitative usage data and qualitative discussions with end-users and stakeholders.
• Collaborating with data architect and data engineer teams to identify key cross-sector data, data cleansing, and completeness processes for source systems.
• Designing, developing, implementing, monitoring, and updating business intelligence tools, systems, databases, dashboards, spreadsheets, and data outputs.
• Supporting the Client IS Business Intelligence team in data analysis and reporting services design, development, management, maintenance, and program coordination.
• Developing data and report requests to meet program needs for internal/external stakeholders.
• Designing or identifying proxy measures when needed and translating stakeholder program data needs to technical staff.
• Providing recommendations on additional useful analytics drawn from previous report development experience using cross-sector Client data.
• Refining data visualization requests to provide meaningful and actionable results.
• Performing other duties as assigned within the classification.

Requirements

• Experience with leading process assessments and analyzing large, complex, and varied data sets.
• Proficiency in using modern analytical tools to create reports, visualizations, and other artifacts.
• Strong understanding of data management and analytics areas.
• Ability to transform data into insights that improve value for customers.
• Experience in knowledge management and technical project management.
• Strong documentation skills, including design, requirements, and training materials.
• Ability to partner with stakeholders and understand their reporting needs.
• Experience with Microsoft PowerBI, SQL Data Warehouse, and/or Snowflake.

Nice-to-haves

• Experience in facilitating training and assessments related to department performance and strategic planning.
• Familiarity with data cleansing and completeness processes for source systems.
• Knowledge of best practices in managing analytics technology platforms.