Lead Data Analyst

Staff Management Group - Passaic; Passaic (NJ); On-site; USD 244,000 - 292,000; Full time

Benefits offered by this job

401(k) matching

Visa sponsorship

Job summary

Staff Management Group - Passaic is seeking a Lead Data Analyst to design data models, build dashboards, and own the analytics SDLC. The role requires expertise in SQL databases, BI tools, and ETL across multiple data sources.

The successful candidate will mentor junior analysts, collaborate with cross-functional teams, and apply Agile practices to deliver analytics solutions that drive strategic decisions. Onsite in Passaic, NJ.

Qualifications

• Proven experience as a Data Analyst with demonstrated expertise in SQL databases.
• Strong proficiency with data visualization tools including Tableau, Power BI, Looker or equivalent platforms.
• SDLC processes and experience applying software development lifecycle analysis to analytics projects.
• Technical skills in R, Python, VBA, Bash (Unix shell scripting), and Talend or similar ETL tools.
• Expertise in database design and query management to optimize performance across large datasets.
• Familiarity with BI concepts such as dashboard development and reporting automation.
• Ability to interpret complex datasets into clear insights for business stakeholders.
• Knowledge of linked data principles and integration of diverse data sources.
• Strong project management skills in an Agile framework.
• Effective communication for requirements analysis and translating findings into recommendations.

Responsibilities

• Design and implement data models aligned to business needs and database design best practices.
• Build and maintain interactive dashboards and reports to visualize key metrics using Tableau, Power BI, Looker, and similar platforms.
• Own the analytics SDLC from requirements gathering through deployment and maintenance.
• Partner with cross-functional teams to translate business requirements into technical specs and actionable insights.
• Oversee ETL workflows to integrate data from multiple sources including SQL databases, Oracle, Talend, and Bash scripts.
• Perform advanced data analysis using R, Python, and Excel to identify trends and opportunities.
• Lead business intelligence efforts by developing dashboards and reports that support planning and efficiency.
• Mentor junior analysts on SQL query management and data visualization best practices.
• Apply Agile project management to coordinate analytics initiatives.
• Promote linked data management and integration of diverse datasets for comprehensive analysis.

Skills

SQL databases

Data visualization

Agile

Communication

Requirements analysis

Tools

Tableau

Power BI

Looker

Talend

Bash

Excel

VBA

SQL Server

Oracle

Job description

Lead Data Analyst role focused on building analytics solutions, dashboards, and data models to drive strategic decision-making.

Responsibilities

• Design and implement data models aligned to business needs and database design best practices
• Build and maintain interactive dashboards and reports to visualize key metrics using Tableau, Power BI, Looker, and comparable reporting platforms
• Own the full analytics SDLC, including requirements gathering, development, testing, deployment, and ongoing maintenance
• Partner with cross-functional teams to analyze business requirements, translate them into technical specifications, and deliver actionable insights
• Oversee ETL workflows to integrate data accurately from multiple sources, including SQL databases, Oracle, Talend, and Bash scripts
• Perform advanced data analysis using R, Python, and Excel techniques to identify trends and opportunities
• Lead business intelligence efforts by developing dashboards, visualizations, and reports that support strategic planning and operational efficiency
• Mentor junior analysts on SQL query management, data visualization best practices, and technical proficiency across Microsoft SQL Server and VBA
• Apply Agile project management principles to support timely delivery of analytics solutions
• Promote linked data management best practices and support integration of diverse datasets for comprehensive analysis

Requirements

• Proven experience as a Data Analyst (or similar) with demonstrated expertise in SQL databases such as Microsoft SQL Server or Oracle
• Strong proficiency with data visualization tools including Tableau, Power BI, Looker or equivalent platforms
• Solid understanding of SDLC processes and experience applying software development lifecycle analysis to analytics projects
• Technical skills in R, Python, VBA, Bash (Unix shell scripting), and Talend or similar ETL tools
• Expertise in database design and query management to optimize performance across large datasets
• Familiarity with business intelligence concepts such as dashboard development and reporting automation
• Ability to interpret complex datasets into clear insights for business stakeholders
• Knowledge of linked data principles and experience building integrated datasets from diverse sources
• Strong project management skills in an Agile framework to coordinate multiple initiatives
• Effective communication skills for requirements analysis and translating technical findings into actionable recommendations

Technologies

• Tableau, Power BI, Looker
• SQL, Microsoft SQL Server, Oracle
• Talend, Bash
• R, Python, Excel, VBA
• ETL, SDLC, Agile

Benefits

• 401(k) matching
• Visa sponsorship

Location

• Passaic, NJ (onsite)
• In person

Pay

• From $24,000.00 per month