Job Title: Business Intelligence Engineer
Department: IT

SUMMARY
The Business Intelligence Engineer is responsible for the design and implementation of reporting and analytical solutions, and the tables and processes that support them. They must have an in-depth understanding of the business environment, and strong analytical and communication skills. The Business Intelligence Engineer is also responsible for obtaining the necessary requirements from diverse business groups to determine the appropriate design. This person should have sound knowledge of data modeling (both relational and multidimensional) and should have strong experience in the Microsoft BI stack, reporting, and data visualization tools.

ESSENTIAL DUTIES AND RESPONSIBILITIES
? Understand the current systems and data sets involved and identify gaps that prevent the availability of accurate and timely information
? Define, Build, and Maintain queries, reports and dashboards used for analytics
? Partner with DBA’s and other BI team members to deploy development work to various environments
? Coordinate with BI team members to introduce new data elements and metrics to existing data marts
? Work with SMEs to define what data sets are required to support the key executives and business groups
? Work with Business to understand the requirements in detail and come up with a solution approach
? Develop and demonstrate a strong understanding of business and BI needs for various functional groups
? Collaborate with DBA’s, Solution Architects, IT, Business partners and Functional owners for input and support
? Document and create necessary presentations for demonstration


Additional responsibilities:
Other duties may be assigned

QUALIFICATIONS
? Enterprise Level DW/BI Experience
? Understanding of DW architecture components such as ETL, ODS, OLAP, Tabular model
? Experience working with business partners to understand and obtain detailed requirements
? Ability to define prioritized set of requirements with business consensus
? Experience working in Dimensional modeling and BI applications development
? Experience in Microsoft BI stack tools and technologies or similar
? Experience working with data visualization tools such as Power BI or Tableau
? Ability to clearly define and articulate the data gaps, integration gaps and come up with a data model and approach to resolve them
? Ability to drive meetings representing Business SMEs, IT SMEs, Architects and Infrastructure experts to collectively arrive at a solution
? Familiarity working product based metrics, medical products and sales data coming from different geographic regions will be an advantage
? Clear communication skills and a Good team p
? Ability to deliver BI solutions through using MS tools such as MS Excel, PowerBI, SharePoint, Office365, Reporting Services
? Experience in advanced extensible reporting skills
? Minimum of 3 years experience with SSIS, SSAS and SSRS
? Experience utilizing SQL with a preference towards Server 2014 or higher

EDUCATION and/or Work EXPERIENCE
? Bachelor of Science in Computer Science, or similar field, or equivalent experience, required
? 6+ years of Enterprise Level DW/BI Experience
? Microsoft or similar BI certification is a plus

愛(ài)齊（上海）商貿(mào)有限公司是美國(guó)Align Technology Inc. 我們的產(chǎn)品為隱形牙套，是Align Technology專(zhuān)有的產(chǎn)品，在全球100多個(gè)國(guó)家銷(xiāo)售，并于1998年通過(guò)美國(guó)食品藥品管理局（FDA）審批。Align Technology Inc. 于2000年在美國(guó)納斯達(dá)克上市，全球至今已經(jīng)有幾百萬(wàn)患者使用過(guò)Invisalign隱適美產(chǎn)品。
愛(ài)齊公司強(qiáng)調(diào)創(chuàng)新、以結(jié)果為導(dǎo)向、以客戶(hù)與團(tuán)隊(duì)合作為中心、自我領(lǐng)導(dǎo)的能力與精神，為員工提供多元化的發(fā)展空間，并為員工創(chuàng)造學(xué)習(xí)、友好、合作、健康的工作環(huán)境。
我們?cè)谥袊?guó)成立六年多，已經(jīng)成功建立了市場(chǎng)品牌并開(kāi)始商業(yè)運(yùn)作，我們竭誠(chéng)邀請(qǐng)充滿(mǎn)工作激情，具有挑戰(zhàn)精神的精英加入到我公司，共同創(chuàng)造你與公司的成功！