BI Developer(DB,ETL)

$83,200 - $108,160/Yr

BTI Solutions - Ridgefield Park, NJ

Full-time - Mid Level

Ridgefield Park, NJ

Professional, Scientific, and Technical Services

About the position

The BI Developer (DB, ETL) at BTI Solutions is responsible for collaborating with BI Analysts to understand customer needs and drive improvements in business metrics and customer experience. This role involves designing, developing, and evaluating business intelligence tools and automated reports, as well as performing data conversions and maintaining data quality. The developer will also participate in project management processes and work on the development of SSIS ETL projects for automated data processing.

Responsibilities

• Work with BI Analysts to understand customer needs.
• Collect, analyze, and share data to help business teams drive improvement in key business metrics.
• 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 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 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 along with strong analytical, 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).
• Bilingual (Korean & English) preferred but not required.

Nice-to-haves

• Handle Dashboards and other BI solutions using Tableau & Power BI, but not required.