Business Intelligence Director

We are working exclusively with a private company adding to their team!  This newly created FP&A position will play a pivotal role in the expansion of the organization. The company is growing through acquisition and is well-established with processes and procedures in place.  The ideal candidate will lead the data-driven decision-making efforts and drive strategic insights across the organization utilizing SQL, Power BI and overall data engineering skills. The successful candidate will possess a strong blend of technical expertise, leadership skills, and business acumen to shape the future of our business intelligence initiatives.

• Develop and communicate a comprehensive business intelligence strategy aligned with the company's objectives. Collaborate with senior leadership to identify key business questions and opportunities that can be addressed through data analysis and reporting.
• Build and mentor a team of business analysts, data engineers, and data scientists, fostering a collaborative and high-performing work environment. Provide guidance and support to ensure the team delivers high-quality insights and solutions to various stakeholders.
• Oversee the development and maintenance of data governance policies, ensuring data quality, consistency, and security. Drive the creation of advanced analytical models, dashboards, and reports that provide actionable insights to different departments.
• Evaluate and implement cutting-edge business intelligence tools, technologies, and platforms to enhance data analysis capabilities. Ensure the integration of data from diverse sources, both internal and external, for a holistic view of the business landscape.
• Develop new data pipelines using SQL and data warehousing skills to support the business.
• Recognize and streamline manual processes by applying modern cloud-based ELT/ETL solutions.
• Formulate relational models and reports using Power BI to support the growing requirements of the business.
• Implement MVP principles to refine and design solutions in an agile fashion.
• Collaborate closely with department heads and cross-functional teams to understand their data needs and support their decision-making processes.
• Help build a world-class BI organization by developing, standardizing, maintaining, and driving continuous improvement of Business Intelligence processes.

• Bachelor's degree in finance, information systems, or computer science.

MINIMUM QUALIFICATIONS

• 7-10 years of relevant work experience utilizing SQL in a DBMS to create DML and DDL scripts.
• Familiarity with Snowflake or another cloud-based data warehouse.
• 5+ years of relevant work experience with Microsoft Office Suite including advanced excel knowledge and SharePoint Online exposure.
• Familiarity with an enterprise ERP data stack (Oracle, SAP)
• Advanced knowledge of Power BI including composite models, familiarity with PowerQuery, DAX calculations, drilldown features, and service/workspace security.
• Must possess strong self-management, communication, and organizational skills.

PREFERRED QUALIFICATIONS

• Expert SQL skills utilizing CTEs and window functions in analytical workflows.
• Prior work experience deploying version-controlled data pipelines.
• Prior work experience with Salesforce SOQL or another cloud CRM platform.
• Experience using cloud orchestration tools with CI/CD, DBT is a plus.
• Expert knowledge of the DAX language for Power BI including a deep understanding of filter context.
• Advanced relational modeling skills with experience using star schemas and bridge tables.