Data Analyst

Chameleon; Fairfield (NJ); On-site; USD 70,000 - 100,000; Full time

Job summary

Chameleon, a rapidly growing data-driven company in New Jersey, is seeking a Data Analyst who can turn scattered data into clear, confident business decisions. This on-site role emphasizes insight, strategy, and ownership rather than mere data movement.

You will integrate data from multiple CRMs and systems, automate reporting, and design Power BI dashboards for leadership. The ideal candidate has 2+ years building dashboards, strong SQL (Snowflake), and comfort turning ambiguity into trusted

Qualifications

• 2 years of experience building dashboards and insights (Power BI strongly preferred).
• Advanced SQL experience (Snowflake required; SSRS a plus).
• Experience aggregating data from multiple systems or CRMs.
• Comfort working with ambiguity and imperfect data.
• Experience in services-based businesses is a strong plus (home services a bonus, not required).
• Tableau experience is acceptable if you’re open to Power BI.

Responsibilities

• Turn data into clarity and drive better decisions across the business.
• Own ETL pipelines and automate reliable reporting.
• Design and own Power BI dashboards used by leadership.
• Partner with cross-functional teams to interpret insights.
• Improve data accuracy and usability across reports.

Skills

Insights generation

Advanced SQL

Data aggregation

Ambiguity tolerance

Industry experience: services

Power BI familiarity

Tools

Power BI

Snowflake

SSRS

Tableau

Job description

*** On-site, 5 days/week (non-negotiable) ***

This is not a reporting role…It’s an insight, strategy, and ownership role.

Our client looking for a Data Analyst who doesn’t just move data from one place to another—but turns it into clarity, confidence, and better decisions across the business.

If your strength is asking why, not just what, keep reading.

Why This Role Matters

The business is scaling quickly, and demand for data is coming from every direction —operations, marketing, finance, and leadership. Right now, the risk isn’t lack of data. It’s lack of insight.

This role exists to change that.

You’ll be stepping into a highly visible seat where your ability to:

• connect fragmented data,
• automate reliable reporting, and
• surface real business insights

…will directly affect how the company performs and how it’s perceived internally.

The Environment You’ll Step Into

• Data currently lives across three CRMs, with Snowflake as the source of truth
• A new CDP (Redpoint) is being implemented to unify and activate customer data
• Reporting today relies on SQL, SSRS, Snowflake, and Power BI
• There are many stakeholders requesting data—and they need help interpreting it, not just receiving it

This is a role for someone who enjoys complexity and knows how to bring order to it.

What You’ll Own

This role is built around doing one thing exceptionally well:

turning complex, multi-source data into insights and strategy the business can act on.

That includes:

Insight & Strategy

• Identify trends, patterns, and opportunities within customer, lead, and operational data
• Answer critical questions like:
• Where are leads really coming from?
• Are customers new—or returning from other services?
• How should teams adjust based on what the data is telling them?

Data Infrastructure & Automation

• Build and maintain ETL pipelines so reporting runs automatically and reliably
• Reduce manual reporting and increase trust in the numbers

Advanced Reporting

• Design and own Power BI dashboards used by leadership and cross-functional teams
• Ensure data accuracy, consistency, and usability across reports

Stakeholder Partnership

• Work closely with teams across the company to understand what decisions they’re trying to make
• Help non-technical stakeholders interpret insights—not just view dashboards

What Success Looks Like in 12 Months

• Core reports are automated, trusted, and widely used
• Teams feel confident in the data they’re getting
• Leadership sees analytics as a strength—not a bottleneck
• The analytics function is viewed as strategic, not reactive

This role has room to grow based on performance and impact.

The Right Background Looks Like This

• 2 years of experience building dashboards and insights (Power BI strongly preferred)
• Advanced SQL experience (Snowflake required; SSRS a plus)
• Experience aggregating data from multiple systems or CRMs
• Comfort working with ambiguity and imperfect data
• Experience in services-based businesses is a strong plus (home services a bonus, not required)
• Tableau experience is acceptable if you’re open to Power BI

This is not a fit if your experience is limited to Excel-based reporting or static data pulls.

Why High Performers Like This Role

• High visibility and real ownership
• Direct exposure to how data drives growth and profitability
• A collaborative, team-oriented environment
• A business backed by private equity with a clear growth and exit mandate

Final Note

This role is ideal for a Data Analyst who wants to be known for insight, influence, and impact—not just technical execution.

If that’s how you think about data, we should talk.