BEST Program Data Analyst/BI Engineer

BEST Program Data Analyst/BI Engineer

The BEST Program Data Analyst/BI Engineer will work with a team comprised of BEST Program staff, agency business and technical SMEs and the new solution system integrator (SI) and product vendor to design and implement the data information management and reporting strategies, tools, and outputs to provide a robust reporting and data analytics capacity for users of the new Financials solution. The implementation of the new Financials solution will provide users with the ability to run queries and reports on the live data in this application directly rather than waiting for data to be available through warehouse reports. Data will be integrated across modules permitting more robust, real-time reporting and analytics capabilities.

The BEST Program Data Analyst/BI Engineer will work with the BEST Financials Data Lead to identify reporting, dashboard and business analytics needs that will drive the configuration of standard reports and dashboards delivered through the new Financials solution. The DA/BI Lead will assist in leading requirements sessions with BEST staff, agency staff and the system integrator and product vendor to review the reporting and analytics capabilities of the new solution and to identify available configuration options. The DA/BI Lead will develop and maintain a list of selected configurations for each report and dashboard and work with reports/dashboard developers during configuration to assist in translating business requirements to the configured reports. The DA/BI Lead will also participate in testing configured reports and dashboards and in organizing user testing of these items.

Whenever feasible, the BEST Program intends to adopt delivered reports and dashboards, but in instances where reporting requirements cannot be met by the delivered solutions, the DA/BI Lead will work with business and the system integrator and product vendor to identify requirements for future report development and participate in testing of these items when they are developed. The DA/BI Lead will work with business and the system integrator and product vendor to identify opportunities for improving the availability of data for reporting and analytics by understanding the solution’s capacities in this area, sharing that information with business and documenting implementation options with owners of other Commonwealth business intelligence and data analytics resources.

The DA/BI Lead will support data access for users in the following areas, working to improve data quality and access in the new solution: Financials: Acquire to Retire (Capital Asset Management), Cash Management, Cost Allocation, Debt Management, Grants Financial Management, Operating Budget Management, Order to Cash (Revenue/Accounts Receivable), Procure to Pay (Accounts Payable), Program Management, Record to Report (Financial Reporting), Reporting/Analytics, Sub-fund Management, Vendor Management and Self Service Operations: Maintenance and Warranty Management, Incident Management, Capacity Management, Availability Management, Performance Management, Security Management, Nightly Batch Jobs Management, Software Change Management and Testing, Disaster Recovery Testing and Management.

Specific duties include contributing to the development of data reporting and data access through database queries, reports, and dashboards. Gathering information from agency business users and technical staff regarding the types of data, frequency of reports or dashboards, distribution of reports or dashboards, and other information as needed to understand the current reporting needs of agencies. Participating in developing an approach to identifying reporting and data analytics needs across the new solution user community. Documenting configuration decisions for each standard report and dashboard and providing guidance to report developers during the configuration stage. Participating in testing of configured reports and dashboards and assisting in coordinating user testing of these materials. Supporting and managing enterprise architecture’s data operations (optimize data processing, query performance and data quality) and data pipelines. Integrating data from diverse sources using ETL processes and transforming raw data into datasets used for analysis. Implementing robust security measures, monitoring data access and developing access policies. Providing technological expertise to capture, store and employ data catalogue and lineage to support governance initiatives. Understanding business requirements in the BI context and designing data models to convert raw data to meaningful insights. Performing SQL, DAX queries and functions in Power BI. Receiving training and hands on guidance from the system integrator and product vendor in how to build queries, reports, and dashboards in order to assist reports developers in their work. Assisting in the creation of job aids and other training materials to support report writing by agency users.

Required skills include experience in building complex queries, reports and dashboards using a range of web-based tools. Knowledge of structured data, such as entities, classes, hierarchies, relationships, and metadata. Proven ability to collaborate with business owners, information architects, content architects and other stakeholders to support common goals and approaches including interviewing managers and other stakeholders to understand their data needs, interviewing users to understand what they need from data systems to boost their performance, translating business goals, user needs and process improvements into data management functions and requirements, explaining the capabilities of data systems to business managers and users as the new solution is designed and configured, providing guidance on project scoping to meet stakeholders' requirements, assessing whether data is fit for use by performing initial validation of data delivered as part of the project, exhibiting an excellent understanding of how data are used within business processes and its impact, in-depth exposure to data quality concepts, best practices, and tools, experience in designing, developing and deploying business analytics dashboards using PowerBI, experience in Cloud Data warehouses like Snowflake, Redshift, familiarity with Snowflake Data sharing, Snowpipe and Snowpark, experience in ETL tools such as Pentaho/Informatica and proficient in SQL, well-developed system analysis skills, understanding and knowledge of IT standards and controls, proficient written and verbal communication and interpersonal skills.

Preferred qualifications include experience with Software as a Service cloud implementations particularly those in which legacy on premise applications have been migrated to cloud delivery options. Minimum entrance requirements include a Bachelor's degree in computer science, system analysis or a related study, or equivalent experience. Minimum of 5 years of design and implementation experience in the areas of business intelligence/reporting and data warehousing.