Hybrid Business Intelligence Developer, Data Warehouse Architect

Posted 2 weeks ago

Apply now

About the role

  • 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

Job type

Experience level

Mid levelSenior

Salary

$113,000 - $129,000 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job