Business Intelligence Analyst

Product Management Remote, Mexico


Description

Position at LeadVenture

Business Intelligence Analyst
We are looking for a Business Intelligence (BI) Analyst to create and manage analytics and reporting dashboards using Power BI and analytics solutions that turn data into knowledge. In this role, you should have a background in data and business analysis. You will drive the research, design, and build of dashboards and drill-down reporting of metrics, KPIs and results for our dealers. Critical to success is the ability to transform raw data into visually appealing and informative reports and dashboards including the ability to organize a variety of reports into workspaces that allow users to quickly access reporting to address their most pressing questions. Dashboard and reporting usability is a top priority (maintaining version control, standardized templates, style guides and consistency). 
Here is more of what you’ll get to do: 
  • Translate complex business needs into actionable technical specifications for BI models and reporting solutions. 
  • Design, build, and maintain interactive BI models, dashboards, and reports using Power BI. Monitor and optimize Power BI service performance for maximum efficiency and accessibility. 
  • Develop and manage data pipelines from data lakes into the Power BI service, ensuring consistent and reliable data flow. 
  • Standardize and normalize data from various sources to ensure consistency and usability across the organization. 
  • Write and optimize SQL/Presto queries for curated data views, ensuring the accuracy and relevance of the data for reporting and analysis. 
  • Conduct ad-hoc queries and perform data analysis to provide timely insights and answers to specific business questions. 
  • Create and deliver high-quality, easy-to-understand reports for stakeholders at all organizational levels, supporting data-driven decision-making. 
  • Stay up to date on industry best practices and emerging trends in data reporting and analytics. 
You’ll thrive in this role if you have:
  • 5+ years of experience working with a BI tool, preferably Power BI and proven experience as a BI Developer. 
  • 3+ years of experience with digital analytics systems (Google Analytics, Piwik, etc.). 
  • Expertise with writing Power Query and DAX code. 
  • Significant experience normalizing and simplifying datasets, including using data best practices. 
  • Strong analytical and critical thinking skills including understanding what the data means and using it to create reports and dashboards that tell a story. 
  • Proven ability to summarize and present complex findings clearly and concisely to various technical and management level stakeholders. 
  • Experience with ETL and data modeling, specifically in AWS Data Lake environment preferred. 
  • Creative thinking and problem-solving abilities combined with an internal drive to stay on top of emerging industry trends. 
  • Experience creating and maintaining Power BI dataflows is a plus. 
  • Knowledge of Software Development LifeCycle (SDLC) like Agile preferred. 
  • Attention to detail, comfort with ambiguity. and ability to adapt to ongoing change. 
  • Rapid and data-driven decision-maker with a passion for digging into complex questions with an evidence-based approach. 
  • Strong internal motivation with proven abilities to take initiative and be innovative. 
  • Ability to work independently with limited supervision taking a proactive role in executing assignments. 
  • Strong attention to detail and organizational skills. 
  • Excellent written and verbal communication skills. 
Does this position sound like something you would enjoy and be successful at, but you’re not sure you have the exact qualifications to be considered? While our job descriptions are an outline for the type of candidate we’re looking for, it is not a checklist. We encourage you to apply! 
Who we are:
LeadVenture is the market-leading SaaS provider of digital retailing, eCommerce, digital marketing and eCatalog solutions for dealerships across 12 industry verticals including powersports, marine, RV, pre-owned auto, agriculture and more. Our family of brands includes Dealer Spike, Dealer Car Search, Frazer, Net Driven, Direct Communications, Inc. (DCi), Powersports Support, Level 5, PSM Marketing, Monroney Labels, and Interact RV. We are an international company with offices located in the United States, Mexico (Juniper Data Center), Belize (Dealer Spike Belize), India and The Netherlands. Together, we are LeadVenture.
LeadVenture provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, LeadVenture complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation, and training.

LeadVenture expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of LeadVenture employees to perform their job duties may result in discipline up to and including discharge.