Power BI Analyst

Galileo is a nationally recognized summer day camp that's all about empowering young innovators to change the world! With over 70 diverse communities served and hundreds of thousands of kids inspired since 2002, we are a leader in the Innovation Education Movement.

Here, innovation, purpose and personal development converge, creating an environment where your talents shine, and your impact is celebrated. We invest, test and continually iterate to sustain a culture that values Diversity, Equity, Inclusion, and Belonging. In fact, we were named one of the Best and Brightest Companies to work for in the Nation in 2023. We have also been on the Best Places to Work in the Bay Area list more than 12 times, were named one of Forbes’ Best Small Companies in 2017, and a Top 100 Real Impact Company in 2019.

If you are intrigued by innovation education, project-based learning, and working in a professional, welcoming, kid-centered environment, join us!

ABOUT THE JOB
As the Power BI Analyst, you will play a crucial role in harnessing the power of data analytics to develop comprehensive reports and visualizations, enhancing decision-making processes at Galileo Learning. This role requires a collaborative spirit, exceptional communication skills, and a strong technical background in data analysis and visualization.

YOU WILL BE ACCOUNTABLE FOR:

Data Analysis & Visualization

• Develop Interactive Dashboards: Design and implement interactive dashboards and visual reports using Power BI to meet organizational needs.

• Data Models & Insights: Identify and understand business requirements within the context of Business Intelligence (BI), developing data models to turn raw data into actionable insights.

• KPI Monitoring: Establish and monitor Key Performance Indicators (KPIs) to track and achieve specific objectives.

Technical Execution

• Power BI Development: Develop, test, and deploy Power BI scripts, conducting in-depth analyses to ensure efficiency.

• Advanced Data Manipulation: Utilize DAX queries and functions within Power BI for advanced data manipulation.

• Data Integration: Construct and maintain a data warehouse to consolidate various data sources. Employ SQL queries to extract and analyze data effectively.

Collaboration & Communication

• Report Presentation: Perform data analysis and present findings in clear, concise reports to support strategic decisions.

• Requirement Translation: Translate business requirements into technical specifications, outlining timelines for project milestones.

• Cross-functional Collaboration: Work closely with senior leaders, including the CFO, to define and align on data needs and project goals.

YOU ARE:

• Inspired by Galileo’s mission and purpose. Innovation education, project-based learning, and working in a professional, welcoming, deeply camp-inspired culture should sound like things you’re ready to explore or sign up for.

• A visionary collaborator; you can confidently contribute to the Galileo mission and have the team-oriented mindset to work with others to realize it effectively.

• Highly organized and detail-oriented, with a strong ability to manage multiple tasks and deadlines.

COMPENSATION

We anticipate total compensation for this Full-Time, exempt position to be $67,000-$83,000. Exact compensation may vary and will be based on multiple factors, including geography and professional experience. 

BENEFITS

• No-cost medical insurance for employees (additional plans and options to add dependents available at cost)

• Vision and Dental Insurance 

• 401k benefits after 1 year of employment

• Flexible Paid Time Off - time off is not limited, and we strongly recommend that employees take time off to rest and recharge. 

• Unlimited free camp for your child(ren), OR two free weeks to be gifted (including AM/PM Extended Care)

• Friends and Family Discount for Galileo Camps

• Priority scholarship nominations for Galileo Camps

• Generous parental leave and extensive support with leave planning

• Employee Assistance Program, options for life insurance, and more! 

WORK LOCATION

Remote, work-from-home, location is possible in the following states: California, Colorado, Illinois, Massachusetts, Texas, North Carolina, New York, or Washington. We are currently only able to employ candidates who are based in the states listed here.

Employees located in the San Francisco Bay area adhere to a hybrid office and work-from-home policy. Galileo Headquarters is located at 111 Myrtle St, Ste 300, Oakland, CA 94607. 

SCHEDULE & TIME COMMITMENT
This is a full-time position, averaging 40 hours per week. While we prioritize work-life balance, there may be times when additional hours are necessary to meet deadlines and ensure the success of our programs. Additionally, HQ staff are expected to visit camp locations from June through August to experience camp first-hand and support our teams on the ground; 10-15% travel may be required for those located outside of a camp territory.

PHYSICAL DEMANDS 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable people with disabilities to perform the essential functions.

• Occasionally lift and carry up to 30 lbs.

• Constantly operate a computer (including typing, reading)

• Frequently remain in a stationary position for extended periods of time

• Constantly communicate in-person, virtually, and from a range of distances

• 3+ years of experience in data analysis or business intelligence, with an emphasis on financial analysis.

• A Bachelor's degree in a relevant field such as Data Science, Computer Science, Information Systems, Statistics, or Finance is a plus but not required

• Having worked in summer camps, education or similar organizations is a plus!

• Proven experience with BI tools and systems, particularly Power BI.

• Strong background in data analysis and financial reporting.

• Familiarity with the Microsoft BI Stack and proficiency in MS SQL Server BI Stack tools and technologies such as SSRS, TSQL, Power Query, MDX, and DAX.

• Understanding of key financial concepts and the ability to apply them in data analysis.

• Excellent communication and collaboration skills, with the ability to build trust with stakeholders and resolve system-related challenges with empathy and true partnership.

We are committed to building a diverse and inclusive team and strongly encourage applications from individuals of all backgrounds and experiences. If you think you have what it takes to be successful in this role, we encourage you to apply.

During your onboarding process, you may need to complete a Tuberculosis (TB) screening, a background check, and mandated reporter training (California only). More details will be provided during your onboarding process.

COVID-19

All on-site employees will be required to demonstrate that they have been fully vaccinated against COVID-19, unless they qualify for an accommodation/exemption for medical, disability, or religious reasons. Vaccination status will be confirmed only after an offer of employment has been accepted and will not affect the consideration of any person’s application.

EQUAL OPPORTUNITY EMPLOYER

Galileo Learning is an Equal Opportunity Employer. We prohibit discrimination and harassment of any type and provide equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We comply with the ADA and provide reasonable accommodations that allow qualified applicants/employees to perform the essential functions of the job. To request accommodation, contact our People Services team. Please note that our job descriptions are only a summary of the typical functions of the job, not an exhaustive or comprehensive list of all possible responsibilities, tasks, and duties