Machine Solutions Inc. · 16 hours ago
Business Intelligence Developer/Data Warehouse Architect
Minnetonka, MN
Full-time
Onsite
Mid, Senior Level
$113K/yr - $129K/yr
5+ years expMachine Solutions Inc. is the premier provider of advanced equipment and services for the medical device industry. The BI Developer/Data Warehouse Architect will design, develop, and maintain the business intelligence platform, focusing on creating scalable data insight solutions and supporting data architecture initiatives.
Medical DeviceHealthcareMedical
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 (SQL Server Reporting Services), Power BI
Works with business leaders to identify and deliver KPI’s 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 on 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
Qualification
Required
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
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
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
Company
Machine Solutions Inc.
Machine Solutions provides advanced equipment and services for the medical device, biopharmaceutical, and blood- and plasma-collection industries.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
B
Brian Strini
President & CEO
T
Tony Sansone
Chief Financial Officer
Recent News
BioWorld Financial Watch
2025-05-17
Company data provided by crunchbase