Business Intelligence Developer

Summary

This position is a business intelligence analyst/developer role reporting directly to the Marketing Director. Day to day work will include report writing, MS SQL database querying, and data analysis. The Marketing Department is an energetic, fast-paced environment seeking dedicated, self-starting employees.

Responsibilities

Analysis

The primary focus of the marketing department is to reach customers more efficiently. This can be achieved by reaching more of the same customers, tapping a more responsive pool of potential customers, or improving the customer experience. You will have the freedom to investigate what works and what doesn’t and then suggest alternatives. Analyzing past performance to uncover nuggets of opportunity is pivotal. The department is open how this is accomplished and the tools used are up to you. Skill with Excel is critical so that results can be transmitted and consumed by business users.

Reporting

Create reports using SSRS/Report Builder and Excel. The reports range in complexity from the very basic to in depth dashboards with multiple visualizations. How to accomplish the report is up to the developer. You will be responsible for gathering the business requirements, creating the datasets, writing the reports, and then validating the reports’ functionality and accuracy.

Requirements

• SQL Server 2012+ experience required
• Proficient in Excel (Pivot tables, IF statements, aggregation, VLOOKUP or INDEX MATCH)
• Some data reporting experience. SSRS experience is a plus, but candidates with experience in similar platforms will also be considered.
• Familiarity with basic statistical concepts and testing.