Lead Data Insights Analyst (SQL, Root Cause Ana...

pureIntegration is a technology consulting firm with 22+ years of experience servicing Fortune 100 clients headquartered in the DC area. We serve clients in the fastest growing industry of communications, media, and entertainment. 

We are looking for a hands-on Analytics Lead who can go beyond “what happened” and uncover why it happened and what should be done next.

In this role, you will work with large-scale operational data to identify drivers of key trends, generate actionable insights, and guide business decisions. You will also lead a small team of analysts, ensuring high-quality, accurate, and impactful analysis.

This is a high-visibility, stakeholder-facing role requiring strong communication, structured thinking, and the ability to influence outcomes.

This is a fully remote, W-2 hourly contract role (6–9 months) that requires frequent travel to client locations across the U.S.

The hourly range is $60/hr - $75/hr. Candidates will be paid based on their work experience and skills. Candidates are also eligible for limited benefits such as health insurance, professional development, training, our referral bonus program, and our wellness program.

Responsibilities

• Lead end-to-end analytical investigations to answer business questions such as:
  • Why did key metrics change?
  • What are the drivers behind customer or operational trends?
• Perform deep-dive, hypothesis-driven analysis using SQL and Excel.
• Identify root causes using segmentation, trend analysis, and comparative analysis.
• Translate complex data into clear, actionable insights for leadership.
• Create high-quality deliverables (PowerPoint, summaries, recommendations).
• Partner with business and technical stakeholders to validate findings.
• Manage and mentor a team of analysts (delegation, QA, prioritization).
• Ensure accuracy through data validation, reconciliation, and quality checks.
• Drive structured problem-solving and analytical rigor across the team.

• 7–10+ years of experience in data analysis, advanced analytics, data science, or a related field.
• Bachelor’s degree in Engineering, Computer Science, Statistics, Mathematics, Information Systems, or a related discipline, or equivalent professional experience.
• Strong experience in data analysis focused on insights (not just reporting)
• Expertise in SQL (complex queries, joins, aggregations)
• Advanced Excel skills (pivot tables, data manipulation)
• Proven experience performing:
  • Root cause analysis
  • Trend/driver analysis
  • Hypothesis-based problem solving
• Experience presenting insights to business stakeholders/leadership.
• Strong communication and storytelling skills

NICE-TO-HAVE:

• Experience with Tableau or MicroStrategy.
• Experience working with large datasets (e.g., Redshift, data warehouses).
• Telecom, operations, or customer behavior analytics experience.
• Experience leading or mentoring analysts.
• We are specifically looking for candidates who can interpret data and influence decisions.

⭐ What Success Looks Like:

• You identify the true drivers behind business trends.
• Your insights lead to clear, actionable decisions.
• Your work stands up to scrutiny and is data-validated.
• Your team delivers accurate, high-quality analysis at scale.

pureIntegration is an Equal Opportunity Employer (EOE), qualified applicants are considered for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or veteran status. All your information will be kept confidential according to EEO guidelines. Additionally, the Wage Transparency Omnibus Amendment Act of 2023 grants you rights regarding transparency in wage information. To learn more, please refer to this link. Disability Accommodation for Applicants to pureIntegration

pureIntegration provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. For reasonable accommodation requests, please contact us by email at [email protected] or by mail to: pureIntegration, Human Resources Department, 1801 Robert Fulton Dr, Suite 450, Reston, VA 20191. Please indicate the position you are applying for.

• Know Your Rights: Workplace Discrimination is Illegal (dol.gov)
• Right to Work (English and Spanish).pdf
• E-Verify Participation Notice (English and Spanish).pdf

pureIntegration would love to hear from you - your career journey starts here!