Job Description A suitable Business Intelligence developer will be responsible for developing and supporting end to end BI solutions in Client Intelligence team at JP Morgan. Must have excellent understanding of Data warehouse principles and hands on experience on working with ETL tools like Informatica at least one reporting platform from Qlik Sense, Tableau or Cognos.
The role offers opportunity to interact and support needs of our large user base in NA region, perform application modernizations, work on end to end BI stack including dashboarding.
Responsibilities:

• Develop and maintain business intelligence solutions that caters our evolving userbase, this includes data warehouse, ETL, self-service reporting.
• Provide technical support client users, internal employees and production management team on rota basis for North America region (Involves work outside office hours).
• Understand reporting Data models, create insightful and engaging reports using multiple reporting platforms within our ecosystem.
• Understand reporting systems architecture, load balancing, user access controls
• Manage utilities that controls job scheduling, report distributions. Monitor data loads and perform alerting as needed.
• Liaise with DBA, IT Change control, Infrastructure team, application teams to maintain our service levels.
• Perform routine maintenance and troubleshooting of application on server for optimal performance
• Create and maintain documentation associated with the applications, reverse engineer business critical applications to document the existing functionalities and transformation logic.

Skills required to be considered for this role:

• 5+ years of software development experience with excellent understanding of Data warehouse principles
• 3+ Experience with at least one reporting tools (Qlik Sense/Cognos/Tableau)

Preferred:

• Expert in writing and debugging SQL Queries
• 3+ year experience and hands on proficiency in the following tools/skill sets are a must: Informatica, Oracle and UNIX scripting, delivering high quality solutions.
• Have a working understanding of visual analytics best practices, development, Processes and knowledge of typical BI & Analytics tools and technologies.
• SDLC lifecycle experience leading development efforts within data warehouse environment with complex dataflow and data integration from multiple sources with different integration strategies (push vs pull, file vs database, etc.)
• Knowledgeable with data warehouse concepts such as: SCDs, star schema, hierarchy, aggregation.
• Proficiency in reverse engineering, any transformation logic within a Reporting application / ETL / Oracle PL-SQL / UNIX script etc
• Demonstrated ability to understand and work effectively within complex IT environment containing onshore/offshore model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup.
• Knowledge of one or more of the followings would be a plus: Autosys and star schema-based reporting
• Agile methodologies - Jira, Kanban, Scrum
• Ability to perform data analysis and troubleshoot data integrity issues
• Able to communicate effectively with other team members and business

About Us JPMorgan 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.
The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.
As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.
Equal Opportunity Employer/Disability/Veterans
About the Team Our Corporate & Investment Bank relies on innovators like you to build and maintain the technology that helps us safely service the world's important corporations, governments and institutions. You'll develop solutions that help the bank provide strategic advice, raise capital, manage risk, and extend liquidity in markets spanning over 100 countries around the world.