Analytics Solutions [Multiple Positions Available]
Share
Job Location:
Wilmington, DE - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Department:
Job Summary
DESCRIPTION:
Duties: Collect process analyze and deliver data to aid with decision-making advisor scorecard tracking and public reporting. Implement ETL processes to clean transform and pre-process financial data for analysis and reporting and drive business intelligence initiatives. Implement automation solutions for routine data processing tasks reducing manual efforts and improving efficiency in handling financial data. Collaborate with cross-functional teams and other stakeholders including Product Controllers and CFOs to understand data requirements and provide effective technical solutions. Drive and monitor the monthly reporting process for public disclosure while establishing controls for financial reporting. Develop financial models to evaluate the impact of proposed changes market impacts or strategies on the organizations financial performance. Identify opportunities for streamlining and optimizing financial processes to enhance efficiency reduce costs and improve overall performance. Communicate complex financial information and analysis to both technical and non-technical stakeholders. Partner with finance and technology teams to identify and resolve issues that come up in monthly reporting reviews. Define and track key performance indicators to assess financial performance providing actionable insights to business finance managers and stakeholders. Work with cross-functional project teams ensuring alignment with project goals scope timelines and driving the execution of platform modernization projects across MIS applications and infrastructure. Coordinate and conduct training sessions and knowledge transfer activities to ensure that finance teams are well-prepared for new processes or systems introduced through various projects impacting MIS data applications or infrastructure.
QUALIFICATIONS:
Minimum education and experience required: Masters degree in Applied Computer Science Computer Science Computer Engineering or related field of study plus 3 years of experience in the job offered or as Analytics Solutions Business Intelligence Analyst Software Engineer Database Administrator or related occupation. The employer will alternatively accept a Bachelors degree in Applied Computer Science Computer Science Computer Engineering or related field of study plus 5 years of experience in the job offered or as Analytics Solutions Business Intelligence Analyst Software Engineer Database Administrator or related occupation.
Skills Required: This position requires experience with the following: Troubleshooting data including identifying and fixing issues with database queries stored procedures and query optimization using SQL; Creating stored procedures in SQL to automate manual processes using variables temp tables update inserts joins and indexes; Creating variance analysis datasets in SQL to identify drivers of differences between two sets of data; Developing automation solutions to streamline financial workflows and reduce manual errors using ETL tool such as SSIS Informatica Pentaho or Alteryx; Implementing and monitoring ETL solutions during production cycles to clean transform and pre- process financial data for analysis and reporting using SSIS Informatica or Pentaho; Performing financial data calculations involving multiple cells or ranges using at least one of the following Excel functions: vlookup xlookup sumifs countifs concate or index-match; Creating pivot tables to summarize and analyze large data sets; Developing financial dashboards and views incorporating interactive elements and drill-down capabilities using charting techniques and data visualization in Tableau or Cognos; Defining workflows scheduling batch jobs and monitoring using tools such as Control-m or Autosys.
Job Location: 880 Powder Mill Road Wilmington DE 19803.
Key Skills
- Adobe Analytics
- Data Analytics
- SQL
- Attribution Modeling
- Power BI
- R
- Regression Analysis
- Data Visualization
- Tableau
- Data Mining
- SAS
- Analytics
About Company
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 ov ... View more
