Career Detail

Business Analytics Architect

Seeking a Business Analytics Architect to join our Deublin team! In this role you will provide direction and leadership in creating and developing a dynamic global data visualization framework that will be consumed by business leaders in our organization. The Business Analytics Architect will build relationships with functional experts with IT, business leaders, as well as end users to drive interactive visibility to data and standardize reporting metrics globally. Will be responsible for establishing effective data management practices while standardizing and automating measurement of KPIs enables us to maintain focus on speed while increasing transparency to our business and operations.

11/7/2022

Waukegan, Illinois

Full-time

Office

Responsibilities:

· Define the overall business intelligence (BI) data architecture including defining design patterns, standards, best practices, and Cloud strategy.

· Responsible for data extraction, transformation, loading, warehousing, reporting and visualization.

· Analyze business processes and determine performance measures, KPIs, metrics, and dashboards in close collaboration with technical and non-technical stake holders.

· Serve as the business sponsor for master data management needs including systems, database, analysis tools, integration, and quality control

· Establish data governance and define responsibilities with data owners.

· Identify data integrity issues, troubleshoot, locate root cause, and develop capabilities to cleanse and control

· Align with software development team in in defining data models / data structures and simplify complexity.

· Summarizes data findings to both a technical and non-technical audience.

· Remains current with emerging technologies and industry best practices; guides others on major strategies and methodologies.

· Focus on continuous improvement and process simplification methodologies that are part of the Deublin Performance systems such as 8D/5WHY & 80/20.

Required Skills:

· Design and implement ETL processes in support of business analytics and reporting

· Data Modeling

· Develop and perform unit, system, performance, and regression testing on ETL mappings

· Developing visual reports, KPI scorecards, and interactive dashboards using Power BI

· Statistics, Analytics, and Strong Mathematics Skills

· Data Visualization - MS Power BI, Tableau, Qlik, Business Objects, etc.

· Database design - MySQL, MSSQL, Oracle

· Effective personal and interpersonal skills, including the ability to influence others, drive new capabilities, and bring new ways of thinking into the company

Education and Experience:

· Bachelor's degree in Computer Science, Engineering, Mathematics, or related field.

· 8+ years of Business Intelligence and Data Management

· Proficient in Microsoft Office

· Experience with ERP system data (i.e., IFS, Oracle, SAP, Epicor)

· Excellent knowledge of SQL, data warehousing best practices, and integration tools.

· Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI).

Benefits:

  • Medical, Dental, and Vision Insurance
  • Profit Share Bonus
  • 401(k) matching
  • Health Savings account
  • Employee assistance program
  • Flexible spending account
  • Life insurance
  • Paid Time Off
  • Tuition reimbursement
  • Onsite Fitness Center and Trainer