BI Developer: Cube

$104,000 - $114,400/Yr

Woongjin - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

Specialty Trade Contractors

About the position

The BI Developer role at Woongjin, Inc. involves collaborating with BI Analysts to understand customer needs and enhance business intelligence tools. The position focuses on data analysis, development of SSAS Tabular models, and improving business metrics through innovative BI solutions. The developer will also be responsible for troubleshooting BI systems and participating in project management processes.

Responsibilities

• Work with BI Analysts to understand customer needs.
• Collect, analyze, and share data to improve key 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 the 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, 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 partition-based SSAS Tabular cube models for incremental data processing.
• Make 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.
• Strong analytical and problem-solving skills.
• Proficiency in MS Word, Excel, and PowerPoint.
• Ability to multitask in a fast-paced environment.

Nice-to-haves

• Bilingual in Korean and English (preferred but not required).
• Experience with Tableau and Power BI (not required).

Benefits

• Competitive hourly pay of $50 - $55.
• Opportunity to work in a rapidly growing company.