Address
Form of workSystem Analyst
Job Description
We are seeking an experienced System Analyst to perform data and system analysis, operationalize controls, and support data management capabilities for Compliance, Legal, Audit and Regulatory projects. This role will provide leadership and deep domain expertise for data from multiple administrative systems in the FinTech ecosystem (Wealth Management / Life Insurance / Annuity / Asset Management) to internal teams and external regulators in a timely manner. Successful candidates have extensive experience working with data analytics, data governance, and data protection with a strong SQL developer experience. Candidate also must have the ability to drive process efficiencies with a focus on enabling self-service.
Job Requirements
Interface with business and compliance teams to understand business and regulatory requirements, impact, and pain points that can be aided by business solutions, reports, and analytics
Interface with technology teams to export, transform, and deliver data elements to stakeholders in a timely fashion
Perform gap analysis and end-to-end architecture assessments to determine impact, root cause analysis, and solution options
Works with technology teams to identify and retrieve data, including client and policy level information
Ability to consolidate, merge, reconcile and format large data sets by sourcing raw and conformed data from multiple databases, tables, and systems, and overseeing that the data is accurate and properly translated that meets business requirements.
Oversee data quality and ensure data is properly translated and protected
Document the business and regulatory requirements, data elements, and data mapping
Identify, develop, and implement self-service and automated solutions where appropriate
Make recommendations for business rules and communicate develop solutions to stakeholders
Ensure key deliverables are met in an accurate timely manner and assisting in the troubleshooting of data problems and issues; make recommendations and provide alternative solutions when it applies
Ensure compliance with Our client security standards
Required Skills
5+ years of relevant experience in data analytics, systems analysis, and software development
Strong written and verbal communication skills with the demonstrated ability to work with all levels within the organization
Strong problem analysis and problem-solving skill with attention to accuracy and detail
Strong ability to model current and future state business processes and data domains/entities
Strong hands-on experience with:
o SQL (5+ years of proven experience)
o Database warehouse, data technologies, and data tools
o Developing insights from the analysis of the data
o Advanced level Microsoft Excel skills including functions, formulas, VLOOKUP, pivot tables, macros
Experience with:
o Data analytics, data visualization, reporting and business intelligence tools (Tableau, Spotfire, Qlik, etc.)
o Data and process modeling techniques and tools to represent current state and future state design and concept of operations
o Developing insights from the analysis of data
o Supporting various data management tools and technologies including but not limited to data cataloging, data quality/profiling, and data lineage
Demonstrated ability to collaborate, communicate, build relationships, and influence a community of data, risk, or IT professionals across lines of business and functional areas
Ability to work in a fast-paced environment and manage multiple simultaneous priorities
Ability to document technical processes, procedures, and solutions
Ability to think end-to-end, connect moving parts, and anticipate and manage change impacts
Ability to define and leverage metrics to drive performance and outcomes
Ability to explain technical solutions to technical and non-technical teams
Must be very organized and have excellent follow-up skills
Must be team oriented to work collaboratively and customer focus
Proactive self-starter with the ability to work independently with limited supervision
Use best practices and knowledge of internal or external business issues to improve services
Experience with compliance and regulatory projects and rules would be plus
Experience working in the Life Insurance, Annuities, Mutual Funds and Securities products would be plus
Experience in Agile methodologies would be a plus
Experience with Hadoop HiveQL and Ambari Hive would be a plus
Experience with AWS and programming languages would be a plus
Education
BS in Computer Sciences/Engineering or equivalent experience
