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: 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 ***