Data Analytics (SAS,SQL)- Associate
Bengaluru, Karnataka, India
JPMorgan Chase & Co.
Audience Targeting partners with the Marketers to gather requirements, propose a design for targeting, segmentation and execute on the delivery of final audience. The team is also responsible for the development of code for data extraction and transformation, and deploying the audience into production.
This role involves performing Business Analysis and Database Marketing functions for the execution of complex portfolio marketing campaigns and projects, using Base SAS programming and SQL querying.
Job Responsibilities:
- Responsible for the development and execution of code to define customer populations to be targeted in complex marketing campaigns.
- Responsible for design of functional specification document used for execution of the campaigns
- Daily interactions with Marketers & project stakeholders on multiple projects - required to communicate and clarify requirements, results, and timelines
- Requires the ability to assess information extracted from multiple data sources, resolve inconsistencies, and transform high-level information into a detailed technical specification document.
- Adhere to process adherence requirements and checkpoints for campaign execution
- The candidate will also distinguish between requestors' wants and needs and to challenge assumptions in the programs and will recommend alternative solutions to technical and business related problems.
- Develop code based on technical specifications to extract and process large volumes of customer and account data.
- The candidate will need to validate, audit and test the output produced from their documents to ensure that the programs meets the original request.
- Adhere to the department’s code development and documentation procedures. Provide recommendations and feedback on how to improve or implement strong control procedures.
- The candidate may also direct efforts with internal and external stakeholders to coordinate end to end process delivery.
- Provide support on Adhoc requests and special projects as assigned.
Required Skills, Qualifications & Capabilities:
- 5+ years extensive experience in developing Base SAS codes for manipulating large amounts of data and creating reports using procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditional SAS data step programming.
- Experience in requirement gathering and interacting with off-shore partners
- Experience in database SQL querying (Oracle/Teradata)
- A background in marketing operations, direct marketing or data analysis.
- Strong analytical and project management skills demonstrated by previous work experiences.
- Solid understanding of consumer banking products is desired.
- Familiarity or experience in operations, direct marketing, and data analysis in a banking or financial institution environment a strong plus.
- Proficiency with Microsoft office is required and advanced Microsoft Excel knowledge is desired.
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. 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Banking Data analysis Data Analytics Excel Oracle SAS SQL Teradata
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Research Scientist jobs
- Open Junior Data Analyst jobs
- Open Business Data Analyst jobs
- Open Principal Data Scientist jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open BI Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Data Science Intern jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr. Data Scientist jobs
- Open Lead Data Analyst jobs
- Open Software Engineer, Machine Learning jobs
- Open Azure Data Engineer jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Marketing Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Engineering Manager jobs
- Open Product Data Analyst jobs
- Open Senior Software Engineer jobs
- Open Privacy-related jobs
- Open GCP-related jobs
- Open Tableau-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open Business Intelligence-related jobs
- Open Data governance-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Docker-related jobs
- Open Git-related jobs
- Open Snowflake-related jobs