Perform in-depth data analysis to assess the design and operational effectiveness of key IT and security controls via writing complex, reusable SQL code
Identify potential areas of risk and provide recommendations for improvement
Conduct detailed testing of system or model changes and document and communicate results to stakeholders
Work independently to identify and implement creative solutions to test complex data sets and data flows
Produce data extracts and reports via SQL from a variety of sources to support internal audit control testing
Translate vague and complex data requests into clear and actionable requirements
Test data ETL processes and validate data completeness and accuracy during ETL
Design, develop, and enhance metrics and dashboards to measure system performance and provide actionable insights for Internal Audit
Requirements
4+ years of technology experience in a data analytics role at a technology, consulting, financial institution, or a financial technology firm
Bachelor’s degree in Data Science, Computer Science, Statistics, or a related field (Master’s degree preferred)
Excellent analytical skills; strong SQL, Snowflake, and data visualization skills
Understanding of IT operations, IT and security infrastructure, and cybersecurity programs
Knowledge of software development life cycle (SDLC)
Ability to optimally collaborate in a cross-functional environment and under minimal direction
Strong communication skills, both verbal and written
Nice to haves: experience with model validations and regulatory examinations, GitHub and DevOps tools, Python, Looker/Superset/Tableau, experience in financial services or highly regulated environments, knowledge of cryptocurrency
Benefits
target bonus
target equity
medical insurance
dental insurance
vision insurance
401(k)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.