The Report Analyst plays a crucial role in supporting the reports, databases and repositories necessary to support company-wide BI function. This includes creating and maintaining data warehouses, tools, processes and reports as well as formulating and disseminating results.
Skills & Responsibilities:
– Work with internal stakeholders for deep dive analysis of existing reports.
– Maintain user hierarchies, report organization and publishing in Jaspersoft Server, or similar tools.
– Identify and escalate issues in the operation and maintenance of database systems.
– Participate in training and demonstrations of new reports to staff.
– Other related duties as assigned by the Director, IT.
– Write report documentation for more complex reporting packages and dashboards.
– Convert functional specifications into report designs.
– Collaborate with others at all levels of management to identify report requirements, design features and specifications.
– Design and code reports in Jaspersoft Studio, or similar tools.
– Support database architecture decisions and tool selection.
Additional skills:
– Bachelor’s Degree in Computer Science, Business, Mathematics or a related discipline.
– Writing complex SQL queries for utilizing CRM, QuickBooks and JIRA data from SQL Server 2008 & PostgreSQL databases.
– Designing agile methodologies, coding and testing medium to high complexity sales management, accounting and production management reports in Jaspersoft Studio 6.x.
– Analyzing and alerting source code (XML, Java) to overcome deficiencies and visual elements.
– 2+ years experience in querying relational database systems, specifically: SQL Server, MySQL, PostgreSQL.
– Strong proficiency with standard Microsoft business applications (Excel, Access, Powerpoint).
– Ability to read, write and speak the English language fluently.
– Strong attention to detail and interpersonal communication skills.
– 2+ years of experience in visual report development using any platform.
– 2+ years of experience in data analysis, reporting, and metrics/analytics.
Good to have:
– Direct marketing industry experience.
– Java, C# or Python development experience to augment reports with custom functionality.
– Familiarity with agile development methodologies.
– Source code revision tracking using Git.
– Familiarity with G Suite business applications (Sheets, Docs, Slides).