Lead Consultant Data Analyst

Excella; United States; Remote; USD 125,000 - 182,000; Full time

Benefits offered by this job

Parental Leave

Health benefits

Annual Internet Reimbursement

Professional development

Job summary

Excella seeks a seasoned Lead Data Analyst to deliver high-quality data analysis and insights while mentoring junior analysts. This role balances hands-on data work with leadership to drive data-driven decision making across client engagements.

The successful candidate will ensure data integrity, optimize data models, and support cross-functional teams with critical insights. Excella supports flexible work locations and a strong focus on professional growth.

Qualifications

• 6+ years in data analysis or related fields.
• Expert SQL skills with optimization and data transformation.
• Extensive experience with Tableau or Power BI for dashboards.
• Strong cloud analytics knowledge (Google Cloud, AWS or Azure).
• Experience applying statistics to derive business insights.
• Excellent problem-solving and ambiguity management.
• Clear written and verbal communication with senior stakeholders.
• Experience leading teams and mentoring junior analysts.
• Hands-on with Agile and backlog tools (JIRA, Confluence).
• Python or R for data analysis is a plus.

Responsibilities

• Lead the analysis and interpretation of data to drive strategic business decisions.
• Mentor and coach junior data analysts, fostering their professional development.
• Partner with stakeholders to define data-driven solutions aligned with business goals.
• Design robust data models and architecture to support business needs.
• Develop advanced SQL queries to extract, transform, and analyze data efficiently.
• Oversee creation and optimization of dashboards, reports, and data visualizations.
• Ensure data governance, quality assurance, and security compliance.
• Drive adoption of new data analysis tools and methodologies.
• Collaborate with data engineers and scientists to improve pipelines.
• Communicate complex data insights to executives clearly.
• Lead Agile data analysis initiatives aligned with business strategy.

Skills

6+ years experience

SQL

Tableau

Power BI

Cloud Analytics

Statistics

Executive communication

Team mentoring

Agile

Jira

Python

R

Tools

Jira

Confluence

Google Cloud

AWS

Azure

Job description

Excella is a transformative technology firm that helps organizations unlock new possibilities. We believe the key to helping clients challenge the status quo and reach new heights lies in our talented people. That’s why we’re committed to developing talent and providing opportunities for career growth at every stage. Join our collaborative team dedicated to solving complex problems with sustainable solutions while building your future as a leader. At Excella, you’re empowered to make lasting impact, turning today’s challenges into tomorrow’s mission successes.

• Workplace locations look different for everyone. Excellians are a distributed workforce and whether you're working from your home office or a client site, we support a flexible work/life integration regardless of your location.
• We offer top of industry medical, dental, and vision benefits with multiple options to choose from such as an employer-contributed health savings account, infertility coverage, and orthodontia so you can select the plan that works best for you.
• Regardless of what stage of life you’re in, Excella wants to support you. We provide 8 weeks of Parental Leave, discounted pet insurance, and a Care.com membership with 3 back-up emergency child or elder care days annually – all available to you on your first day.
• Starting day one, every employee is bonus eligible and receives 15 days of paid vacation, 6 federal holidays, and 4 floating holidays.
• Doing your best work means having the best tools! Excella’s TechEleX program provides you with multiple options to suit your technology needs. Choose between a variety of Mac or PC devices, and to ensure your hardware remains current, at the end of a 3-year period Excella will replace your existing computer with a new model from the program. Plus, we’ll even give you the original device to keep for your personal use!
• With Excella’s Annual Internet Reimbursement benefit, all employees receive an additional $25 per month to help offset the cost of internet access. This initiative reflects our commitment to supporting you in staying connected and productive, no matter where you work.
• We'll invest in your career by providing 3 days of paid professional development every year, including an allowance for registration fees to attend classes, conferences, or obtain professional certifications.
• We encourage mindfulness and overall well-being through employee wellness events, a HeadSpace membership, as well as access to TalkSpace and mental health coverage through our medical plans.

Overview

We are seeking a seasoned Lead Data Analyst who will not only deliver high-quality data analysis and insights but also mentor and guide junior analysts within the team. This role requires a balance of hands-on technical expertise and leadership skills to drive data-driven decision-making processes across our client engagements. The Lead Data Analyst will be responsible for ensuring data integrity, optimizing data models, and supporting cross-functional teams with critical insights.

Responsibilities

• Lead the analysis and interpretation of data to drive strategic business decisions.
• Serve as a mentor and coach to junior data analysts, fostering their professional development.
• Partner with stakeholders to define data-driven solutions that align with business objectives .
• Design and implement robust data models and architecture to support business needs.
• Develop advanced SQL queries to extract, transform, and analyze data efficiently.
• Oversee the creation and optimization of dashboards, reports, and data visualizations.
• Ensure best practices in data governance, quality assurance, and security compliance.
• Drive the adoption of new data analysis tools and methodologies.
• Collaborate with data engineers and data scientists to improve data pipelines and accessibility.
• Communicate complex data insights to executive stakeholders in a clear and actionable manner.
• Lead Agile data analysis initiatives, ensuring alignment with overall business strategy.

Qualifications

• 6+ years of experience in data analysis or related fields.
• Expert SQL skills, including query optimization and data transformation.
• Extensive experience with Data Visualization tools such as Tableau or Power BI.
• Strong understanding of cloud analytics products such as Google Cloud, AWS, or Microsoft Azure.
• Proven experience applying statistical techniques to drive business insights.
• Exceptional problem-solving skills and ability to manage ambiguity.
• Strong verbal and written communication skills; able to engage with senior stakeholders.
• Experience leading teams and mentoring junior analysts.
• Hands-on experience with Agile methodologies and backlog management tools (JIRA, Confluence, etc.).
• Ability to develop and present executive-level data reports and recommendations.
• Proficiency in Python or R for data analysis is a plus.

This range represents the minimum and maximum base salary that Excella reasonably and in good faith expects to pay for this role. Actual compensation within the range will depend on factors such as skills, experience, training, certifications, and organizational needs. It is not typical for an individual to be hired at or near the top or bottom of the range.

Your pay also includes the opportunity for an annual bonus in addition to the base salary. This variable pay opportunity is dependent upon the attainment of shared firmwide goals and objectives as determined by Excella’s Executive Team. Certain eligibility and pro-ration rules apply.

Should your experience and knowledge qualify you for a different position or title within Excella, we may consider you for positions that better align with your qualifications. In that case, we will provide the range for those positions as well.

Pay Range $125,000 — $182,000 USD
Excella is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law. Excella is committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation to participate in the job application or interview process, contact [e-mail] or 703-840-8600