Lead BI Engineer

Come join our Goddard Systems, LLC (GSL) corporate team! We are a great place to work and offer many employee-friendly perks and benefits. GSL is the manager of the Goddard School franchise system that supports over 600 schools which delivers a high-quality, play-based learning program to families all over the United States. Our successful franchise business model supports franchisees through partnerships with teams of seasoned professionals who draw over 30 years of business, marketing, IT, franchise, finance, and education experience. Because of this, The Goddard School has grown into an institution that parents and families trust, reaching more than 80,000 students in 38 states - and growing.

Position Summary

As a Lead BI Engineer, the candidate will be responsible in analyzing raw data, developing, and maintaining datasets, improving data quality and efficiency and build various data visualizations. The engineer needs to have strong analytical skills and will involve various methods to integrate different data sources, transform data into useful business drivers. Candidate should be able to work across projects involving multiple stakeholders. Having strong technical and programming skills while working with business, architects, partners to resolve complex system issues.

Responsibilities

• Specify, design, build, and support data warehousing and BI solutions.
• Create dashboards and KPIs to show the business performance to management.
• Design and maintain data models used for reporting and analytics.
• Help the broader team identify new features and business opportunities through your analysis.
• Enable self service capabilities within the BI tools for users to be able to slice and dice information as needed.
• Build various data visualizations to tell the story of trends, patterns, and outliers.
• Monitor and tunes BI tools to ensure optimum level of performance.
• Provide updates to customers, business, and staff on a timely basis for projects and tasks.
• Analyze existing reports and optimize them for standardization across the company.
• Ensure data accuracy by validating data for new and existing tools.

Minimum Requirements

• Bachelor's or Graduate's Degree in computer science, engineering, mathematics, or information systems.
• 8+ yrs Experience with SQL, SQL Server, ETL, SSRS, SSIS, PowerBI, SSAS software, systems, and programs.
• 8+ yrs Experience with Agile, Python, Datawarehouse (Azure Data warehousing), Azure Cloud, TSQL, and R language software and systems.
• 6+ yrs Experience with Data ingestion, Data processing and Data publishing methodologies
• Fluent in statistics, datasets, and scripting.
• Understanding data modeling, data schemas (normalized, flat, star, snowflake, etc.).
• Understanding database operations and optimization for RDBMS like SQL Server

Highly Desired

• Master's in computer science or related field is a plus.
• Business Intelligence certifications is a plus.

There will be periodic requirements to travel for in-person events, at the discretion of your manager or the requirement of the company.