Business intelligence developer serp_jobs.h1.location_city

Job Description

The Technical — Business Intelligence Analyst position will help drive the optimization of the business data infrastructure; ensuring that data is accessible, accurate, and actionable for various business functions. This role is crucial for developing and automating data-driven solutions, enhancing business intelligence capabilities, and streamlining both financial and internal reporting.

Job Responsibilities

Database Management :

Assist with the management, maintenance, and optimization of the company's database in BigQuery / Azure

• ensuring data integrity, performance, and security.

Heavily utilize SQL to query, manipulate, and analyze data for various business needs.

Data Engineering :

Utilize ETL tools such as Skyvia and Azure DataFactory to create and manage data pipelines between SalesForce / FinancialForce and Bigquery / Azure

Own the data integrity and cleaning via use of SQL and other best practice data tools.

Work with other analysts on ensuring clean data sets to effectively perform their duties in a timely manner.

Ownership of Historical Data :

Responsible for managing historical Bayard & Appcast (Quickbooks) data stored in BigQuery / Azure

Utilize SQL to query historical data from NetSuite that is only stored in this database, for use in audits and other analysis purposes.

Assist with managing the relationship with Gurus BI consultants.

Coordination with Group :

Work with StepStone to provide accurate and easily consumable data from Appcast financial & operational departments.

Data Governance :

Collaborating with Financial Force and Salesforce admins to ensure data accuracy and consistency across the organization, establishing a single source of truth.

Business Intelligence & Dashboard Development :

Design, develop, and maintain Power BI dashboards to provide actionable insights to internal teams.

Work closely with stakeholders to ensure dashboard solutions meet business needs and improve data-driven decision-making.

Data Automation :

Automate repetitive Excel tasks and financial processes for the Finance team; improving efficiency, reducing manual errors, and accelerating reporting timelines.

Financial Reporting :

Create and streamline core financial reports, including Profit and Loss (P&L) statements and Balance Sheets, to support the finance team in delivering timely and accurate financial insights.

Cross-Functional Collaboration :

Collaborate with different departments, including Finance, Creative, SalesOps and others, to gather requirements, provide data-driven insights, and ensure the seamless integration of BI tools into business operations alongside Salesforce / FinancialForce.

Train :

Act as the business intelligence subject matter expert. Training other analysts in fundamental understanding of BI best practice, including SQL coding and PowerBI development.

Qualifications

Education and Experience

Travel Requirements

Travel for this position is occasional, typically occurring a few times a year to attend internal and external meetings.

Supervisory Responsibilities

This position will not supervise others.

Additional Information

Appcast recognized as one of Inc Magazine's "Best Workplaces" for 2024!