BI Developer: DB, ETL

$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 role focuses on collaborating with BI Analysts to gather and analyze data, ultimately enhancing business intelligence tools and reporting systems. This position is responsible for designing, developing, and maintaining BI solutions, ensuring data quality, and supporting the integration of BI platforms with enterprise systems. The role requires a strong technical background in database management and ETL processes, along with effective communication skills to translate business needs into actionable insights.

Responsibilities

• Work with BI Analysts to understand customer needs.
• Collect, analyze, and share data to help business teams drive improvement in key business metrics, customer experience, and business results.
• Utilize database technologies to design, develop, and evaluate innovative business intelligence tools and automated reports.
• Perform data conversions, imports, and exports of data within and between internal and external software systems.
• Merge BI platforms with enterprise systems and applications.
• Enhance the performance of business intelligence tools by defining data to filter and indexes.
• Document new and existing models, solutions, and implementations.
• Troubleshoot BI tools, systems, and software.
• Participate in the workstream planning process including inception, technical design, development, testing, and delivery of Microsoft BI solutions.
• Analyze business and functional requirements and translate these requirements into robust, scalable, operable solutions.
• Conduct research, make recommendations on BI products & services, and maintain interface with vendors.
• Maintain the quality of data and provide input to the development of data/information quality metrics.
• Develop the SSIS ETL project for the automated data processing and user alerting function.
• Make project deliverable documents for Database design and ETL process.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Management or related field
• 8+ years of technical expertise in MSSQL
• At least 8 years of Database designing experience for BI system data mart
• At least 6 years of 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
• Capability to multitask in a fast-paced environment
• SQL Server Database administration: 8 years (Required)
• Related technical (Microsoft SSIS Engineer): 6 years (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