BI Developer: DB, ETL
Apply NowCompany: Intelliswift
Location: New York, NY 10025
Description:
Job ID: 24-05996
Pay rate range - $45/hr. to $48/hr. on W2
NJ Preferred / US Remote possible
Job Function/Description:
Works with BI Analysts to understand customer needs.
Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.
Utilizes 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. Also, in the project management estimation process
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 & Qualifications:
Technical Skills
Bachelor's degree in Computer Science, Information Systems, Business Management or related field
8 + years of technical expertise (MSSQL)
At least, for 8 years of Database designing experience for BI system data mart.
At least, for 6 years of ETL development experience.
Hands-on experience supporting Business Intelligence/Data Warehousing environments
Excellent written and verbal communication along with strong analytical, and problem-solving skills
Proficiency in MS Word, Excel, and PowerPoint
Capability to multitask in a fast-paced environment
Requirement
SQL Server Database administration: 8 years (Required).
Related technical (Microsoft SSIS Engineer): 6 years (Required)
Additional
Bilingual (Korean & English) Preferred but not required
Handle Dashboards and other BI solutions using Tableau & Power BI, but not required
Pay rate range - $45/hr. to $48/hr. on W2
NJ Preferred / US Remote possible
Job Function/Description:
Works with BI Analysts to understand customer needs.
Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.
Utilizes 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. Also, in the project management estimation process
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 & Qualifications:
Technical Skills
Bachelor's degree in Computer Science, Information Systems, Business Management or related field
8 + years of technical expertise (MSSQL)
At least, for 8 years of Database designing experience for BI system data mart.
At least, for 6 years of ETL development experience.
Hands-on experience supporting Business Intelligence/Data Warehousing environments
Excellent written and verbal communication along with strong analytical, and problem-solving skills
Proficiency in MS Word, Excel, and PowerPoint
Capability to multitask in a fast-paced environment
Requirement
SQL Server Database administration: 8 years (Required).
Related technical (Microsoft SSIS Engineer): 6 years (Required)
Additional
Bilingual (Korean & English) Preferred but not required
Handle Dashboards and other BI solutions using Tableau & Power BI, but not required