Business Intelligence Engineer

PLEASE NOTE: Your application will expire one year from the time of submission. Please feel free to apply to any other positions for which you may qualify.

Our team members enjoy competitive salaries, a well-rounded benefits package, generous paid time off (including 25 holidays, vacation, and sick leave), and an array of professional development opportunities.  We’re always looking to add to our team of more than 3,000 dedicated professionals who are leading online education worldwide with transformative digital solutions – personalized to every student.  

Job Posting End Date:

Deadline to apply is 11:59 PM on

05-05-2025

Job Title:

Business Intelligence Engineer

Contract Type:

Employee

Annual Salary:

$69,591.00 - $137,790.00

(Support staff salary will be based on internal equity and experience)

Location:

FL - HOME OFFICE

Job Description Summary:

Our Mission is to equip students for success by developing and delivering highly effective digital learning through an intuitive online platform.

FLVS does not discriminate in admission or access to, or treatment or employment in its programs and activities on the basis of race, color, religion, age, sex, national origin, marital status, disability, genetic information or any other reason prohibited by law.

The Position:

Position General Summary:

The BI Engineer will play a pivotal role in designing, developing, and maintaining our data infrastructure, transforming raw data into meaningful insights that drive informed business decisions. This position’s  primary focus is collecting, storing, processing, and transforming data into formats suitable for analysis and reporting. This position will collaborate closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to deliver high-quality solutions that empower our organization.

Essential Position Functions:

Data Integration and Transformation:

• Design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into our data warehouse.

• Collaborate with data engineers and analysts to ensure data accuracy, consistency, and completeness.

• Collaborate with stakeholders to enforce governance and data security policies.

• Design and implement data quality checks and validation procedures to uphold data integrity.

Data Modeling and Architecture:

• Design and optimize data models to support efficient querying and reporting.

• Collaborate with cross-functional teams to identify data requirements and create data structures that align with business needs.

• Design, develop, and maintain queries for data cubes, data marts, and report solutions to facilitate effective data analysis and reporting.

• Develop complex SQL queries and data transformations to extract insights from large datasets.

Reporting and Visualization:

• Design and develop data views, functions, and procedures for reporting data marts, and AI decision making.

• Support ad-hoc queries, interactive dashboards, and reports using BI tools (e.g., SSMS, SSRS, Power BI and Visual Studio) to enable self-service analytics.

• Collaborate with users to provide guidance and understand their data needs for data visualization or analysis.

Performance Optimization:

• Monitor and optimize the performance of BI systems, including query performance, data loading, and report generation.

• Implement data governance practices to ensure data accuracy, security, and compliance.

• Collaborate with cross-functional teams, including data scientists, analysts, and developers, to deliver BI solutions.

• Foster a culture of innovation and continuous learning within the Data Services team.

• Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrating respect for others.

• All work responsibilities are subject to having performance goals and/or targets established.

 (These essential functions are not to be construed as a complete statement of all duties performed. Employees will be required to perform other job related duties as required.)

Minimum Requirements:

Education/Licensure/Certification:

• Bachelor's degree in Computer Science, Information Systems, or a related field; or equivalent combination of education and relevant experience

Experience:

• 5+ years of progressive experience as a BI Engineer or similar role, with a focus on innovative development, performance, and analysis

• 3+ years as a Project Manager or Team Leader preferred

• 5 years of experience in executing SQL queries and stored procedures

• 5 years of experience with SQL Server and/or Azure Data Warehouse environment

• 5 years of experience developing and maintaining database procedures, views, and functions

• 5 years working with cloud data storage and databases

• 3 years of experience in data analytics

• 2 years of DevOps experience and CI/CD methodology

• Experience with Azure, Data Vault 2.0

• Experience with HR, Education, and/or Finance data

