Machine Solutions Inc.
Business Intelligence Developer/Data Warehouse Architect
Machine Solutions Inc., Spartanburg, South Carolina, United States, 29302
Business Intelligence Developer / Data Warehouse Architect
Join Machine Solutions Inc. and contribute to advanced medical device and biopharmaceutical manufacturing technology. In this role, you will design, develop, and maintain the company’s business intelligence platform, combining data architecture expertise with BI development skills to deliver scalable insight solutions.
About Machine Solutions Machine Solutions is the premier provider of advanced equipment and services for the medical device, biopharmaceutical, and blood- and plasma-collection industries. The company supports customer growth through quality products and automated solutions that increase production volumes and profit margins. Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller Group company.
Benefits
Medical, Dental, and Vision Insurance
401k Retirement Plan with Company matching
Paid Time Off and Paid Sick Time
Health Savings and Flexible Spending Accounts
Long‑term and Short‑term Disability
Life Insurance and AD Insurance
Parental Leave
Adoption & Fertility Benefits
Job Overview The BI Developer/Data Warehouse Architect will design, develop, and maintain Machine Solutions’ business intelligence platform. The role combines technical expertise in data architecture with BI development skills to create scalable data insight solutions.
Essential Duties and Responsibilities
Creates self‑service interactive dashboards and paginates reports using tools such as Domo or Power BI.
Architects data warehouse/data lake solutions to support legacy and next‑generation ERP business intelligence.
Supports legacy reports and dashboards using SSRS (SQL Server Reporting Services) and 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 related 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 identifies 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
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 of experience working with Microsoft SQL Server.
Experience designing analytics with Domo, SSRS, Power BI, Crystal Reports, or Tableau.
ERP experience, ideally in a discrete manufacturing environment.
Strong collaborative skills and an 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 role involves prolonged periods of sitting at a desk, using a computer, and engaging in repetitive hand movements. Occasional standing, walking, and lifting up to 20 pounds may be required. The work environment is a primarily office setting near a manufacturing facility or remote at a home office. Employees may need to enter the manufacturing floor occasionally and adhere to safety protocols, including the use of personal protective equipment.
Compensation Range $113,000 – $129,000 annually
EEO Statement 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
About Machine Solutions Machine Solutions is the premier provider of advanced equipment and services for the medical device, biopharmaceutical, and blood- and plasma-collection industries. The company supports customer growth through quality products and automated solutions that increase production volumes and profit margins. Machine Solutions is privately owned by BW Forsyth Partners, a Barry‑Wehmiller Group company.
Benefits
Medical, Dental, and Vision Insurance
401k Retirement Plan with Company matching
Paid Time Off and Paid Sick Time
Health Savings and Flexible Spending Accounts
Long‑term and Short‑term Disability
Life Insurance and AD Insurance
Parental Leave
Adoption & Fertility Benefits
Job Overview The BI Developer/Data Warehouse Architect will design, develop, and maintain Machine Solutions’ business intelligence platform. The role combines technical expertise in data architecture with BI development skills to create scalable data insight solutions.
Essential Duties and Responsibilities
Creates self‑service interactive dashboards and paginates reports using tools such as Domo or Power BI.
Architects data warehouse/data lake solutions to support legacy and next‑generation ERP business intelligence.
Supports legacy reports and dashboards using SSRS (SQL Server Reporting Services) and 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 related 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 identifies 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
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 of experience working with Microsoft SQL Server.
Experience designing analytics with Domo, SSRS, Power BI, Crystal Reports, or Tableau.
ERP experience, ideally in a discrete manufacturing environment.
Strong collaborative skills and an 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 role involves prolonged periods of sitting at a desk, using a computer, and engaging in repetitive hand movements. Occasional standing, walking, and lifting up to 20 pounds may be required. The work environment is a primarily office setting near a manufacturing facility or remote at a home office. Employees may need to enter the manufacturing floor occasionally and adhere to safety protocols, including the use of personal protective equipment.
Compensation Range $113,000 – $129,000 annually
EEO Statement 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