Bi Data Analyst

Business Intelligence  Data Analyst Rapid Finance has a dynamic and challenging opportunity for a Business Intelligence Analyst to join our community. In this role, you'll be responsible for design, development, and implementation of Data Warehouse and BI programs to provide insights that drive effective business decisions. The position ensures the necessary department data is available for use, either through the corporate data warehouse or by direct extraction from the source. If you want to help us harness the power of data to propel us into the future, we'd love to chat with you. The ideal candidate will work with stakeholders including senior leadership, program management, project teams, and end users to identify requirements in support of business visualization objectives. Leverage data visualization tools and techniques to design, develop, and implement comprehensive automated solutions that support decision making and sector requirements. Maintain and enhance existing visualization solutions currently in use throughout the sector. The BI Analyst must have the ability to translate business requirements into logical data models and data requirements. You will be the data expert responsible for retrieving and aggregating data from multiple sources, identifying key indicators and actionable insights, and effectively communicating the most important information to drive decisions. A day in the life of the Business Intelligence Analyst may include: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 reportsConfigure data mart schemas within the data warehouse per the specifications of the BI Development teamIdentify 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 actionAnalyze 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 projectsPerform queries to validate the accuracy and completeness of ETL scripts and BI applicationsDevelop optimization strategies to minimize data reload timeMonitor data quality, analytics and metrics resultsTurn data into actionable insight About You: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.  Master's degree in these disciplines are preferred.6+ years of professional data analysis experience and DW/BI projectsYou have strong knowledge of AI/Machine Learning, data architectures, statistical techniques, and statistical computer languages.Experience or education in banking deposits, loan instruments, accounting (general ledger systems), Marketing or MCIF (Marketing Information Customer file) systems experience or corporate finance is a plusThorough 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/queriesFamiliarity with Agile Development methodology and Kimball SDLCSelf-motivated with the ability to quickly learn new technologies Strong written, presentation, and verbal communication skills (Technical Writing experience is a plus). Comfortable and experienced in one-on-one interviews and leading small meetingsStrong analysis, communications, interpersonal skills, and project management skills are essentialProblem 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 solutionHighly Organized – Ideal candidate will become a subject matter expert on all corporate data and be able to provide information upon request. Technical skills required:Proven experience in ETL scripting and advanced knowledge of SQL, R, and PythonExperience in both E-R and dimensional data modelingExperience with data visualization platform such as Microsoft Power BI, Tableau or DAX.Expertise in data mining, forecasting, simulation, and/or predictive modelingExperience with database synchronization, incremental/periodic data reload processes, data cleansing, database audit logs and metadata managementExperience developing data marts for BI applicationsExperience or knowledge of QlikView, Qlik Sense, Azure Databricks, Azure Data Factory, Data Lake Analytics, SSRS, SSIS and Power BI is a plus. We invite you to learn more about our business, and join our conversation at @LifeAtRapid Discover what a career with Rapid Finance can do for you. Visit us today at rapidfinance.com/careers. Rapid Finance is an equal opportunity employer and committed to a diverse workforce.