Woongjin, INC.
BI Developer DB ETL
Woongjin, INC., Jersey City, New Jersey, United States, 07390
Job 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 workstream planning process including inception, technical design, development, testing, and delivery of Microsoft BI solutions. Also, in project management estimation process
Analyze business and functional requirements and translates 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.
Pay: $50 - $55/ hr
Qualifications: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, 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 require
Additional Information
All your information will be kept confidential according to EEO guidelines.
*** NO C2C ***
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 workstream planning process including inception, technical design, development, testing, and delivery of Microsoft BI solutions. Also, in project management estimation process
Analyze business and functional requirements and translates 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.
Pay: $50 - $55/ hr
Qualifications: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, 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 require
Additional Information
All your information will be kept confidential according to EEO guidelines.
*** NO C2C ***