Knowledge, Skills, and Abilities (KSA's):

• Strong proficiency in SQL, ETL processes, and data warehousing concepts

• Solid understanding of data visualization principles and best practices

• Familiarity with cloud-based data technologies (e.g., AWS, Azure, Google Cloud Platform) is desirable

• Knowledge of logical data modeling concepts (Dimensional, 3NF, Data Vault 2.0) preferred

• Ability to work with large volumes of data from multiple sources

• Ability to write complex SQL queries: TSQL knowledge

• Strong written and verbal communication skills

• Strong interpersonal skills

• Excellent customer service skills

• Strong organizational skills

• Demonstrative skill in attention to detail

• Ability to function effectively in a high demand environment

• Ability to work independently and as a team member

• Ability to compile, review, categorize, prioritize, analyze, and interpret data and/or information

CORE COMPETENCIES FOR SUCCESS:

COMMUNICATION SKILLS

Clearly and effectively conveys and/or presents information verbally; summarizes what was heard to mitigate miscommunication;  Shares ideas and perspectives and encourages others to do the same; Informs others involved in a project of new developments; Disseminates information to other employees, as appropriate; Effectively uses multiple channels to communicate important messages; Keeps supervisor well informed about progress and/or problems in a timely manner; Writes in a clear, concise, organized and convincing way for a variety of target audiences; The written message is consistently error-free; The written message has the desired effect on the target audience  

     

CUSTOMER FOCUS

Prioritizes customers (internal and external)  and their needs as primary and is dedicated to meeting their expectations; Develops and maintains customer relationships; builds credibility and trust; Quickly and effectively solves customer problems; Provides prompt, attentive service in a cheerful manner; adapts to changing information,  conditions or challenges with a positive attitude; Incorporates customer feedback into delivery of service to provide the best experience possible for the customer; Actively promotes our organization in the community by serving as an ambassador or volunteer

INTERPERSONAL SKILLS

Relates well with others; Treats others with respect; Shares views in a tactful way; Demonstrates diplomacy by approaching others about sensitive issues in non-threatening ways; Considers and responds appropriately to the needs, feelings and capabilities of others; Fosters an environment conducive to open, transparent communication among all levels and positions; Takes the initiative to get to know internal and external customers

               

FUNCTIONAL /TECHNICAL EXPERTISE

Has the skills, abilities, knowledge and experience to be successful in functional area of expertise; Dedicates time and energy to keeping abreast of the latest information related to area of expertise and technology; Picks up on technology quickly; Does well in technical courses and seminars; Produces high quality work in organized and timely fashion

INDIVIDUAL CONTRIBUTOR COMPETENCIES FOR SUCCESS:

PEER RELATIONSHIPS

Finds common ground and solves problems for the good of all; Can represent his/her own interests and yet be fair to other groups; Solves problems with peers with minimal “noise”; Is seen as a team player and is cooperative; Easily gains trust and support peers; Encourages collaboration; Is candid with peers   

    

CREATIVITY

Comes up with a lot of new and unique ideas; Easily makes connections among previously unrelated notions; Tends to be seen as original and value-added in brainstorming sessions; Takes calculated risks; Is not afraid to try new things and potentially “fail fast”

SELF KNOWLEDGE

Seeks feedback; Gains insight from mistakes; Is open to constructive criticism; isn’t defensive; Proactively seeks to understand his/her strengths and areas for growth; applies information to best serve organization; Recognizes how his/her behavior impacts others and incorporates insight into future interactions

PLANNING

Accurately scopes out length and difficulty of tasks and projects; Sets objectives and goals; Breaks down work into the process steps; Develops schedules and task/people assignments; Anticipates and adjusts for problems and roadblocks; Measures performance against goals; Evaluates results

ORGANIZING

Uses his/her time effectively and efficiently; Concentrates his/her efforts on the more important priorities; Can attend to a broader range of activities as a result of organizing time efficiently; Can marshal resources (people, funding, material, support) to get things done; Can orchestrate multiple activities at once to accomplish a goal; Arranges information and files in a useful manner

PROBLEM SOLVING

Uses rigorous logic and methods to solve difficult problems with effective solutions; Probes all fruitful sources for answers; Can see hidden problems; Is excellent at honest analysis; Looks beyond the obvious and doesn’t stop at the first answers

DRIVE FOR RESULTS

Can be counted on to exceed goals successfully; Very bottom-line oriented; Steadfastly pushes self and others for results; Is full of energy for the things he/she sees as challenging; Not fearful of acting with a minimum of planning; Consistently seizes opportunities; Consistently exceeds goals   

Physical Requirements and Environmental Conditions:

• Remote position

• Frequency of travel:  Occasional travel is required for meetings, trainings and conferences; location may vary and may require overnight stays

• Light physical activities and efforts required working in an office environment

(Reasonable accommodations will be made in accordance with existing ADA requirements for otherwise qualified individuals with a disability.)