Director, Business Intelligence

• Lead complex analysis and troubleshooting (e.g., reconciling deltas, missing data, dataset matching, and period-over-period validation).
• Design, develop, and support database objects (tables, views, functions, stored procedures, indexes) with an emphasis on reliability and maintainability.
• Drive data quality practices by identifying discrepancies and partnering on remediation (experience with data quality tooling is a plus).

• Apply modern warehousing concepts (e.g., Kimball, star schemas, data marts) to deliver governed, reusable datasets.
• Build and troubleshoot connectivity patterns (e.g., linked servers, ODBC, remote SQL Server connections, PostgreSQL connectivity).

• Establish performance tuning standards (indexing strategy, query optimization, partitioning) and practices for monitoring and remediation.
• Support HA/DR practices (backup/restore strategies and recovery models; familiarity with log shipping, failover clusters, and availability groups is a plus).
• Leverage proven community tooling and approaches for monitoring, troubleshooting, and automation (e.g., diagnostic scripts and migration toolsets).

• Power BI leadership: semantic model design, strong DAX proficiency, report development, and service administration (deployments, permissions, gateways, refresh troubleshooting).
• SSRS/paginated reporting: build and support reports end-to-end, including datasets and underlying SQL artifacts.

• Design and support data integrations using SSIS (preferred) and/or comparable platforms (e.g., Alteryx, Fivetran, Azure Data Factory, Celigo).
• Consume and operationalize API-based data sources; experience with Postman and implementation approaches using SSIS and/or Python is preferred.
• Build maintainable pipelines with parameterization, environments, scheduling, monitoring, and operational runbooks.

• Serve as a strategic partner to functional leaders and Executive Leadership by translating business questions into well-defined analytics solutions and communicating insights clearly.
• Lead requirements discovery sessions to identify key data points, KPIs, trends, and decision workflows across the business.
• Frame and present performance narratives using period-based analysis (WoW, MoM, YoY) and planning concepts (plans, forecasts, goals) in partnership with Finance/FP&A.

• Understand and operationalize data from core enterprise platforms (e.g., CRM such as Salesforce; ERP such as NetSuite), including their data structures and relationships.
• Deliver trusted datasets and reporting for cross-functional teams such as Accounting, FP&A, Operations, Sales/Account Management, Revenue Operations, Marketing, and HR/HRIS.

• Lead, coach, and develop a diverse BI organization (e.g., database administration, data engineering/BI engineering, data warehousing, and ETL/integration) through mentorship, standards, and career development.
• Set an operating rhythm that balances delivery, quality, and sustainability (intake, prioritization, execution, documentation, and support).

• Plan and manage capacity, priorities, and delivery across a portfolio of BI initiatives, from quick-turn analysis to high-impact, enterprise reporting solutions.
• Apply project and service management practices (ITSM and Agile/Scrum), including change management, releases/deployments, and stakeholder communications.
• Use common delivery tooling (e.g., Jira preferred; Zendesk, Trello, Planner, Monday.com) to track work, manage dependencies, and report status.
• Define and execute the BI roadmap, including data platform capabilities, reporting standards, and a scalable operating model.
• Act as a hands-on technical leader for the BI stack (data modeling, ETL/ELT, warehousing, reporting/semantic layers) and be accountable for end-to-end solution quality.
• Establish governance for data definitions, KPIs, and reusable datasets; ensure a single source of truth and appropriate security/access controls.
• Partner with functional leaders to intake, prioritize, and deliver analytics needs; facilitate trade-off decisions based on impact, effort, and risk.
• Develop and mentor the BI team; set expectations, provide coaching, and build a culture of documentation, testing, and continuous improvement.
• Own production support for BI services (SLAs, incident response, root cause analysis, and preventative actions) and continuously improve reliability/performance.

• 10 + years of experience with a minimum of 5+ years in a managerial role developing staff and leading Business Intelligence partnerships with stakeholder management and delivery ownership.
• Strong SQL and data modeling skills with practical experience in data warehousing concepts (e.g., dimensional modeling, star schemas, data marts).
• Hands-on expertise in Power BI (report development, DAX, dataset/semantic modeling, refresh/gateway troubleshooting, and service administration).
• Experience designing and supporting data pipelines using SSIS and/or comparable ETL/ELT tooling.
• Ability to communicate technical topics to non-technical audiences and present insights to senior leaders.
• Experience working with cross-functional teams (e.g., Finance/FP&A, Accounting, Operations, Sales, Marketing, HR) and translating needs into data products.
• Database administration experience, including performance tuning, indexing strategy, and HA/DR concepts.
• Experience with SSRS/paginated reports and enterprise reporting operations.
• Experience consuming APIs and integrating external data sources using tools such as Postman, Python, or SSIS components.
• Familiarity with CRM and ERP platforms, preferably Salesforce, NetSuite, and their data models.
• Experience with agile delivery tooling (Jira preferred) and ITSM practices (intake, change management, incident/problem management).

• Mission-Driven Impact: Join a team passionate about making a difference and driving positive change.
• Growth and Development: We invest in your success with ongoing learning and career opportunities.
• Work-Life Balance: Enjoy flexible work options, generous PTO, and wellness support.
• Inclusive Culture: We foster a diverse, collaborative, and supportive workplace.
• Competitive Benefits: Receive competitive pay, comprehensive benefits, and employee recognition.