Machine Solutions Inc.
Business Intelligence Developer/Data Warehouse Architect
Machine Solutions Inc., Modesto, California, United States, 95351
Business Intelligence Developer/Data Warehouse Architect
Join to apply for the
Business Intelligence Developer/Data Warehouse Architect
role at
Machine Solutions Inc.
About Us Machine Solutions is the premier provider of advanced equipment and services for the medical device, biopharmaceutical, and blood‑and‑plasma‑collection industries. We support our customers’ needs and growth by delivering quality and value through a wide breadth of products. Machine Solutions provides proprietary mechanical solutions to a variety of complex process, testing and device design challenges. Our equipment has become the industry standard for stent crimping, balloon catheter pleating and folding, catheter braiding and medical device manufacturing applications. As a pioneer in radio frequency technology, the company continues to develop advancing technology for thermal forming, molding and welding plastic for medical manufacturing, biopharmaceutical, and blood‑and‑plasma‑processing applications. Our experienced team of engineers has been instrumental in automating manual processes that enable our customers to increase production volumes and profit margins, and we believe in providing a superior customer experience by designating resources to a dedicated aftermarket team that is always ready to provide technical service and process support. Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller company.
Company Overview & Culture Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller Group company. We expect our Team Members to care for people and perform with excellence through effective communication, customer focus, driving results, instilling trust, and optimizing work processes. Leaders are expected to be the message, cultivate enduring relationships, bring out the best in each individual, achieve values‑based results, and co‑create the future. Leaders demonstrate this through self‑awareness, developing talent, driving engagement, ensuring accountability, leveraging business insight, managing complexity, planning and alignment, and valuing differences.
Benefits
Medical, Dental, Vision Insurance
401k Retirement Plan with Company matching
Paid Time off and Paid Sick time
Health savings and spending accounts
Long‑term & Short‑term disability
Life & AD Insurance
Parental Leave
Adoption & Fertility Benefits
Job Overview The BI Developer/Data Warehouse Architect will design, develop, and maintain the Machine Solutions business intelligence platform. This role combines technical expertise in data architecture as well as BI development skills to create scalable data insight solutions.
Essential Duties and Responsibilities
Creates self‑service interactive dashboards, paginates reports using tools such as Domo or Power BI.
Architects data warehouse/data lake solution to support legacy and next‑generation ERP business intelligence.
Supports legacy reports and dashboards using SSRS, Power BI.
Works with business leaders to identify and deliver KPIs and other metrics.
Develops and maintains ETL (extract, transform, and load) processes.
Establishes alerting for pipeline processes and resolves issues.
Creates automated reporting solutions for various business stakeholders.
Supports bi‑directional data integration between Salesforce and ERP.
Fields various data requests from parent companies.
Creates and maintains out‑of‑the‑box ERP reporting.
Troubleshoots and resolves data quality issues.
Owns the process for various BI components of ERP implementation.
Documents system architecture.
Maintains legacy on‑premises SQL databases.
Supports BI activity as it relates to acquisition activity, as needed.
Develops a master data strategy for Machine Solutions’ next‑generation ERP.
Collaborates with ERP consultants for data migration.
Develops a modern solution for real‑time factory floor dashboards.
Uses standard or ad hoc queries/reports to extract data from disparate databases or data sources.
Analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies.
Consults with users or decision makers to identify data sources, required data elements, or data validation standards.
Collaborates with development teams to design business intelligence solutions to facilitate data gathering, storage, and retrieval.
Other duties as assigned.
Qualifications / Education and/or Experience
Bachelor’s degree in information technology or related field from an accredited university. Industry certifications are a plus.
5+ years of IT experience in a related capacity.
5+ years’ experience working with Microsoft SQL Server.
Experience designing analytics with Domo, SSRS, Power BI, Crystal Reports, Tableau.
ERP experience, ideally in a discrete manufacturing environment.
The ideal candidate will have strong collaborative skills and embrace the entrepreneurial spirit.
Any combination of education, training, or experience that demonstrates the ability to perform the duties of the position.
Knowledge, Skills and Abilities
High‑level knowledge and experience in database management and tuning.
Advanced skills in financial reporting.
Advanced skills in dimensional modeling.
Knowledge and experience with data marts, data warehousing tools, and data lakes.
Knowledge and experience with AWS (Amazon Web Services).
Knowledge and experience with Infor LN.
Knowledge and experience connecting BI systems to CRM (Salesforce, Hubspot).
Knowledge and experience writing moderately complex SQL queries.
Physical Demands & Work Environment The physical demands of the role involve prolonged periods of sitting at a desk, using a computer, and engaging in repetitive hand movements for tasks like typing or writing. Occasional standing, walking, and lifting objects up to 20 pounds may be required. This role may also include frequent use of standard office equipment such as printers, copiers, and telephones. Good hearing and manual dexterity are essential for safely performing tasks and ensuring product quality. The vision requirements needed are the ability to adjust focus and identify and distinguish colors. The work environment for this role is primarily an office setting located near a manufacturing facility or remotely at a home office. When visiting our manufacturing facility, occasional exposure to noise, vibrations, or odors from the nearby production area may occur. Employees may need to enter the manufacturing floor occasionally, requiring adherence to safety protocols, including wearing appropriate personal protective equipment (PPE).
Compensation Range $113,000 – $129,000 annually.
Required travel up to 20% domestically and internationally.
At Barry‑Wehmiller we recognize that people come with a wealth of experience and talent beyond just the technical requirements of a job. If your experience is close to what you see listed here, please still consider applying. We know that our differences often can bring about innovation, excellence and meaningful work—therefore, people from all backgrounds are encouraged to apply to our positions. Please let us know if you require reasonable accommodations during the interview process.
Barry‑Wehmiller is an equal opportunity employer. M/F/D/V This organization uses E‑Verify.
Applicants may be subject to pre‑employment screening which may include drug screening, reference checks, employment verifications, background screening and/or skills assessments.
#J-18808-Ljbffr
Business Intelligence Developer/Data Warehouse Architect
role at
Machine Solutions Inc.
About Us Machine Solutions is the premier provider of advanced equipment and services for the medical device, biopharmaceutical, and blood‑and‑plasma‑collection industries. We support our customers’ needs and growth by delivering quality and value through a wide breadth of products. Machine Solutions provides proprietary mechanical solutions to a variety of complex process, testing and device design challenges. Our equipment has become the industry standard for stent crimping, balloon catheter pleating and folding, catheter braiding and medical device manufacturing applications. As a pioneer in radio frequency technology, the company continues to develop advancing technology for thermal forming, molding and welding plastic for medical manufacturing, biopharmaceutical, and blood‑and‑plasma‑processing applications. Our experienced team of engineers has been instrumental in automating manual processes that enable our customers to increase production volumes and profit margins, and we believe in providing a superior customer experience by designating resources to a dedicated aftermarket team that is always ready to provide technical service and process support. Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller company.
Company Overview & Culture Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller Group company. We expect our Team Members to care for people and perform with excellence through effective communication, customer focus, driving results, instilling trust, and optimizing work processes. Leaders are expected to be the message, cultivate enduring relationships, bring out the best in each individual, achieve values‑based results, and co‑create the future. Leaders demonstrate this through self‑awareness, developing talent, driving engagement, ensuring accountability, leveraging business insight, managing complexity, planning and alignment, and valuing differences.
Benefits
Medical, Dental, Vision Insurance
401k Retirement Plan with Company matching
Paid Time off and Paid Sick time
Health savings and spending accounts
Long‑term & Short‑term disability
Life & AD Insurance
Parental Leave
Adoption & Fertility Benefits
Job Overview The BI Developer/Data Warehouse Architect will design, develop, and maintain the Machine Solutions business intelligence platform. This role combines technical expertise in data architecture as well as BI development skills to create scalable data insight solutions.
Essential Duties and Responsibilities
Creates self‑service interactive dashboards, paginates reports using tools such as Domo or Power BI.
Architects data warehouse/data lake solution to support legacy and next‑generation ERP business intelligence.
Supports legacy reports and dashboards using SSRS, Power BI.
Works with business leaders to identify and deliver KPIs and other metrics.
Develops and maintains ETL (extract, transform, and load) processes.
Establishes alerting for pipeline processes and resolves issues.
Creates automated reporting solutions for various business stakeholders.
Supports bi‑directional data integration between Salesforce and ERP.
Fields various data requests from parent companies.
Creates and maintains out‑of‑the‑box ERP reporting.
Troubleshoots and resolves data quality issues.
Owns the process for various BI components of ERP implementation.
Documents system architecture.
Maintains legacy on‑premises SQL databases.
Supports BI activity as it relates to acquisition activity, as needed.
Develops a master data strategy for Machine Solutions’ next‑generation ERP.
Collaborates with ERP consultants for data migration.
Develops a modern solution for real‑time factory floor dashboards.
Uses standard or ad hoc queries/reports to extract data from disparate databases or data sources.
Analyzes data to produce dashboards, metrics, or insights and identify trends or anomalies.
Consults with users or decision makers to identify data sources, required data elements, or data validation standards.
Collaborates with development teams to design business intelligence solutions to facilitate data gathering, storage, and retrieval.
Other duties as assigned.
Qualifications / Education and/or Experience
Bachelor’s degree in information technology or related field from an accredited university. Industry certifications are a plus.
5+ years of IT experience in a related capacity.
5+ years’ experience working with Microsoft SQL Server.
Experience designing analytics with Domo, SSRS, Power BI, Crystal Reports, Tableau.
ERP experience, ideally in a discrete manufacturing environment.
The ideal candidate will have strong collaborative skills and embrace the entrepreneurial spirit.
Any combination of education, training, or experience that demonstrates the ability to perform the duties of the position.
Knowledge, Skills and Abilities
High‑level knowledge and experience in database management and tuning.
Advanced skills in financial reporting.
Advanced skills in dimensional modeling.
Knowledge and experience with data marts, data warehousing tools, and data lakes.
Knowledge and experience with AWS (Amazon Web Services).
Knowledge and experience with Infor LN.
Knowledge and experience connecting BI systems to CRM (Salesforce, Hubspot).
Knowledge and experience writing moderately complex SQL queries.
Physical Demands & Work Environment The physical demands of the role involve prolonged periods of sitting at a desk, using a computer, and engaging in repetitive hand movements for tasks like typing or writing. Occasional standing, walking, and lifting objects up to 20 pounds may be required. This role may also include frequent use of standard office equipment such as printers, copiers, and telephones. Good hearing and manual dexterity are essential for safely performing tasks and ensuring product quality. The vision requirements needed are the ability to adjust focus and identify and distinguish colors. The work environment for this role is primarily an office setting located near a manufacturing facility or remotely at a home office. When visiting our manufacturing facility, occasional exposure to noise, vibrations, or odors from the nearby production area may occur. Employees may need to enter the manufacturing floor occasionally, requiring adherence to safety protocols, including wearing appropriate personal protective equipment (PPE).
Compensation Range $113,000 – $129,000 annually.
Required travel up to 20% domestically and internationally.
At Barry‑Wehmiller we recognize that people come with a wealth of experience and talent beyond just the technical requirements of a job. If your experience is close to what you see listed here, please still consider applying. We know that our differences often can bring about innovation, excellence and meaningful work—therefore, people from all backgrounds are encouraged to apply to our positions. Please let us know if you require reasonable accommodations during the interview process.
Barry‑Wehmiller is an equal opportunity employer. M/F/D/V This organization uses E‑Verify.
Applicants may be subject to pre‑employment screening which may include drug screening, reference checks, employment verifications, background screening and/or skills assessments.
#J-18808-Ljbffr