Technical —Business Intelligence Analyst

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 ResponsibilitiesDatabase 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.