What are the responsibilities and job description for the Database & BI Analyst position at JR Automation?
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
What You’ll Bring
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 [email protected]. Queries other than accommodation requests will not be responded to.
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.
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.
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 [email protected]. Queries other than accommodation requests will not be responded to.