Skip to main content
Search jobs

BI Database Administrator

Apply Job ID REF5280I Date posted 04/14/2022 Address 701 South Ridge Avenue, Troy, OH Job Type Full-time Job Status Exempt

Hobart Service, an Illinois Tool Works Company, has been in business for over 125 years and is the trusted source for Commercial Food Equipment Service Solutions.  We have over 1,700 associates nationwide who serve as valued partners to our customers.  Our employees are dedicated to providing the best customer service, give back to the communities where they live and work, and demonstrate the ITW values of Integrity, Simplicity, Trust, Respect and Shared Risk.


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.

  • 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. 
  • 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.
  • Green Card or US citizenship 

Education and Work Experience

  • Bachelor's Degree in MIS, Computer Science, or related field

Desired Education/Experience

  • PowerShell and Unix shell scripting skills
  • Experience in SSAS, SSRS & PowerBI
  • Understanding and knowledge in data analytics and reporting

Why work for us?

  • Competitive pay
  • Great insurance options with low premiums
  • Paid vacation and holidays
  • 401K with company match
  • Extensive on-the-job, online, and classroom training
  • Service vehicle, uniforms, and safety equipment provided
  • Safety-conscious work environment

Hobart Service is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.


ITW and Hobart Service are committed to providing a healthy and safe environment for all employees. To demonstrate this commitment, Hobart Service is tobacco-free (including e-cigarettes) on campuses and within company vehicles and maintains a drug-free workplace.


If you are a qualified individual with a disability and are unable or limited in your ability to use or access the online application system process due to your disability, please contact Human Resources at service.hr@hobartservice.com to request assistance. No other requests will be acknowledged.

All your information will be kept confidential according to EEO guidelines.

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.  

Apply

Want personalized job recommendations based on your interests?

Sign up for alerts to get started!

Notify me of jobs

At ITW, we value our colleagues' unique perspectives, experiences, and ideas and create workplaces where everyone can develop their careers and perform to their full potential.

Equal Opportunities

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. Read more information here.

If you are a qualified individual with a disability and are unable or limited in your ability to use or access this online application system process due to your disability, please email corp_accessibility@itw.com to request assistance. No other requests will be acknowledged.