Business Intelligence Developer

Folsom, CA, United States

Overview

As a Business Intelligence Developer , you will play a crucial role in driving data-driven decision-making within our organization. You will be responsible for designing, developing, and maintaining business intelligence solutions that empower stakeholders to extract actionable insights from complex datasets. Your primary focus will be on engineering analytics tools and solutions, including the development of interactive dashboards, reports, and data visualizations.

Responsibilities

Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Analytics Tool Engineering: Design, develop, and maintain scalable analytics tools and solutions that enable efficient data analysis and visualization.

Dashboard Development : Create interactive and user-friendly dashboards using BI tools such as DOMO, CRMA, Tableau, or similar platforms. Collaborate with stakeholders to understand requirements and translate them into intuitive dashboard designs.

Data Modeling: Develop data models and structures to support efficient data retrieval and analysis. Optimize data architecture for performance and scalability, ensuring seamless integration with various data sources.

ETL Development: Design and implement ETL processes to extract, transform, and load data from disparate sources to and from the data warehouse. Ensure data quality and integrity throughout the ETL pipeline.

Report Generation: Generate ad-hoc and scheduled reports based on business requirements. Customize reports to provide actionable insights to different business units and stakeholders.

Data Visualization: Create compelling data visualizations that communicate insights effectively. Utilize best practices in data visualization to present complex information in a clear and understandable manner.

Performance Optimization: Identify opportunities to enhance the performance and efficiency of existing BI solutions. Implement optimizations to streamline data processing and improve user experience.

Collaboration: Collaborate with cross-functional teams including data engineers, data analysts, and business stakeholders to understand requirements and deliver solutions that meet business objectives.

Other duties as assigned

Qualifications

To be considered for and to perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required.

Qualifications include: Bachelor's degree in Computer Science, Information Systems, or related field.

Proven experience in business intelligence development, analytics engineering, or related roles.

Proficiency in SQL for data querying and manipulation.

Experience with BI tools such as Tableau, Power BI, QlikView, or similar platforms.

Strong analytical and problem-solving skills, with the ability to translate complex requirements into practical solutions.

Familiarity with data warehousing concepts and ETL processes.

Proficiency in Python for data analysis, scripting, and automation tasks.

Knowledge of API integration for data extraction and integration.

Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment

Environmental Factors Constant collaborative work environment

Frequent social interactions and interruptions

Frequent work under time restraints

No travel

Physical Requirements

Lifting/Carrying: Occasionally carrying items weighing under 10 lbs.

Rarely carrying items weighing between 11-20 lbs.

Twisting/Turning: Occasionally reaching over shoulder, overhead and reaching outward

Occasionally bending

Frequently walking normal surfaces

Constant sitting

Other: Constant use of keyboard, fine dexterity, grasping, holding

Constant repetitive motion - hands

Compensation & Benefits

PowerSchool offers the following benefits:

Comprehensive Insurance Coverage (including Medical, Dental, Vision, Pharmacy benefits, Life Insurance and AD&D)

Flexible Spending Accounts and Health Savings Accounts

Short-Term Disability and Long-Term Disability

Comprehensive 401(k) plan

Generous Parental Leave

Unrestricted paid time off (known as Discretionary Time Off - DTO)

Wellness Program, including ClassPass & Employee Assistance Program

Tuition Reimbursement

Optional Benefits: Pet Insurance, Identity Theft Protection, Student Debt Repayment Program and Prepaid Legal coverage

A reasonable estimate of the base compensation range for this position is $81,000 - $100,000.

The compensation range is specific to the United States and incorporates many factors including but not limited to an applicant's skills and prior relevant experience and training; licensures, degrees, and certifications; internal equity; internal pay ranges; and market data/range parameters.

EEO Commitment

PowerSchool is committed to a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce, we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process, please let us know by emailing [email protected].

#LI-RS1

#LI-REMOTE

#LI-HYBRID