Job Description
DESCRIPTION:
Duties: Maintain the Support of Business Intelligence portal for Home Lending Originations. Develop, Maintain, and Automate dynamic and interactive dashboards. Create or Modify SQL Stored Procedures/views. Analyze datasets and build data workflows. Develop and Automate the production of recurring summarized and detailed reports and dashboards using ETL technologies or other data wrangling options. Leverage advanced visualization techniques, ETL automation using Alteryx and ODBC connectors. Provide ad-hoc analysis and perform root cause analysis for any issues identified. Resolve or remediate any issues that occur. Update logical or physical data models based on new use cases. Deliver decision support tools and dashboards for business stakeholders. Identify inefficiencies and suggest automation or optimization opportunities, collaborating with cross-functional teams to streamline workflows. Create Package for Production Deployment and participate in Weekend Production deployment activities. Communicate clearly with team, stakeholders, requestors on timeline and any changes. Develop, test, and maintain critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm's business objectives. Perform work in compliance with process defined by Controls team. Monitor JIRA dashboard.
QUALIFICATIONS:
Minimum education and experience required: Master's degree in Information Systems, Computer Engineering, Computer Science, Mathematics, Statistics or related field of study plus 2 years of experience in the job offered or as Data Visualization Associate, Software Engineer, Data Analyst, Reporting Analyst, or related occupation. The employer will alternatively accept a Bachelor's degree in Information Systems, Computer Engineering, Computer Science, Mathematics, Statistics or related field of study plus 5 years of experience in the job offered or as Data Visualization Associate, Software Engineer, Data Analyst, Reporting Analyst, or related occupation.
Skills Required: This position requires two (2) years of experience with the following: Business Intelligence KPIs; Financial Data Analytics; Home Lending/Mortgage Processes; Advanced BI Development; Advanced Data Visualization; Data Warehousing Disciplines (Datamart, Metadata, SCD, CDC, Data and Quality Assurance); Root-Cause Analysis; Advanced SQL; SQL Server; T-SQL; Indexing and optimization; Table Partitioning; Dynamic SQL; CTEs Data Wrangling; Data Integration; Automation; ETL; Python; and Dashboard Performance Optimization to improve rendering times. This position requires one (1) year of experience with the following: Functional Testing; User Acceptance Testing; Unit Testing; and Ad-hoc Analysis to provide relevant context to existing logic or query in the report. This position also requires any amount of experience with: Teradata; SSRS; Power BI Cloud Service; Tableau; DAX (Power BI); Row Level Security; JavaScript; Power Shell; Git; JIRA; AWS Cloud; Alteryx; Visual Studio; Agile SDLC; Risk Assessment; Statistical Analysis; and Data Architecture Disciplines in each of the following stages: Data Ingestion, Staging, Processing, and Data Model design using Erwin.
Job Location: 8181 Communications Pkwy. Plano, TX 75024.
About Us
Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
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.
Equal Opportunity Employer/Disability/Veterans
About the Team
Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.
