As the
Director of Business Intelligence, you will lead the Business Intelligence function-setting technical direction across data engineering, data warehousing, and analytics-and serve as a people leader and strategic partner to Senior Leadership and cross-functional stakeholders. This role blends hands-on technical leadership (architecture, troubleshooting, standards, and mentorship) with business partnership to deliver trusted, timely insights and scalable reporting capabilities that drive decision-making.
Tech Stack (Required) Deep expertise in the Microsoft SQL Server ecosystem, including SQL Server, SSIS, Power BI, and SSRS.What you will be doing:Databases & Data Quality- 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).
Data Warehousing- 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).
Database Administration & Performance- 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).
Business Intelligence & Reporting- 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.
Integrations & Automation (ETL/ELT)- 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.
Business Partnership & Executive Communication- 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.
Platform & Domain Knowledge- 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.
People Leadership & Talent Development- 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).
Delivery, Planning & Governance- 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.
Qualifications:- 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).
