Job description
Unger Enterprises, LLC.
Business Intelligence Data Specialist
Primary Purpose of Position
The Business Intelligence (BI) Data Specialist’s role is to aid in the design and development of complex global financial, operations, sales, and marketing reports as well as administering a JetAnalytics Data Warehouse designed to enhance reporting capabilities utilizing JetReports, Power BI, Excel, and other analytics tools in order to deliver efficiencies and improve business awareness for organizational leadership.
Responsibilities:
Data Integration & Report Development
- Develop analytic reports and dashboards utilizing various databases and third-party data files.
- Coordinating with the CFO, Director of Strategic Finance and the IT department and various other stakeholders, help develop high standards of data quality through the creation of appropriate processes for data management and reporting.
- Serve as a liaison between department’s analytical needs and technical data storage systems and files.
- Collaborate with stakeholders to document requirements for reporting.
- Working with IT, facilitate the management of all database processing functions, including merge/purge, data hygiene, data appends, and coordination with 3rd party vendors.
- Identify issues in data quality that would impact reporting (i.e. duplicate records, missing data, etc.)
Operational Management
- Support the implementation and use of new BI software tools and systems.
- Support the integration efforts for merging BI platforms with enterprise systems (Microsoft NAV/BC) and applications.
- Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
- Design and deliver end-user training and training materials; provide technical support as necessary.
Business Intelligence & Data Mining
- Maintain trends and track various measures to fully utilize the capabilities of databases and data files.
Minimum Qualifications
- Bachelor’s degree in Computer Science or related field
- Experience with JetReports, JetAnalytics, SSAS, Power BI
- Familiar with Microsoft Dynamics NAV/BC ERP
- 5+ years’ experience in report development, business / customer intelligence, data management or business analysis
- Strong knowledge and experience in creating parameterized reports, drill down reports and scheduled reports
- Analytical, creative, and innovative approach to solving problems
- Ability to interface with executives, functional managers, 3rd-party providers, and employees
- Proven communication skills, problem-solving skills, and knowledge of integration best practices are critical to successful performance in this role.
Preferred Qualifications
- Previous Experience with Financial Reporting
- Previous experience with reporting results to executive-level stakeholders.
- Knowledge of relational database design and data management techniques.
- Knowledge of Data Warehouse concepts (e.g. Data Marts, Facts/Dimension tables, Star schema etc.)
- Familiar with CRM systems