Beyond Finance is looking to hire a Senior Data Analyst to help business users understand customer and business behaviors by building dashboards, providing training on BI frameworks, and gaining insights from data. The role involves examining data for anomalies and patterns, building the BI layer in Looker, and creating data models for business users.
Requirements
- Building and transforming parameterized report models and advanced Looker dashboards using Excel, SQL, Python (Pandas, NumPy, Matplotlib) and Looker PDTs to monitor and report on key performance metrics in debt resolution industry
- Using SQL (including CTE's and Window Functions) to preprocess unstructured financial data, validating and analyzing data, managing data in target repositories, and utilizing Git to maintain version control
- Using Python to develop automation tools for monthly/weekly financial and capital market reporting processes
- Implementing and fine-tuning predictive financial models for debt resolution industry in Python using machine learning techniques including Multivariable Linear Regression, XGBoost, and Time Series Forecasting.
- writing SQL
- knowledge of dimensional modeling techniques
- author the ETL scripts
Responsibilities
- Build visualizations to help business users understand behaviors of customer base and business by gaining insights through building dashboard or providing training to utilize the BI framework.
- Develop a deep understanding of existing data, including how the data is produced and used by the application.
- Examine data by writing SQL and examining the data for anomalies and patterns, and confirming popular opinion.
- Build the BI layer of abstraction in Looker, providing the meaning created for BI reporting along with a Looker data dictionary; ensure BI access is considered when providing access to data and reporting.
- Utilize knowledge of dimensional modeling techniques and ability to generate models which help business users easily understand the data.
- Document and map the existing data structures from the operational system to the new curated data structures and author the ETL scripts.
- Work with various business groups to understand business needs and create a plan to deliver the data using the existing system or requesting new data be produced.
Other
- Partial remote work permitted as per company policy.
- Office location is in Chicago, IL.
- Master’s degree in Data Analytics, Computer Science, Accounting, or Finance
- 1 year of experience in financial data analysis or financial accounting
- Standard company benefits offered.
