Creates data solutions that outline the quality and effectiveness of operational processes. Conducts ad-hoc analysis according to Scrum methodologies. Partners with stakeholders in functional, field, and operational teams to improve operational metrics. Leverages advanced tools and technologies to bring world class data analytics to organization, including SQL, R, Alteryx, and Tableau.
Primary Responsibilities :
Provides detailed data analyses around work processes that results in standardized reporting.
Supports ad-hoc analyses around our core processes to provide intelligence and insights on areas of process improvement to reduce costs.
Provides highly engaging data visualizations that showcase key operational reports.
Identifies and develops metrics that provide more insight into customer and operational experiences.
Executes data analysis using an iterative approach.
Develops and implements data environment, including documentation of upstream process flows, data lineage, and data dictionaries.
Develops, maintains, and promotes data architecture.
Contributes to the understanding of the data by developing an incremental knowledge of key data tables and patterns.
Education and Experience :
Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Computer Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience in the job offered or three (3) years of experience performing data modeling, data analysis, and data transformation within financial services industry.
Or, alternatively, a Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Computer Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience in the job offered or one (1) year of experience performing data modeling, data analysis, and data transformation within financial services industry.
Skills and Knowledge :
Candidate must also possess:
Demonstrated Expertise ("DE") designing and developing extraction, transformation, and loading (ETL) processes, using Informatica and Oracle PL/SQL.
DE developing Business Intelligence solutions for reporting using Tableau.
DE designing and developing data warehouses and data modeling using Oracle PL/SQL and IBM Netezza SQL.
DE project managing data analysis and reporting projects using Agile tools and methodologies, including Scrum, Kanban and JIRA.