BI Developer designing, developing, and maintaining the business intelligence platform for Machine Solutions. Creating scalable data insights and collaborating with business leaders to deliver metrics across various platforms.
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.
Requirements
Bachelor's degree in information technology or related field from an accredited university.
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.
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 title
Business Intelligence Developer, Data Warehouse Architect
Power BI Consultant focused on designing and developing reports and dashboards. Collaborating with clients to transform data sets for business insights.
(Senior) BI Consultant leading and implementing advanced BI projects for diverse clients in Switzerland. Focusing on Microsoft technologies and cloud solutions with teamwork and problem - solving.
Business Intelligence Developer designing and implementing BI solutions for energy management provider in Bulgaria. Collaborating with stakeholders to shape architecture and support project lifecycles.
Business Intelligence Analyst designing dashboards and actionable insights for stakeholders in mobile games. Collaborating with teams to enhance data - driven decision - making.
Junior Teamlead BI Consultant leading Data & Cloud projects for HICO Group AG in Switzerland. Responsible for project implementation and collaboration with international teams.
Business Intelligence Analyst at Jam City designing dashboards and delivering analyses. Collaborating with game stakeholders to interpret data and improve decision - making.
Business Intelligence Developer designing and maintaining BI solutions using Power BI for energy control solutions. Collaborating with stakeholders to ensure data needs and project objectives are met.