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 and web application 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 SSAS Tabular model cube for the end user’s expense reporting.
• Develop partition based SSAS Tabular cube model for incremental data processing and partial data processing
• Make project deliverable documents for Database design and ETL process.

Pay: $50 to $55/ hr

Qualifications

Technical Skills

• Bachelor’s degree in Computer Science, Information Systems, Business Management or related field
• 6+years of technical expertise (MSSQL)
• At least, for 6 years of Database designing experience for BI system data mart.
• At least, for 6 years of SSAS Tabular model cube development experience.
• At least, for 4 years of SSIS 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

• Related technical (Microsoft SSIS Engineer): 4 years (Required)
• Related technical (Microsoft SSAS Engineer): 6 years (Required)
• Design and develop Tabular models. (Required Skill)
• Proficient in MDX & DAX (Required Skill)
• Database administration: 6 years (Required).

Additional

• Bilingual (Korean & English) Preferred but not required
• Handle Dashboards and other BI solutions using Tableau & Power BI, but not required

Additional Information

All your information will be kept confidential according to EEO guidelines.

*** NO C2C ***