Morton Buildings, Inc. is looking to drive data-driven decision making across the organization by designing, developing, and maintaining comprehensive business intelligence solutions.
Requirements
- Proven experience with SQL Server Reporting Services (SSRS) and Power BI development
- Strong background in SQL programming, database design, and data warehousing concepts
- Expert level ability in SQL & SQL Management Studio
- Experienced in using and connecting to Data Warehouse tables
- Ability to set up and maintain SSRS Data Driven Subscriptions (DDS)
- Familiar with SQL Server Integration Services (SSIS) for data extraction, transformation, and loading processes
- Knowledge of SharePoint environments for document management and workflow integration
Responsibilities
- Analyze business requirements and design SQL reports using both SQL Server Reporting Services (SSRS) and Microsoft Power BI
- Create and maintain interactive dashboards and visualizations that provide meaningful business insights
- Develop and optimize database retrieval procedures to ensure efficient data access and reporting performance
- Plan and execute data warehouse projects to support enterprise reporting needs
- Integrate Power Platform solutions with existing database systems and reporting infrastructure
- Contribute to the development and implementation of company-wide best practices for database modeling
- Provide technical support and troubleshooting assistance to users experiencing SQL-related challenges
Other
- Bachelor’s degree in computer science or 3+ years’ experience using SQL to create SSRS reports and datasets
- Minimum 3-5 years of experience in business intelligence, database development, or related field
- Hybrid office schedule - requiring 3 days per week on-site in Morton, IL
- Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions
- Pre-employment screenings which includes a drug screen and background check
