BI Developer: Cube

$93,600 - $99,840/Yr

Intelliswift Software - New York, NY

Full-time

Hybrid - New York, NY

Professional, Scientific, and Technical Services

About the position

The BI Developer: Cube role focuses on collaborating with BI Analysts to gather customer requirements and enhance business intelligence tools. The position involves designing, developing, and evaluating innovative BI solutions, particularly in creating SSAS Tabular model cubes for expense reporting. The developer will also be responsible for data management, troubleshooting BI systems, and ensuring data quality to support business teams in improving key metrics and customer experiences.

Responsibilities

• Work with BI Analysts to understand customer needs.
• Collect, analyze, and share data to drive improvement in business metrics and customer experience.
• Utilize database and web application technologies to design and develop BI tools and automated reports.
• Perform data conversions, imports, and exports within and between software systems.
• Merge BI platforms with enterprise systems and applications.
• Enhance performance of BI tools by defining data filters and indexes.
• Document new and existing models, solutions, and implementations.
• Troubleshoot BI tools, systems, and software.
• Participate in workstream planning including inception, technical design, development, testing, and delivery of Microsoft BI solutions.
• Analyze business and functional requirements and translate them into scalable solutions.
• Conduct research and make recommendations on BI products and services, maintaining vendor interfaces.
• Maintain data quality and contribute to the development of quality metrics.
• Develop the SSAS Tabular model cube for expense reporting.
• Create a partition-based SSAS Tabular cube model for incremental data processing.
• Prepare project deliverable documents for database design and ETL processes.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Management or related field.
• 6+ years of technical expertise in MSSQL.
• 6 years of database designing experience for BI system data mart.
• 6 years of SSAS Tabular model cube development experience.
• 4 years of SSIS ETL development experience.
• Hands-on experience supporting Business Intelligence/Data Warehousing environments.
• Excellent written and verbal communication skills, along with strong analytical and problem-solving skills.
• Proficiency in MS Word, Excel, and PowerPoint.
• Ability to multitask in a fast-paced environment.
• 4 years of related technical experience as a Microsoft SSIS Engineer (Required).
• 6 years of related technical experience as a Microsoft SSAS Engineer (Required).
• Proficient in MDX & DAX (Required).
• 6 years of database administration experience (Required).

Nice-to-haves

• Bilingual (Korean & English) preferred but not required.
• Experience handling dashboards and other BI solutions using Tableau & Power BI, but not required.