PowerBI Developer / Data Scientist at Focus School Software

See all the jobs at Focus School Software here: http://focusschoolsoftware.recruiterbox.com/jobs

PowerBI Developer / Data Scientist

St. Petersburg, Florida, United States | Full-time | Fully remote

PowerBI Developer / Data Scientist position

Focus School Software is a fast-growing school management software company. We thrive on creating some of the most innovative features on the market today, helping educators to meet their evolving needs in classrooms, district management, state reporting compliance, and other facets of student-centered education and technology.

Currently, Focus is looking for energetic, creative, and experienced candidates who can help us succeed in our mission to serve an increasing number of districts across the nation. We keep our clients’ needs at the forefront of everything we do. As a company who understands the hard work of today’s educators, Focus looks for employees who share our values towards education.

Focus School Software is looking to expand our team by hiring a PowerBI Developer / Data Scientist to work with our team. This person will help support our Analytics product which includes dozens of dashboards analyzing student data to help educators target interventions and improve their educational processes. This position may be occasionally customer facing - providing training and professional growth opportunities. The best candidate will display leadership capabilities to help drive data-decision making processes within Focus and our customers. *** Please note, in order to be considered for this position you must complete the quiz.

Minimum Qualifications:

2+ years' experience as a PowerBI developer, data scientist, data analyst or data engineer
Experience with PowerBi Analytics, creating dashboards, Data Analysis Expressions (DAX)
Strong SQL skills
Strong writing and communication skills
Experience with statistical research and analytics techniques (i.e. classification, clustering, regression, segmentation, etc.)

Nice to have:

A passion and interest in the development of Educational software
Knowledge of school district processes and functionality is helpful

Job Responsibilities include:

Undertake preprocessing of structured and unstructured data
Analyze large amounts of data/information to discover and articulate trends and patterns
Collecting data through means such as analyzing business results or by setting up and managing new studies
Transferring data into a new format to make it more appropriate for analysis
Searching through large data sets for usable information
Solve large, complex problems to achieve interrelated and interdependent objectives
Creating reports and presentations for business uses
Correlating similar data to find actionable results

Focus School Software’s compensation package offers the following benefits:

Medical Insurance
Dental/Vision Insurance
Life Insurance
Short and Long Term Disability Insurance
401(k) after 6 months
Paid Holidays
Paid Vacation and Sick Time
Remote Position

Application Form

First Name *

Last Name *

Email *

Phone *

Cover Letter

Resume *

LinkedIn Profile

What is your salary requirement? *

SEE GOOGLE DOC AT THIS LINK FOR TABLES: https://docs.google.com/spreadsheets/d/1nEnydNy1PgRZO9WSSWl2HlLPCdqvhcfShGrEeesblRM/edit#gid=0

1. A record needs to be added to the STUDENTS table. Where acceptable values for GENDER are ‘1’ for Male and ‘2’ for Female Write a query to create a record in STUDENTS for the following data: Student ID: 6100002349 Last Name: SMITH First Name: JOHN GENDER: MALE *

2. A data fix needs to be applied to the STUDENT_REPORT_CARD_GRADES table. Write a query that changes the columns GPA_POINTS and WEIGHTED_GPA_POINTS to ‘4.00’ only when the column GRADE_TITLE has a value of ‘A’ and the column COURSE_HISTORY is flagged ‘Y’ *

3. You have the following tables. Write a query that lists the number of A’s for each Course *

4. Look at the STUDENT_SCHEDULE table. Write a query that eliminates the records in the table where the YEAR is 2012 or there’s no value in the ACTIVE column *

5. Write a query that lists all of the Marking Period IDs from the following 3 tables *

6. Review the tables below and write a query to list all the students and their scores for the ACT Tests that were administered on April 01, 2014 *

7. There are 500 records on the STUDENTS table (TABLE A) and you need some test data from it so you decide to create your own temporary table (TABLE B) to work with. Write a query that creates exactly 100 Student records in Table B from Table A, where students have a value in the STUDENTS.EMAIL column *

8. After running the above query (Question 7) you notice that values for GENDER have been stored as M, MALE, F, and Female. You need to write a query that lists the Students and their Gender, but you need to display Male as ‘1’ and Female as ‘2’. How would you accomplish this? *

9. You need to update a typo in a student’s last name. You run this query during business hours on a production database: Update students set last_name = ‘Smythe’; where student_id = ‘123456’; What would you do to prevent/fix this problem? *

10. You have the table STUDENT_GRADEBOOK_GRADES that stores Student’s assignment grades. Write a query to display a list of Student IDs that have gotten 100’s for their Math, Science, or English courses (MAT, SCI, ENG) *

See all the jobs at Focus School Software here: http://focusschoolsoftware.recruiterbox.com/jobs

Apply for this opening at ?apply=true

See all the jobs at Focus School Software here: http://focusschoolsoftware.recruiterbox.com/jobs

Application Form