Bi analyst Jobs in Cambridge, MA

Job Description

Job Description

Required Skills

• 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.
• Experience with Software as a Service cloud implementations particularly those in which legacy on premise applications have been migrated to cloud delivery options.

Additional Skills

Job Description Position Summary

The& BEST Program Data Analyst / BI Engineer & (DA / BI) 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 :

Operations :

Specific Duties

Required Skills

Preferred Qualifications

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

Hybrid Work Model

Under this policy, employees are currently required to work a minimum of four business days per month (two set by management and two set by the employee) on-site at CTR’s Boston office and may work remotely the remainder of the time at a location approved by their supervisor, so long as they comply with the requirements of the telework policy.& Under this policy, all employees must be able to report to the Boston office with little or no notice, even including the same workday should an exigent circumstance arise. Therefore, a reasonable proximity to the office is necessary. CTR does not reimburse for employees to travel to the office.

In addition, the successful candidate may be required to work primarily on site in Boston during the initial training and orientation period and / or for certain positions a primarily on-site role may be necessary.