Business Intelligence Analyst

Company: Reali Inc
Location: San Mateo
Posted on: April 5, 2021

Job Description:

Reali is here to make home buying and selling simple, affordable, and stress-free. We were founded to develop a seamless, transparent, and highly efficient residential real estate and homeownership experience by partnering technology with a customer-centric team and years of real estate, loans, escrow, and business experiences. The Business Intelligence (BI) Analyst role will report directly to the VP of Business Operations and will be a strong contributor to the design, implementation & support of Reali's data systems. This role will assist in the designing and implementing architecture, tools, and processes needed to provide "single source of truth" reports to support data-driven decision making.This role requires experience in a wide variety of business areas and datasets to gather data from disparate sources, perform analysis, build models and present recommendations.-- The ideal candidate will be a skilled problem solver who is passionate about business intelligence, comfortable working in an agile environment and embraces the opportunity to--collaborate with the executive team to work on high-visibility, cross-departmental, strategic reporting and analyses.--On any given day, this role might be: Creating dashboards to inform decisions around revenue projections; Building SQL data models for predicting performance and identifying KPIs; and, identifying the most valuable opportunities for improvements across our funnel and quantifying the value. Responsibilities

• Proficiency in data modeling and visualization with the ability to adjust existing SQL logic to meet changing business needs
• Develop and maintain business data models and views to efficiently showcase data in reports and dashboards
• Collaborate with the Business Operations team to perform strategic and operational data analysis for all internal teams (marketing, product, engineering, finance, etc.)
• Monitor all KPIs and present emerging trends and actionable insights to leadership team
• Ensure data quality by testing tables, dashboards, models and analysis
• Measure and analyze A/B test results for product and marketing optimizations
• Launch surveys and polls to collect and provide customer insights
• Assist with financial presentations for quarterly reviews with senior management.
• Provide periodic and ad-hoc financial analyses and reporting in support of executive--management.
• Build forecasting and ROI models to project growth for various initiatives to assist with roadmap prioritization
• Learn and assist business leaders with data transformations and ETL projects
• Lead requirements gathering sessions, analyze requirements, design and develop analytical projects working together with users finding the best possible solution to a given business problem
• Contribute to data aggregation strategy for reporting, dashboards, and self-service analytics
• Build highly customized reports and develop creative solutions to apply business logic
• Document new and existing models, solutions, and implementations.
• Ensure that collected data is within required quality standards
• Train and assist users to transform data into action-oriented information and to use that information
• Architect Tableau/Looker projects from end to end; Lead root cause analysis efforts for operational issues; resolve them independently or with other team members
• Support business users answering complex business questions via Tableau and using ad-hoc SQL queries
• Build relationships with key business partners
• Develop dashboards and perform ad hoc analysis Qualifications (Must Haves)
  • Bachelor's degree (preferably in statistics, econometrics, computer science, engineering or other technical field)--
  • 2+ years of experience post- Bachelor's degree in the workforce is required
  • 2+ years of experience working as a data analyst/manager, business intelligence analyst/manager, or data scientist
  • Experience in either consulting, investment banking or technology environment is preferred
  • Advanced Excel Knowledge including Macros, Pivot Tables, and Formulas (arrays, lookups, logical, reference, and text functions)
  • Advanced SQL skills and experience writing complex queries
  • Demonstrated experience working with SQL and relational data (3+ years on a regular basis).
  • 2+ years of experience with either Python (scikit-learn, numpy, and pandas) or R.
  • Experience with business intelligence tools such as Looker and Tableau.
  • Experience working directly with cross- departmentally to build reports, dashboards and solving business questions with data
  • Strong understanding of business logic and incorporate into automated loading process for reporting tables, aggregates and data marts
  • Proven ability to organize and manage a diverse range of projects, prioritizing multiple tasks with competing deadlines (at times in high-pressure situations). Nice to Haves
    • DBT and Snowflake experience (Nice to have)--
    • Competitive Salaries, Stock options, and 401k
    • Choose from various full-family medical, dental, and vision plans
    • HSA, FSA (2), ---Basic Life (2X), STD, LTD
    • Employee Referral Program
    • Reali's Family & Friends Discounted Programs
    • Healthy Workplace environment: The InvestingInU Initiative provides an inclusive series of wellness sessions to boost each Reali family member as a whole being, mainly focused on 4 pillars: Wellbeing, Physical, Financial, Social.
    • D&I ---(Diversity & Inclusion) ---team and events Reali is made up of experts and technologists who collaborate to deliver transparent, stress-free real estate solutions for buyers, sellers, and agents. Headquartered in San Mateo, CA and founded in 2016, Reali supports the entire transaction process from beginning to end with full-service offerings including loans, mortgages, real estate, escrow and more! By merging decades of industry expertise with proprietary technology, the Reali team has developed a suite of intelligent products including the PricePredictorTM tool, which takes the complexity and uncertainty out of buying a home. Reali has cemented a winning reputation with an A+ from the BBB and was voted one of 2019's Best Places to Work.* We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Keywords: Reali Inc, San Mateo , Business Intelligence Analyst, Professions , San Mateo, California