Dashboard / Report Developer (On-prem!)
Woodland, CA
No remote, no relocations, no sponsorship.

The nature of this role is not conducive to working remotely. This Colleague will work with many people in all areas of our complex operation. You will drive the health of this Self-Managed operation, impacting our improvement and growth. You won't succeed in that if you aren't on-site with the rest of us.

The Opportunity
The Mission of this colleague will be to provide all Colleagues ready access to accurate and timely reports in order to improve Colleague productivity.
This role will be based in our Woodland office. Our ideal person for this role will combine the needed technical skill with a genuine curiosity to understand and explore the context of the data being reported. These, along with a true service orientation will make for the superstar we want to meet.

The SQL Report Developer is primarily responsible for creating and maintaining the company's Microsoft Business Intelligence reporting products used by Accounting/Administration, Manufacturing and Agricultural colleagues. Additional responsibilities include query/report development and maintenance, and data warehouse design and implementation.

Primary Function

• Design, develop and maintain dashboards and reports using Microsoft PowerBI and SQL Server Reporting Services (SSRS)
• Design, develop, and maintain databases and store procedures using Microsoft SQL Server Management Studios (SSMS)
• Build required infrastructure for optimal extraction, transformation, and loading of data from various data sources
• Manage the distribution of reports with scheduled and data driven subscriptions
• Work with limited database documentation to build accurate queries directly in SQL. This may require some reverse engineering of existing stored procedures and reports written by other colleagues and developers to fulfill requirements.
• Work with Business Unit colleagues to determine development needs for data automation, dashboards, and reporting requirements under tight timelines.
• Provides status reports that give a detailed description of the current projects progress and indicates time devoted to each task.

Qualifications

• US work authorization (Required)
• Onsite work location (Required)
• 1-3 years of experience designing and developing dashboards with MS PowerBI
• 1-3 years of MS SQL coding experience

If you happen to have experience with the following, we consider it a plus:

• MS Fabric, Lakehouse, Notebook, and Semantic Modeling
• Designing and maintaining data warehouses and data pipelines
• Query optimization, indexes, and performance tuning techniques
• SQL Server Integration Services and Analysis Services (SSIS/SSAS)

Compensation: Salary will be $75,000 - $100,000 DOQ

Additional Information
Videos To Watch
https://www.youtube.com/watch?v=qqUBdX1d3ok&t=1s