BI Reporting Analyst II (Los Angeles)

Coordinate with Risk, Compliance, and Operations leaders, database engineers and executives to accomplish the following: · Translate business questions into verifiable hypotheses and make decisions through testing. Constantly exploring ways to improve and automate manual processes using data, machine learning, analytics. · Leverage data to understand our Small Business money movement Fraud, Financial and Compliance Risk in depth and identify trends that indicate elevated risk and inform and influence Risk Policy where applicable. · Proactively identify areas of opportunity and suggest projects to mitigate risk while providing an awesome and delightful customer experience. · Work with engineers to develop, test, and maintain accurate tracking, capturing and reporting of key Fraud Risk & Compliance metrics via server-side data collection and other database sources. · Maintain and improve a set of automated reporting to provide the basis for in-depth analysis and business evaluation; in doing so provide the standardized logic for Risk analysts to build upon. · Use tools and programs such Microsoft SQL Server (SSRS, SSAS), Excel, Python, Tableau, QlikView and many other internal tools to work efficiently at scale. · Provide analysis and insight that help manage Fraud & Compliance policies such as anti-money laundering and approvals/underwriting for all money movement products. · Utilize predictive modeling and other advanced techniques to prevent money laundering, acceptable use violations, first and third party fraud attacks. · Partner with Risk & Compliance Operations to provide analysis and reporting that enables efficient Risk processes and results in improved metrics and performance. . As a temporary agency partner to Intuit, we will consider for employment qualified applicants with criminal histories in a manner consistent with requirements of local law. Intuit is proud to be an equal opportunity and affirmative action employer. Accordingly, as a temporary agency partner to Intuit, we make hiring decisions without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran status, disability status, pregnancy, or any other basis protected by federal, state or local law. We also consider qualified applicants regardless of criminal histories for positions at Intuit, consistent with legal requirements. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process or for more information, please talk with your recruiter or send a request to ***. For more information about Intuit’s hiring practices, please read their EEO policy. Strong business acumen and exceptional analytical ability with 2-5 years of relevant experience. Experience in Financial Services or FinTech preferred. Advanced SQL and coding skills to perform data segmentation and aggregation from scratch. Microsoft SQL Server Management Studio experience highly preferred. Good working experience with data analytics and visualization tools (Excel, Power Pivot, Tableau, QlikView, etc.). Experience with statistical analysis preferred. Outstanding communication skills with the ability to deftly negotiate, prioritize across teams, influence decision makers and build consensus with teams. High degree of accountability, organization and empathy. Experience working with Key Performance Indicator metrics such as conversion rates, user acquisition, conversion and retention and/or product usage. Bachelor’s Degree in Quantitative Field or commensurate experience. Master’s degree advantageous. Skill Matrix Required Skills # of Years Highlight of Experience Advanced SQL 5+ Comfortable writing complex SQL queries that combine data from various tables, e.g. CTEs, temporary tables) Tableau 3+ Highly proficient in building effective data visualizations using Tableau dashboards Python 3+ Experience with Python programming for querying, data pipelines and ETL ETL 3+ Experience with Data ETL using any scripting language Soft Skills Excellent analytical and problem-solving skills. Outstanding communication skills with the ability to interpret data and tell a story. Preferred Skills # of Years Highlight of Experience Advanced Tableau and Python 5+ Advanced Tableau and Python programming abilities Excel VBA 2+ Experience with Excel macros and VBA Data Platforms 2+ Experience working with Redshift/Databricks/Jupyter Notebooks Experience in Payments/Financial Services Industry