The Business Intelligence Developer will be a part of the Business Intelligence team and will support ongoing BI development and data integration activities that support day to day data and information needs of Spencer Gifts LLC. The individual will work closely with project managers, business analysts, end users of the reports/dashboards and other development teams to provide effective BI and integration solutions.

RESPONSIBILITIES

• Design BI application technical solution based on business requirement and design

• Executing deliverables as assigned including but not limited to:

• Designing, Developing, Testing, and Deploying Dashboards and Report Solutions.

• Application Object Creation

• Schema Object Creation

• MicroStrategy Administrative Tasks

• Design logical and physical models for operational data stores as well as data warehouseincorporating relational modeling best practices and integration standards

• Create and maintain process and methodology documentation

• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities

Job Requirements

EDUCATION AND EXPERIENCE REQUIRED

• 3 years’ experience with MicroStrategy

• 3 years’ experience with Microsoft SQL Server, Netezza or comparable databases

• 3 years’ experience in a BI development

• This position requires experience with:

• Data Modeling (Logical models and Physicals models)

• ETL Tools such as SSIS, Informetica PowerCenter, or IBM DataStage

• MSTR Architect

• MSTR Object Manager

• MSTR I-Server

• MSTR Integrity Manager

• MSTR Command Manager

• Excellent analytical and problem solving skills

• SQL, PL/SQL proficiency

• Excellent communication skills, both written and verbal

• Certified as MCD (MicroStrategy Certified Developer) or above, or have comparable experience

• Ability to work well independently and accomplish goals with little or no supervision, or as part of a team as a contributor

• Full working knowledge of Microsoft Office Suite, emphasis in Excel

• Must be well organized, detail oriented and able to self-prioritize work

• Must exhibit a high degree of professionalism

• Bachelor’s Degree in computer science or equivalent

• To perform this job successfully, an individual should have knowledge of BI tools and relational/MPP databases. This includes:

• MicroStrategy 9.2.1 and above (MSTR 9.4.1 preferred)

• Microsoft SQL Server 2008 and above (MSSQL 2014 preferred)

• Microsoft BI (SSIS and SSAS)