Logo
Morton Buildings, Inc.

BI Report Developer

Morton Buildings, Inc., Morton, Illinois, United States, 61550

Save Job

Overview Morton Buildings, Inc.

is seeking a

BI Report Developer

to design, develop, and maintain comprehensive business intelligence solutions that drive data-driven decision making across the organization. This role combines technical expertise in SQL reporting, data warehousing, and Microsoft Power BI to deliver actionable insights and automated business reports. The position requires collaboration with cross-functional teams to translate business requirements into effective reporting solutions while establishing and maintaining best practices for database modeling and data management. This opportunity offers a hybrid office schedule – requiring 3 days per week on-site in Morton, IL. The hybrid schedule agreement is subject to change as business needs dictate. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

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

Document processes, procedures, and technical specifications for reporting solutions

Other duties as assigned

Qualifications

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

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.

Strong initiative to find ways to improve reports, SQL tables, stored procedures, views, and functions.

Preferred Skills

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

Experience with Microsoft Power Platform (Power Apps, Power Automate)

Benefits

Starting annual pay range at $80,000 - $95,000

Excellent medical/dental/prescription coverage

Life Insurance

Paid holidays

Paid vacation

Paid sick time

401K Opportunity

ESOP Retirement Program which makes you an owner of the company

Morton Buildings, Inc. is an Equal Opportunity Employer and Drug-Free Workplace. All candidates offered employment will be subject to pre-employment screenings which includes a drug screen and background check.

Details

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology

Industries: Construction

#J-18808-Ljbffr