Analytics Solution Associate

**JOB DESCRIPTION**

Take a lead role in acquiring, managing and retaining meaningful relationships that deliver outstanding experience to our customers. In this role, you will balance your focus on business results by offering options and finding solutions to help our customers with issues.

As an Analytics Solution Associate within our Data Engineering team, you will take a lead role in acquiring, managing, and retaining meaningful relationships that deliver outstanding experiences to our customers. You will balance your focus on business results by offering options and finding solutions to help our customers with issues.

**Responsibilities**:

- Design, develop, and maintain scalable & fault tolerant / resilient data pipelines using Snowflake and other cloud and non-cloud based solutions.
- Translate complex business requirements into scalable technical solutions meeting data warehousing design standards.
- Build and maintain governance processes to ensure that data in the repository is catalogued; described; owned; maintained; discoverable; controlled (for access and entitlement) - and that changes to data structures are managed via an appropriate process.
- Optimize and refine existing data processes to improve performance, scalability, and reliability.
- Collaborate with business, analytics team, project managers and other stakeholders to ensure data solutions are aligned with business needs.
- Monitor data pipelines, build and perform data quality & completeness checks, and ensure the best data practices across the organization.
- Provide mentorship and training on Snowflake best practices to junior team members and other stakeholders as and when required.
- Stay up-to-date with the latest advancements in Snowflake; Immuta; Starburst; AWS Glue and other data engineering technologies.
- Drive the design or review of test cases, process change requests, and manage a project’s scope, acceptance, installation and deployment.
- Effectively communicate with project team members and sponsors throughout the project lifecycle (status updates, gaps/risks, roadblocks, testing outcomes, etc.), Manage Snowflake data sharing, data exchange, and other features specific to the Snowflake ecosystem.

**Required Qualifications, skills and Capabilities**:

- Bachelor’s Degree in Computer Science, Information Technology, or related field.
- A minimum of 6+ years of experience in Data Engineering, with a deep focus on Snowflake
- Proficiency in SQL and experience with other data pipeline / ETL tools
- Proven track record in designing and implementing large scale data solutions in a cloud environment.
- Strong understanding of data warehousing concepts, ETL processes, and best practices (including auditing; logging; cataloging etc)
- Experience in performance and tuning and optimization of Snowflake.
- Ability to work collaboratively in a cross-functional environment and communicate complex technical concepts clearly to peers, management and stakeholders.

**Preferred Qualifications, skills and Capabilities**:

- Deep understanding of data modeling concepts like Star Schema, Snowflake Schema, and Data Vault Modeling
- Beyond just foundational data engineering - knowledge of Snowflake's advanced features
- Experience in working on SQL Servers and writing SQL Queries
- Experience in Alteryx - Alteryx Designer Core Certified
- Familiarity with data visualization and BI tools like Tableau or QlikView - and of using these in conjunction with cloud data environments.
- Experience with collaborative platforms and tools such as Jira and Confluence.
- Awareness of advanced concepts of Data Mesh, Data Fabric

**ABOUT US**

JPMorganChase, 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. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

**ABOUT THE TEAM**

J.P. Morgan Asset & Wealth Management delivers industry-leading investment management and priv