The Corporate Insights & Analysis team is composed of highly talented and motivated individuals who empower the workforce to make informed decisions that drive value, growth, and efficiency throughout the enterprise. We provide actionable insights based on consistent, trusted data through a robust framework of analytics, infrastructure, and visualizations. Our Data Technology Specialists believe that the key to success, is creating a team environment in which everyone can contribute and cultivate a community where Engineers and others can depend on each other for help, learning and development. Currently looking for a Data Warehouse Engineer who will be able to understand and analyze business requirements, as well as design, develop and maintain data warehouse systems, solutions and processes used for storing current and historical data to be used for reporting and data analytics within enterprise environment. A successful architect would be required to ensure the highest quality solutions are delivered to our workforce. Responsibilities
● Design and implement dimensional modeling using Ralph Kimball Methodology using MSBI technology suite.
● Write efficient code in Microsoft T-SQL
● Design and develop high quality ETL solution using SSIS
● Understand and adapt to new technologies, tools, methods and processes from industry
● Bachelor’s degree, preferably in Computer Science or equivalent professional experience
● 6+ years of experience in enterprise data warehouse design and development
● 5+ years of experience in Advanced SQL programming working with large data sets
● Strong data modelling skills with solid knowledge of industry standards such as dimensional modelling, star schemas etc.
● Hands on development experience in building ETLs
● Experience in creating and maintaining Clustered Columnstore tables on SQL Server 2016
● Good to have experience in SSAS and MDX
21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
I have experience in oracle(sql developer), mysql, ETL and datawarehousing. i have 5+ year of experience in writing complex sql to give perfect dataset for analyse purpose.