Business Intelligence Analyst - Business Systems

Job DescriptionJob Description

Job Description:

The Business Intelligence Analyst - Business Systems is responsible for building, developing, and maintaining data requests and SQL procedures, both pre-existing and newly requested. Boston Globe Media utilizes Snowflake Data Cloud Platform as its Enterprise Data Solution. This role works closely, as part of the BI team, with IT and Engineering as well as the Finance, Sales, HR, Advertising, and Consumer departments to provide the data needed for improved business intelligence. The ideal candidate is comfortable liaising between technical and non-technical colleagues and is willing to help solve problems proactively.

Responsibilities:

• Monitor, optimize, and tune database performance as needed for cost savings.
• Follow and maintain all database standards and processes.
• Troubleshoot and diagnose problems.
• Manage the data warehouse's information flow through data feeds, reports, and dashboards.
• Manage access to databases and define security standards.
• Work closely with the Finance, Sales, and Consumer departments to provide requested business intelligence.
• Stay ahead of the latest technology updates and trends.

Qualifications:

• At least 3+ years of experience with Snowflake
  • Inclusive of the UI, Marketplace, and External Connections
  • StreamLit App Building
• Experience writing reports using tools such as Tableau, PowerBI, and other well-known BI Reporting tools
• Experience building and using REST APIs
• Experience with scripting such as Bash, Perl, and Python.
• Experience with Git and version control.
• Experience with public cloud services (AWS, GCP, etc)
• Excellent written documentation and verbal communication skills.
• A willingness to adapt and be audience-focused, with a curious mindset and a commitment to creating an inclusive work environment

PLUS:

• Knowledge of MySQL, PostgreSQL, MariaDB, MS SQL
• Fivetran Data Platform/ETL Tool

The BGMP office is located in downtown Boston, near Faneuil Hall and Quincy Market, and is easily accessible by MBTA and commuter rail lines. This position is based in Boston, and candidates should be based in the area or willing to move.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

EEO Statement: At Boston Globe Media, our mission is to empower, connect, and convene our communities with independent, trusted journalism and storytelling. We know a critical part of achieving this is by having a workforce that is diverse, equitable, and inclusive - like the communities we serve. Boston Globe Media is an equal opportunity employer that welcomes candidates and colleagues of all backgrounds, experiences, perspectives, and skills.