Dashboard and Report Developer

Primary Function

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 responsibilities include:

• 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
• Onsite work location
• 1-3 years of experience designing and developing dashboards with MS PowerBI
• 1-3 years of MS SQL coding experience
• 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)