Infrastructure Development - SQL OLAP/SSAS

Job Description

As an experienced new member of GTI Enterprise Infrastructure Services (EIS), we look first and foremost for candidates who are self-motivated and passionate problem solvers.You will be part of a talented team of professionals who extract, transform, load (ETL) data from disparate sources throughout the firm from flat files, databases, and web service APIs to our data warehousefor OLAP processing which supports a mature business intelligence tool that performs analytics using dashboards and visualization componentsSQL OLAP/SSAS Developer should be able to:- Develop SSAS cube and dimension models as per snow flake and star schema- Create dimensional usage mapping, measures, KPI, cube partitioning and writing MDX queries as per requirements.- Good in SQL scripting, writing stored procedures,views and integrating with SSIS packages.- Work as a individual contributor- Work with clients in resolving issues within appropriate timelines.- Have good written and verbal Communication Skills- Work independently and in a team with a high level of quality- Possess excellent presentation skills, interpersonal skills- Build inclusive and collaborative team culture- Work collaboratively with application owners and application development teams of source systems to triage and resolve data quality issues- Work collaboratively with our clients to help identify requirements and acceptance criteria to achieve business objectives- Provide ongoing technical process documentation updates to assist knowledge, uniformity and continuity for the entire team- Perform access lifecycle management and compliance mandate tasks for application functional IDs- Drive application maturation by offering improvements that make the product better, faster and cheaper- Maintain the health of our SSIS and SSAS server infrastructureSelected individuals will bring experience within the following requirements:? BS/BA degree or equivalent experience? Experience in the following technical disciplines:o 5+ years of experience with Microsoft SQL 2016 or later with experience writing TSQL, user defined functions, and stored procedures (Good to have)o 5+ years of experience with Microsoft SQL Integration Services (SSIS) and designing packages within Visual Studio (Good to have)o Experience with Data Warehousing conceptso Experience with ETL concepts including full and incremental load strategieso Effective communication and collaboration skillso Strong troubleshooting skills and ability to understand complicated technical issuesJPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world?s most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants? and employees? religious practices and beliefs, as well as any mental health or physical disability needs.

Keyskills :