Location: New York,NY, USA
Job ID: 24-05997 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 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 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 SSAS Tabular model cube for the end user's expense reporting. • Develop a partition-based SSAS Tabular cube model for incremental data processing and partial data processing • 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 • 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, and 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) o Design and develop Tabular models. (Required Skill) o 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