Responsibilities
- Gather requirements to build and maintain data analyses, risk triggers / rules, visualizations and interactive dashboards that will drive business decisions and risk monitoring (in BI tools, web analytics platforms, and excel)
- Facilitate the analytical needs of the business, collaborate in the design of diagnostic solutions, and deliver outstanding data products and insights
- Use internal and external analytics tools, SQL, and scripting languages to access and analyze multivariate data
- Perform deep analyses to help us understand our data better and help build out robust risk management and monitoring tools and reports for the business
- Use emerging tech and tools to evaluate trends and develop actionable insights
- Use data to independently uncover problems and business opportunities
- Support data migrations in order to automate repeatable tasks and KPI tracking throughout the business
- Track and analyze performance of various business and risk segments and programs to evaluate effectiveness
- Build analysis, data visualizations, and multi-functional reporting that provides critical support to the operations and decision-making of the organization
- Help translate business functional requirements into technical specifications and, conversely, technical approaches into easily digestible terms
- Provide analytics expertise to key business partners regarding data & analytics
- Support Commercial, Marketing & Risk teams with process improvements for optimized delivery of diverse data requests
- Support business partners in adopting reporting solutions and business intelligence tools for self-service
- Write LookML and SQL queries and build dashboards in Looker
- Systematically identify issues with data quality and help find solutions to address
- Assist with ad-hoc projects and tasks as necessary
Desired Skills/Education
- Bachelor’s degree or equivalent experience
- 2-4 years of experience in data analytics
- 2-4 years of experience in designing and authoring reports/dashboards using Looker (or similar tools like Tableau, Power BI) is required.
- Proven proficiency and flexibility to perform analysis in SQL, Excel, BI tools, or whatever is best suited for the problem
- Proven proficiency in basic statistics
- Strong communication skills
- Proven experience with web analytics tools
- Proven experience with business intelligence tools (Looker Required) and relational databases
- Prior experience with Data Science languages like Python, and/or R is preferred.
- Familiarity with ETL, data warehousing, and data modeling
- Expert SQL skills for complex querying, analysis, performance optimization, and persisting data
- Experience demonstrating analytical concepts to craft an actionable story for technical and non-technical audiences
- Understanding of data warehousing concepts, design, modeling, data engineering
- Skilled in analyzing, interpreting and summarizing data
- Very structured, detail-oriented and excellent data visualization skills
The requirements listed below are representative, but not all inclusive, of the knowledge, skill, and/or ability required.