Description

Design, develop, and maintain BI reporting and analytic dashboards to support business requirements. Own the end-to-end implementation of data mappings and ETL processes.

Responsibilities

• Develop, document, and implement data mappings for ETL implementations.
• Design and maintain BI reporting and analytic dashboards using data visualization technologies.
• Participate in business process analysis and requirements gathering with stakeholders to implement technical solutions.
• Create reports and dashboards based on reviewed business requirements.
• Provide technical support for existing reports and estimate project tasks.

Required Skills

• 5+ years of experience with SQL programming using Microsoft SQL Server.
• Expert-level knowledge of SSIS, SSAS (Multidimensional and Tabular), SSRS, and PowerBI.
• Proficiency with SSMS and SSDT.
• Experience with data visualization, auditing, data validation, and data mining.
• Proven track record in Data Analytics development.
• Experience designing automated processing, data validation, error checks, alerts, and performance testing.
• Knowledge of ERP systems in a distribution environment.
• Experience working in a SOX environment.
• Degree in Computer Science or equivalent experience.

Preferred Skills

• Advanced Microsoft Excel skills including pivot tables, graphs, and complex lookups.

Key Skills

Education

Any Graduate