200+ applicants

Company

Rapid Finance · 6 hours ago

BI Data Analyst

United States

Full-time

Remote

Mid, Senior Level

6+ years exp

Maximize your interview chances

FinanceFinancial Services

Hiring Manager

Sadia Khan

Insider Connection @Rapid Finance

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Partner with business teams to consult, provide solution to implement data solutions, KPI’s, automated reporting/process solutions and data related improvements, streamline data migration by working closely with our data engineers to meet business needs.

Design, develop, and evaluate recurring and ad hoc reporting / dashboards in Power BI to drive and monitor the business and our products using best practices in data visualization and reporting tools.

Present recommendations to identify BI related workflows and sequencing events for automating and streamlining reports

Configure data mart schemas within the data warehouse per the specifications of the BI Development team

Identify source data in transactional systems

Lead analytics for the Marketing team by developing key performance indicators, analyzing and reporting out on the performance of key growth and marketing metrics to gauge trends, benchmarks, and performance of growth strategies, as well as derive value by analyzing customer data and identifying marketing opportunities.

Document the characteristics of the data, such as size, cardinality, completeness, and quality to ensure that product delivery meets requirements.

Support Sales and Client Service by studying product usage patterns, proactively identifying customers who may be under-utilizing products or functionality, and identifying new customers.

Develop and deploy ETL scripts to extract data from source systems and populate data marts according to predefined specifications.

Synthesize current business intelligence or trend data to support recommendations for action

Analyze data on existing customer characteristics and campaign performance to enable continuous refinement of data-driven engagement marketing strategies.

Create visualizations, Dashboards and reports for requested projects

Perform queries to validate the accuracy and completeness of ETL scripts and BI applications

Develop optimization strategies to minimize data reload time

Monitor data quality, analytics and metrics results

Turn data into actionable insight

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data WarehouseBusiness IntelligencePower BISQLETL scriptingPythonTableauData visualizationData miningStatistical techniquesRData modelingAgile DevelopmentData quality monitoringAI/Machine LearningMarketing AnalyticsClient ServiceHighly organizedTechnical WritingProject management

Required

B.A./B.S. from an accredited university in Mathematics, Marketing Analytics, Information Systems, Business Information Technology, Economics; Computer Science, Statistics or a similar quantitative related field

6+ years of professional data analysis experience and DW/BI projects

Strong knowledge of AI/Machine Learning, data architectures, statistical techniques, and statistical computer languages

Thorough understanding of the following specific tools/technologies – Tableau, SQL, Python, MS PowerBI, IC Databases, Business Intelligence, Data Warehousing, including the skills to query database and recognize performance opportunities of reports/queries

Self-motivated with the ability to quickly learn new technologies

Strong written, presentation, and verbal communication skills

Strong analysis, communications, interpersonal skills, and project management skills

Problem Solver – Someone who makes recommendations by identifying the problem, collaborating with stakeholders and business process owners to solve complicated issues with sustainable processes and systems, with written documentation and follow up to test the implemented solution

Highly Organized – Ideal candidate will become a subject matter expert on all corporate data and be able to provide information upon request

Proven experience in ETL scripting and advanced knowledge of SQL, R, and Python

Experience in both E-R and dimensional data modeling

Experience with data visualization platform such as Microsoft Power BI, Tableau or DAX

Expertise in data mining, forecasting, simulation, and/or predictive modeling

Experience with database synchronization, incremental/periodic data reload processes, data cleansing, database audit logs and metadata management

Experience developing data marts for BI applications

Preferred

Master’s degree in Mathematics, Marketing Analytics, Information Systems, Business Information Technology, Economics, Computer Science, Statistics or a similar quantitative related field

Experience or education in banking deposits, loan instruments, accounting (general ledger systems), Marketing or MCIF (Marketing Information Customer file) systems experience or corporate finance

Familiarity with Agile Development methodology and Kimball SDLC

Technical Writing experience is a plus

Experience or knowledge of QlikView, Qlik Sense, Azure Databricks, Azure Data Factory, Data Lake Analytics, SSRS, SSIS and Power BI