Business Intelligence Developer (Information Technology)

Illinois Tool Works; Hatfield Borough (Montgomery County); On-site; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Developer to enhance data analytics capabilities. In this role, you will manage the data warehouse and ETL processes, ensuring user satisfaction while collaborating with various teams to translate requirements into actionable insights. You'll utilize advanced Power BI tools, optimize SQL queries, and lead efforts to modernize reporting practices. This position offers a dynamic environment where your contributions will significantly impact data-driven decision-making. If you're passionate about data and eager to drive innovation, this opportunity is perfect for you.

Qualifications

• 3-5 years of experience in Business Intelligence development.
• Extensive hands-on experience with Power BI and SQL.

Responsibilities

• Manage and maintain the Datawarehouse platform and ETL processes.
• Collaborate with non-IT professionals to create meaningful Power BI reports.

Skills

Power BI

SQL

ETL Development

DAX

Python

Education

BS in Information Systems

BS in Computer Science

Tools

Microsoft SQL Server

Azure Data Factory

QlikView

Job description

Job Description:

Basic Function

Participate as a Business Intelligence Developer to enhance our data analytics capabilities in Power BI and manage our data warehouse. Data warehouse management will consist of SQL server administration and ETL development (Currently SSIS). Must be comfortable working with non-IT colleagues to understand their requirements and translate them to technical specifications.

Essential Duties and Responsibilities

• Manage and Maintain the Datawarehouse platform including its ETL processes and ensure a high level of user satisfaction.

• Collaborate with non-IT professions to capture requirements and translate them into meaningful Power BI reports.

• Troubleshoot data related issues by working with both IT and non-IT professionals to determine the root cause and provide solutions.

• Utilize advanced Power BI tools such as Dax, Power Query, and Python.

• Write and optimize complex SQL queries.

• Lead efforts to migrate reports done in QlikView and other tools to Power BI.

• Research and encourage the use of modern BI tools such as Azure Data Factory and Fabric.

• Establish a governance model for our Power BI workspaces, data sources, and on-premises data gateways.

• Monitor and maintain our Microsoft SQL server environment (6 servers).

• Assist application developers with troubleshooting SQL related issues in other applications.

• Ensure our data is safe by implementing security best practices in both Power BI and MS SQL Server.

Education and Experience

• BS in Information Systems or Computer Science

• 3 - 5 plus years of experience required.

• Extensive hands-on experience with Power BI

• Proficiency in SQL.

• Experience managing Microsoft SQL Servers.

• Experience designing data processes including loading, transformations, mapping, etc.