Database & BI Analyst

Location:

Holland, Michigan, United States

Job ID:

R0093498

Date Posted:

2025-06-13

Company Name:

J.R. AUTOMATION TECHNOLOGIES, LLC

Profession (Job Category):

IT, Telecom & Internet

Job Schedule: 

Full time

Remote:

No

Job Description:

JR Automation, a Hitachi Group Company, is driven to deliver customer success worldwide. We provide intelligent automated manufacturing and distribution technology solutions that transform how the world's leading manufacturers make and distribute products. Our strength is our people and we’re always looking to strengthen our team across the globe. Join us as a Database & BI Analyst.

We are looking for a detail-oriented and self-driven Database & BI Analyst with 3–5 years of hands-on experience in database technologies and business intelligence development. The ideal candidate will have strong proficiency in SQL Server, T-SQL, SSIS\SSRS, Power BI, data warehousing concepts, and Azure data platform, along with experience in C# development. Familiarity with ERP systems is essential, and experience in the manufacturing or engineering-to-order (ETO) sector will be considered a strong asset.

Location Type: This position can be performed remote, onsite, or in a hybrid capacity. There is a strong preference for the person to be located within driving distance to one of our Holland, MI locations. Otherwise, they should be within driving distance to our facilities in Detroit, MI, Greenville, SC, Nashville, TN, or Ogden, UT.

How You’ll Make an Impact:

• Design, develop, and optimize complex T-SQL queries, stored procedures, and database objects.
• Build and maintain interactive dashboards and reports using Power BI to support business decision-making.
• Database support and maintain MS SQL Server and Azure SQL databases, ensuring performance, integrity, and availability.
• Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
• Develop and maintain C# applications for internal tools and data-related automation tasks.
• Participate in ERP-related data integration, data warehouse, reporting, and troubleshooting.
• Monitor data pipelines\ETL, resolve data quality issues, and provide database-level support.
• Respond to database support tickets and incidents, resolving issues related to performance and access.

Note: This list of responsibilities is inclusive; however, it is intended to be a guideline for activities.

What You’ll Bring:

• 3–5 years of experience with MS SQL Server, T-SQL, SSIS\SSRS and Power BI.
• Proficient in querying Azure SQL Databases and working with C#.
• Hands-on experience with ETL processes, data factory and data warehousing concepts, and DevOps tools concepts (CI/CD pipelines, version control, etc.).
• Exposure to ERP systems (e.g., Epicor, SAP); knowledge of manufacturing or ETO processes is a plus.
• Strong analytical skills and the ability to troubleshoot complex issues.
• Excellent communication and documentation skills.
• Experience working in a manufacturing or engineering-to-order (ETO) environment preferred.
• Knowledge of ITIL practices or ticketing systems (ServiceNow) is plus.
• Certification in Microsoft BI or Azure technologies preferred.

Disclaimer: JR Automation requires candidates to successfully complete a 10-panel drug screen, physical examination, and background check.

Company Overview: 

At JR Automation, A Hitachi Group Company, we discover potential, reimagine limits, and advance industry. When faced with a problem, we find a solution. Together, we push what’s possible to automate for tomorrow.

Join our team of 2,000+ at one of our 20+ facilities around the world and be a part of the most experienced team of advanced automation integrators.

Fueled by Possible.

Equal Opportunity Employer (EOE)-Females/Minorities/Protected Veterans/Individuals with Disabilities

If you need a reasonable accommodation to apply for a job at JR Automation, please send the nature of request and contact information to jrcareers@jrautomation.com. Queries other than accommodation requests will not be responded to.