Dashboard and Report Developer

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. Company Description The Morning Star Company and its affiliates operate three tomato processing facilities in Central California, processing 35% to 40% of the California processing tomato crop, in addition to tomato transplanting, harvesting and trucking operations. The company employs approximately 400 year-round and 2,000 seasonal colleagues and annual sales of approximately $1 billion. The Morning Star Company is the largest independent producer of bulk tomato ingredient products (tomato paste and diced tomatoes) in the world. We also produce canned tomatoes, tomato products and specialty sauces in pouches for customers in the retail and food service markets. The company is known worldwide for its innovation and integrity. We are organizationally structured through a system we term Mission Focused Self- Management™. Our company is operated by colleagues without titles or an appointed hierarchy of authority. Authority relative to other colleagues’ activities is lateral, with our Mission as our guiding principle of action, and respect, influence and success built based on each colleague’s integrity, competency, effort, persistence, and straightforward persuasiveness. Although we have grown significantly, we intend to maintain a culture of individual responsibility and self-management. 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 Resume strength: Through 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 All your information will be kept confidential according to EEO guidelines. The Morning Star Company and its affiliates participate in E-Verify. #J-18808-Ljbffr The Morning Star Company