Business Intelligence Developer at PRS Holdings Inc. – Jurupa Valley, California

Pavement Recycling Systems is the Western United States premier provider of Recycling Solutions to reclaim, preserve, and rehabilitate pavement at any stage. Becoming a team member of PRS introduces you to a unique culture of employee ownership and empowerment to grow and succeed in your career. We create an environment in which all employees develop and contribute to their full potential and we recognize and reward outstanding results.

Position overview

The Business Intelligence Developer is responsible for designing, developing, implementing, and supporting reporting, analytics and business intelligence solutions utilized to support the company’s business analytical and reporting needs. The position will also be responsible for building analytical solutions. Design and develop complex reports and dashboards to meet business requirements. Build scorecards, dashboards, ad hoc and standard reports. Create and/or enhance report objects, metrics, filters, and prompts. Collaborate with solutions analysts and end users to define requirements and reporting specifications and provide technical report assistance. Provide second-line support for users who develop reports on behalf of their departmental colleagues. Validate reporting results against requirements. Troubleshoot and analyze data issues within reports. Ensure optimal end-user performance by establishing and consistently executing overall system performance assessment processes and associated action plans.

Primary Responsibilities

• Design, implement, and maintain data warehouses using SQL Server Replication, SSIS, SSAS, and T-SQL scripting.
• Creates, maintains and updates business intelligence solutions, reports, dashboards, and scorecards.
• Lead projects, developing technical requirements, defining scope, implementation, and testing as needed.
• Focused on identifying solutions to business problems and needs, very knowledgeable across products, customer facing in recommending solutions, expert in data analysis, and extremely independent.
• Consulting directly with business users, IT team members and decision-makers to gather requirements and define scope.
• Researches and recommends business intelligence solutions and frameworks designed to support the mission, vision, and values of the organization.
• Use data mining, model building and other analytical techniques to develop and maintain predictive models to drive the business.
• Creates and maintains effective, detailed design documentation.
• Plans and facilitates meetings. Estimates and plans project deliverables.
• Coordinates and conducts training and testing for solution analysts and other end-users.
• Identifies critical areas of the data structure and recommends improvements to existing reports and reporting processes.
• Prioritize multiple tasks effectively and communicate progress well among teams.
• Performs other duties as assigned

Required Knowledge, Skills/ Abilities and education

• 5 years of IT experience in reporting/analytics. Minimum of 5 years of relevant work experience working with SQL Server.
• Bachelor’s degree or higher in Computer Science, Information Management or similar required.
• 3+ years of Power BI development, including building and managing Reports, Scorecards and Dashboards.
• 3+ years using BI best practices, methodologies, relational structures, dimensional data modelling, OLAP technologies, data warehouse and reporting techniques.
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Understanding of Business ERP Processes (Finance, Supply Chain, Job Costing, etc.).
• Experience with D365 F&O a plus.
• Bachelor’s degree or higher in Computer Science, Information Management or similar required.

Why Join

• ESOP Retirement Benefits are extended to all employees with participation after one year of service. A typical discretionary annual company contribution can range from 10% to 15% of your annual salary.
• 401K Retirement Benefits are extended
• Health, Dental, and Vision as well as other supplemental health insurance.
• PTO
• Holiday Pay
• Opportunities for career advancement
• On the job training provided to all employees
• Work for an industry leader in various disciplines and markets

Physical Requirements

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 accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to:

• While performing the duties of this job, the employee is regularly required to use hands to finger, handle, feel or operate objects, tools, or controls and reach with hands and arms. The employee frequently is required to stand, walk and talk or hear. The employee is regularly required to sit; climb or balance; stoop, kneel, crouch, or crawl; and smell
• The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus

We are an equal opportunity employer and give consideration for employment to qualified applicants without regard to age, race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, marital status, disability or protected veteran status, or any other status or characteristic protected by federal, state, or local law.