Senior BI Engineer

About NCSA College Recruiting

NCSA College Recruiting is the world largest college recruiting platform, providing student-athletes content, tools, coaching and access to a network of 40,000 college coaches across 37 sports. NCSA is an online experience of IMG Academy, the world’s leading sports education brand and one of Sports Business Journal's Best Places to Work in Sports in 2024. IMG Academy provides a holistic education model that empowers student-athletes to win their future, preparing them for college and for life. Additional on-campus and online experiences include:

• Boarding school and camps, via a state-of-the-art campus in Bradenton, Fla.
• Online coaching via IMG Academy+, with a focus on personal development through the lens of sport and performance

Position Summary:    
The Senior BI Engineer will be responsible for designing and implementing business intelligence solutions as part of the BI Team. The team provides data, analysis, insights and recommendations in support of the company's data-driven decision-making culture in sales, operational, financial and product domains. The Senior BI Engineer is responsible for integrating cross-functionally across the organization to understand business goals, define questions, and develop methods for answering them. The position makes use of multiple data sources and analysis tools to construct analytical outputs, reporting and dashboards in support of daily operations, new initiatives, and the development of proprietary predictive models. Working closely with the Data Engineering team and the Platform Development Manager for data infrastructure, the Senior BI Engineer is responsible for implementing ongoing support for the IMG’s BI platform. The position serves as an enabler for decision-making around one or more major areas of business focus, providing key insights for senior management, operational leaders, and the Product and Technology teams. 
 
 
Position Responsibilities:

• Build BI solutions to implement business needs via our preferred data stack (Tableau, dbt, Redshift) 

• Use visualization tools to communicate stories with data, creating reporting, dashboards, KPI monitoring and self-service tools to make data and insights available for stakeholders. 

• Facilitate the acquisition and integration of data from multiple data sources, performing exploratory analysis to identify data relationships including trends, patterns and correlations; mature these analyses into more formalized frameworks and models. 

• Support the monitoring of ETL processes to ensure the quality, accuracy and timely delivery of reports. 

• Lead the BI team in cultivating cross-functional partnerships across departments, bringing insights to every corner of our operation as part of a collaborative, collegial learning culture. 

• Be prepared to manage other members of the BI team. 

• Support leadership in Marketing, Sales Operations, Sales, Operations, Product and Technology to implement analytics business requirements. 

• Partner with data analysts and data engineers to identify and address limitations in data sources, data quality, tooling, or performance bottlenecks in analytics delivery. 

• Develop, promote, and maintain awareness of the business context and dynamics surrounding each of the company’s business units, their products and services, the data they generate and the relationships between them. 

Knowledge, Skills and Abilities:

• Bachelor's degree or equivalent experience (Bootcamps, Certifications, Training Courses).

• 5 to 7 years of BI development experience.
• Experience with a data analytics programming language like Python or R to a level of teaching others. 

• Deep experience with composing complex SQL queries for relational databases. 

• Hands-on experience building custom visualizations using tools like Tableau or Power BI. 

• Understanding of ETL/ELT and data orchestration concepts. 

• Experience with modern data warehouse tools like Redshift, Snowflake, or Big Query. 

• Experience with data modeling and schema definition for data lakes and warehouses. 

• Experience working cross-functionally in situations requiring collaboration, negotiation and communication of complex analyses to non-technical or senior management audiences. 

• Experience working as a team player; always looking to make things better and easier for co-workers. 

• Excellent visual, verbal and textual communication and presentation skills; extremely strong skills for using data to tell stories, especially counter-intuitive or controversial ones. 

• Some awareness and understanding of cloud-based environments (AWS preferred) 

• Highly self-motivated, self-directed, resourceful and autonomous; capable of managing multiple simultaneous deliverables with proactive status updates and requests for support. 

• Strong problem-solving skills with the ability to quickly and efficiently pinpoint and resolve problematic issues. 
• Experience leading other BI engineers with driving technical leadership for a BI team 

• Experience supporting critical analytics delivery in a fast-paced environment. 

• Experience working across functional, product and engineering teams. 

• Experience with distributed version control and software development lifecycle methods. 

• Exposure to Agile Development or the Scrum project management methodology. 

#LI-TR1