Director of Business Intelligence

About Learning Without Tears (LWT)

At Learning Without Tears, we’re more than just a company; we’re a passionate, family‑owned community on a mission to revolutionize education. We believe learning should be engaging and joyful, so we create innovative, fun products and digital resources that empower educators and inspire children. Every day we commit to collaboration, creativity, and change, simplifying processes to create lasting impact in the lives of educators and learners alike. Join our dynamic team and help shape the future of education together!

Role Overview

As the Director of Business Intelligence, you will lead the Business Intelligence function, set 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.

Databases & Data Quality

• Lead complex analysis and troubleshooting (e.g., reconciling deltas, missing data, dataset matching, 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 (linked servers, ODBC, remote SQL Server connections, PostgreSQL connectivity).

Database Administration & Performance

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

Business Intelligence & Reporting

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

Integrations & Automation (ETL/ELT)

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

Business Partnership & Executive Communication

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

Platform & Domain Knowledge

• Understand and operationalize data from core enterprise platforms (CRM such as Salesforce; ERP such as NetSuite), including data structures and relationships.
• Deliver trusted datasets and reporting to 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 (database administration, data engineering/BI engineering, data warehousing, ETL/integration) through mentorship, standards, and career development.
• Set an operating rhythm balancing delivery, quality, and sustainability (intake, prioritization, execution, documentation, support).

Delivery, Planning & Governance

• Plan and manage capacity, priorities, and delivery across a portfolio of BI initiatives.
• Apply ITSM and Agile/Scrum practices, including change management, releases/deployments, and stakeholder communications.
• Use delivery tooling (Jira preferred; Zendesk, Trello, Planner, Monday.com) to track work and report status.
• Define and execute the BI roadmap, data platform capabilities, reporting standards, and operating model.
• Act as a hands‑on technical leader for the BI stack 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 controls.
• Partner with functional leaders on intake, prioritization, and analytics delivery; facilitate trade‑off decisions based on impact, effort, risk.
• Own production support for BI services (SLAs, incident response, root cause analysis, preventive actions) and continuously improve reliability.

Qualifications

• 10+ years of experience with a minimum of 5+ years in a managerial role developing staff and leading Business Intelligence partnerships.
• Strong SQL and data modeling skills with practical experience in dimensional modeling, star schemas, data marts.
• Hands‑on expertise in Power BI (report development, DAX, dataset/semantic modeling, refresh/gateway troubleshooting, 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 (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 Postman, Python, or SSIS.
• 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).

Why Work with Us?

• Mission‑Driven Impact: Drive positive change.
• Growth and Development: Ongoing learning and career opportunities.
• Work‑Life Balance: Flexible work options, generous PTO, wellness support.
• Inclusive Culture: Diverse, collaborative workplace.
• Competitive Benefits: Competitive pay, comprehensive benefits, employee recognition.

Apply now at

Learning Without Tears is an Equal Opportunity and Affluent Action Employer.

Salary: $145,000 - $165,000 per year

Job Posted by ApplicantPro

#J-18808-Ljbffr