Lovelytics

Lead Consultant, Business Analyst

Lovelytics

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
AI Apply
Apply

Job Level

Senior

Tech Stack

ETLSQL

About the role

  • Collaborate with the data modeling team to meet with business stakeholders across departments and gather detailed data and reporting requirements
  • Document source-to-target transformation rules in Excel, ensuring alignment with stakeholder expectations
  • Analyze source systems and datasets using SQL to understand structure, content, and quality
  • Work across a variety of business functions within the Energy and Utilities sector, helping uncover insights and inform data design decisions
  • Support UAT and validation by comparing expected vs. actual data transformations and results
  • Help improve internal documentation standards and support clear communication between business and technical teams

Requirements

  • 3–5 years of experience as a Business Analyst or Data Analyst, preferably in data lakehouse or BI projects
  • Proficiency in SQL, hands-on enough to query and analyze raw data from source systems
  • Strong skills in Excel, especially for documenting mappings and transformation logic
  • Excellent communication and stakeholder engagement abilities
  • Curiosity and interest in learning how different functions operate within the Energy/Utilities industry
  • Experience with data projects (ETL, data modeling, reporting) is a plus, but deep engineering experience is not required
  • Familiarity with Databricks
Benefits
  • Exciting projects with great clients in varying departments and verticals across the world
  • The ability to work closely with experienced data engineers and quickly grow and expand your skillset
  • The ability to work closely with all sizes of companies, ranging from Fortune 100 to small local businesses
  • A workplace where you are encouraged to challenge the status quo and develop new technologies, methodologies, and processes
  • A diverse team consisting of data gurus, experience seekers, and entrepreneurial minds that are always pushing to be better

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLExceldata modelingETLreportingdata transformationdata analysisdata lakehousebusiness intelligence
Soft skills
communicationstakeholder engagementcuriositycollaboration
DaVita Kidney Care

Business Analyst – Healthcare Operations

DaVita Kidney Care
Junior · Midfull-time$57k–$91k / yearTennessee · 🇺🇸 United States
Posted: 1 hour agoSource: davita.wd1.myworkdayjobs.com
OraclePythonSQLTableau
Centene Corporation

Business Analyst IV, Hedis

Centene Corporation
Mid · Seniorfull-time$86k–$155k / yearIllinois · 🇺🇸 United States
Posted: 2 hours agoSource: centene.wd5.myworkdayjobs.com
WRS Health

Financial Business Analyst

WRS Health
Mid · Seniorcontract🇺🇸 United States
Posted: 4 hours agoSource: wrshealth.applytojob.com
SQLTableau
Recruiting.com

Third Party Risk Management Analyst

Recruiting.com
Mid · Seniorfull-time$58k–$85k / yearArizona, Colorado, Texas · 🇺🇸 United States
Posted: 5 hours agoSource: myhrabc.wd5.myworkdayjobs.com