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.
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 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