BI Developer – (BI and Analytics)-Associate

You are a strategic thinker passionate about driving solutions in BI and Analytics (Alteryx, SQL, Tableau), you have found the right team.

As a Business Intelligence Developer – Senior Associate within the Asset and Wealth Management Finance Transformation and Analytics team, you will be responsible for defining, refining, and achieving set goals for our firm. Your role will involve designing the technical and information architecture for Management Information Systems (DataMarts) and Reporting Environments. You will focus on data modeling and database design for the Asset and Wealth Management Line of Business. Additionally, you will support the Management Information Systems team in query optimization and the deployment of Business Intelligence technologies, including but not limited to Alteryx, Tableau, Databricks, Microsoft SQL Server (T-SQL programming), SSIS, and SSRS. You will design and develop complex dashboards from large and diverse data sets, scope, prioritize, and coordinate activities with product owners, and partner with technology teams to identify solutions for establishing a robust Management Information Systems environment. Your responsibilities will also include designing and developing complex queries to provide data inputs for dashboards and reports from large data sets. You will contribute to agile improvements by sharing experiences and knowledge with the team and advocating for the implementation of Continuous Integration/Continuous Deployment (DevOps) workflows. The ideal candidate will be highly skilled in reporting methodologies, data manipulation, and analytics tools, with expertise in the visualization and presentation of enterprise data.

Job Responsibilities:

• Design the technical and information architecture for the MIS (DataMart’s) and Reporting Environments.
• Focuses on data modelling and database design for the AWM LOB.
• Support the MIS team in query optimization, and deployment of BI technologies including but not limited to Alteryx, Tableau, Databricks, MS SQL Server (T SQL programming) /SSIS and SSRS. 
• Design and develop complex dashboards from large and/or different data sets.
• Scope, prioritize and co-ordinate activities with the product owners. 
• Partner with technology teams to identify solutions required to establish a robust MIS environment.
• Design and develop complex queries which caters to data inputs for the dashboards/reports from large data sets.

• Work on the agile improvements by sharing experiences and knowledge with the team. Advocate and steer the team to implement CI/CD (Devops) workflow. 

• Be highly skilled in reporting methodologies, data manipulation & analytics tools and have expertise in the visualization and presentation of enterprise data.
   

Required qualifications, capabilities and skills.

• Bachelor’s Degree in MIS, Computer Science, or Engineering.  Different field of study, with significant professional experience in BI Development, is acceptable. 
• Strong Data Warehousing-BI Skills. Experience Required: 12+ in Data warehouse, ETL and visualization.
• Strong work experience in data wrangling tools like Alteryx.
• Working Proficiency on Data Visualizations Tools. Experience on BI technologies not limited to Alteryx, Tableau, MS SQL Server (SSIS,SSRS), Databricks, ThoughtSpot
• Working knowledge in querying data from databases such as MS SQL Server, Snowflake, Databricks etc.
• Strong knowledge of designing database architecture and building scalable visualization solutions. Ability to write complicated yet efficient SQL queries and stored procedures.
• Working experience on building end to end ETL processes. 
• Experience in working with multiple data sources and handling large volumes of data. 
• Experienced in conversion of data into information. 
• Experience in end-to-end implementation of Business Intelligence (BI) reports & dashboards. 
• Good communication and analytical skills
   

Preferred qualifications, capabilities and skills

• Exposure to cloud based Analytics, Python would be an added advantage
• Exposure to automation tools like UIPath, Blue Prism, Power Automate etc.
• Working knowledge on CI/CD workflows and automated deployment and experience on scheduling tools like Control M.

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.

J.P. Morgan Asset & Wealth Management delivers industry-leading investment management and private banking solutions. Asset Management provides individuals, advisors and institutions with strategies and expertise that span the full spectrum of asset classes through our global network of investment professionals. Wealth Management helps individuals, families and foundations take a more intentional approach to their wealth or finances to better define, focus and realize their goals.​