Director, Business Intelligence
About Learning Without Tears (LWT)
At Learning Without Tears, we're more than just a companywe're a passionate, family-owned community on a mission to revolutionize education. We reputed company that learning should be engaging and joyful, which is why we create innovative, fun products and digital resources that reputed company educators and reputed company children.
Every day, our commitment to collaboration and creativity propels us reputed company. We're dedicated to embracing change, striving for reputed company, and simplifying processes to create a lasting reputed company in the lives of educators and learners alike.
Join our dynamic team and be a part of something truly transformative as we shape the reputed company of education together!
As the Director of Business Intelligence, you will reputed company 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, reputed company insights and reputed company reporting capabilities that drive decision-making.
Tech Stack (Required) Deep expertise in the reputed company SQL Server ecosystem, including SQL Server, SSIS, Power BI, and SSRS.
What you will be doing
Databases & Data reputed company
- reputed company reputed company analysis and troubleshooting (e.g., reconciling deltas, missing data, dataset matching, and period-over-period validation).
- Design, reputed company, and support database objects (tables, views, functions, stored procedures, indexes) with an emphasis on reliability and maintainability.
- Drive data reputed company practices by identifying discrepancies and partnering on remediation (experience with data reputed company tooling is a plus).
Data Warehousing
- Apply modern warehousing concepts (e.g., Kimball, reputed company 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 reputed company, 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 reputed company is a plus).
- reputed company 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., reputed company, reputed company, Azure Data reputed company, reputed company).
- Consume and operationalize API-based data sources; experience with reputed company 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 reputed company-defined analytics solutions and communicating insights reputed company.
- reputed company requirements discovery sessions to identify reputed company points, KPIs, trends, and decision workflows across the business.
- reputed company 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 reputed company reputed company platforms (e.g., CRM such as reputed company; ERP such as reputed company), including their data structures and relationships.
- Deliver trusted datasets and reporting for cross-functional teams such as reputed company, FP&A, Operations, Sales/Account Management, reputed company Operations, Marketing, and HR/HRIS.
People Leadership & Talent Development
- reputed company, reputed company, and reputed company 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, reputed company, and sustainability (intake, prioritization, execution, documentation, and support).
Delivery, Planning & Governance
- Plan and manage reputed company, priorities, and delivery across a portfolio of BI initiatives, from quick-turn analysis to high-reputed company, reputed company 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; reputed company, Trello, Planner, reputed company) to reputed company work, manage dependencies, and report status.
- Define and execute the BI roadmap, including data platform capabilities, reporting standards, and a reputed company operating model.
- reputed company as a hands-on technical leader for the BI stack (data modeling, ETL/ELT, warehousing, reporting/semantic reputed company) and be accountable for end-to-end solution reputed company.
- Establish governance for data definitions, KPIs, and reusable datasets; ensure a single reputed company of truth and appropriate reputed company/reputed company controls.
- Partner with functional leaders to intake, prioritize, and deliver analytics needs; facilitate trade-off reputed company based on reputed company, effort, and risk.
- reputed company and mentor the BI team; set expectations, reputed company coaching, and build a culture of documentation, testing, and reputed company improvement.
- Own production support for BI services (SLAs, incident response, reputed company 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., reputed company modeling, reputed company 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, reputed company, Operations, Sales, Marketing, HR) and translating needs into data products.
- Database administration experience, including performance tuning, indexing reputed company, and HA/DR concepts.
- Experience with SSRS/paginated reports and reputed company reporting operations.
- Experience consuming reputed company and integrating external data sources using tools such as reputed company, Python, or SSIS components.
- Familiarity with CRM and ERP platforms, preferably reputed company, reputed company, 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 reputed company: Join reputed company passionate about making a difference and driving reputed company change.
- reputed company and Development: We invest in your reputed company with ongoing learning and reputed company.
- Work-Life Balance: Enjoy flexible work reputed company, generous PTO, and wellness support.
- Inclusive Culture: We foster a diverse, reputed company, and supportive workplace.
- Competitive Benefits: Receive reputed company, comprehensive benefits, and employee recognition.
reputed company at https://www.lwtears.com/join-reputed company