BI Administrator

ITW
Troy, OH Full Time
POSTED ON 11/22/2023 CLOSED ON 11/27/2023

What are the responsibilities and job description for the BI Administrator position at ITW?

Company Description

At ITW Food Equipment Group, people and food are our passion. We believe great food brings people together, and the relationships we share feed our inspiration to be the best we can be for one another.

Our family of premium brands has been dedicated for more than a century to supporting those who are not only passionate about creating great food, but are inspired by the people they serve and come to know on a daily basis.

Likewise, it is our mission to provide food equipment that foodservice and food retail professionals can trust to work hard and deliver quality, consistent results day in and day out, empowering them to focus on what they love most—creating great food for great people.

Job Description

The BI Database Administrator is responsible for supporting and maintaining SQL Server databases including data warehouse databases. They will design, develop, and deliver database solutions including ETL. Position requires ability to administer all functions of a Microsoft SQL Server including index analysis for performance optimization, backup / restore strategies, security, troubleshooting job failures and alerts, and optimizing ETL processes.  This position will interact and work extensively within the Microsoft Business Intelligence stack including the SQL Server Engine, SSIS, SSAS, SSRS & PowerBI.   This position does not provide sponsorship.

Responsibilities

 

  • BI Database Administrator will provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security, and quality of information.  
  • Responsible for developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectively
  • Monitor SQL Server for performance bottlenecks and recommend solutions
  • Diagnose and resolve data warehouse performance issues.
  • Set and maintain database standards.
  • Manage database access and develop processes for optimizing database security.
  • Assist other developers, analysts, and designers in implementation of database solutions.
  • Work with Business Intelligence Developer to create models within the data warehouse and/or changes to existing data stores.
  • Ability to understand and implement Microsoft Database Solutions from within Azure DevOps source control.
  • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
  • The candidate will also regularly interact with the users ranging from the end user to management team to understand, document and communicate their needs, perform requirements analysis, develop, and deliver Data Models, reports, Business Intelligence, and data transformation solutions.

This position requires analytical and problem-solving aptitude along with a wide range of technical development, design and multitasking skills. 

Qualifications

  • Bachelor's Degree in MIS, Computer Science, or equivalent experience
  • 5 years of Database Administrator experience including 2 years in business intelligence and data warehousing environments
  • 3 years of experience using Microsoft SQL Server & Microsoft BI Suite like SSIS
  • Strong TSQL scripting abilities
  • Experience with cloud services
  • Experience in evaluating execution plans and index analysis
  • Experience in SQL Server security.
  • Understanding of relational and dimensional data modeling
  • Exceptional organizational skills to prioritize work and ability to balance maintenance and project work
  • Excellent communication and interpersonal skills
  • Ability to work independently or as a team member.

Desired Education/Experience

 

  • PowerShell and Unix shell scripting skills
  • Experience in SSAS, SSRS, Power BI, Data Lake, Dataverse, Azure SQL, SQL Sync, Data factory, and Synapse Analytics
  • Understanding and knowledge in data analytics and reporting

 

Additional Information

Why work for us?

  • Competitive pay
  • Great insurance options with low premiums
  • Paid vacation and holidays
  • 401K with company match
  • Extensive on-the-job training
  • Safety-conscious work environment

 

ITW is an equal opportunity employer. We value our colleagues’ unique perspectives, experiences and ideas and create workplaces where everyone can develop their careers and perform to their full potential. 

As an equal employment opportunity employer, ITW is committed to equal employment opportunity and fair treatment for employees, beginning with the hiring process and continuing through all aspects of the employment relationship. 

All qualified applicants will receive consideration for employment without regard to race, color, sex, gender identity, sexual orientation, religion, national origin, age, disability, protected Veteran status or any other characteristic protected by applicable federal, state, or local laws.  

Administrator
SKLD New Lebanon -
New Lebanon, OH
Power BI Developer IT (Miamisburg, OH)
Billerud -
Miamisburg, OH
IT Administrator
Reynolds and Reynolds -
Dayton, OH

For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the BI Administrator.

Click the checkbox next to the jobs that you are interested in.

  • SAP Asap Methodology Skill

    • Income Estimation: $151,672 - $199,860
  • Advanced Analytics Skill

    • Income Estimation: $67,989 - $88,079
    • Income Estimation: $61,308 - $83,560
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at ITW

ITW
Hired Organization Address Denver, CO Full Time
Company Description At ITW Food Equipment Group, people and food are our passion. We believe great food brings people to...
ITW
Hired Organization Address Appleton, WI Full Time
Company Description Comprised of a market-leading portfolio of best-in-class brands, the businesses of ITW Welding work ...
ITW
Hired Organization Address Redmond, WA Full Time
Company Description Hobart Service, an Illinois Tool Works Company, has been in business for over 125 years and is the t...
ITW
Hired Organization Address Philadelphia, PA Full Time
Company Description Hobart Service, an Illinois Tool Works Company, has been in business for over 125 years and is the t...

Not the job you're looking for? Here are some other BI Administrator jobs in the Troy, OH area that may be a better fit.

Power BI Manager

InFocus Eyecare, Dayton, OH

CI/BI Analyst

ATSG, Wilmington, OH