Lead Data Analyst

Jobtailor; New Jersey; On-site; USD 95,000 - 140,000; Full time

Job summary

Jobtailor is seeking a senior data partner to deliver data insights, quality, and governance across the organization. You will translate business needs into technical specifications and guide data solutions from source to target.

You'll work with SQL, data modeling, ETL, and cloud platforms to support analytics, maintain data catalogs, and ensure data quality through audits. Strong collaboration with IT and business stakeholders is essential.

Qualifications

• 5+ years required; 7+ years preferred.
• 5 or more years’ experience in SQL and relational database management systems
• 3 or more years’ experience with data warehouse concepts and data modeling concepts and practices
• 2 or more years’ experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud)
• 2 or more years’ experience in ETL processes and data integration tools
• Experience in Microsoft Excel (advanced formulas, pivot tables, and data manipulation)
• Experience in data governance activities (business glossary, data catalogs, source-to-target mappings); exposure to Collibra preferred
• Experience in reference data management (tools like EDM / DRM preferred)

Responsibilities

• Analyze complex datasets to identify trends, patterns, and insights that support business objectives
• Translate business requirements into technical specifications for data solutions
• Perform data profiling, source-to-target mapping, and validation to ensure accuracy and consistency
• Support the implementation and maintenance of data governance frameworks and standards
• Ensure data quality through regular audits, validation processes, and adherence to data management policies
• Document data flows, data lineage, and system integrations across upstream and downstream systems
• Collaborate with stakeholders to define and maintain data definitions, business rules, and metadata
• Help design and develop ETL (Extract, Transform, Load) processes to support data integration initiatives
• Work with cloud‑based data platform and relational databases, SQL queries, and data modeling techniques to support analytical needs
• Troubleshoot data‑related issues and provide technical support for production systems
• Participate in testing activities by supporting QA resources with test case development, execution, and defect tracking
• Partner with business stakeholders, IT teams (ETL, QA & production support)
• Communicate findings, insights, and recommendations clearly to both technical and non‑technical audiences
• Participate in cross‑functional project teams to support enterprise and vertical initiatives
• Contribute to continuous improvement efforts by identifying opportunities for automation and process optimization

Skills

Analytical thinking

Attention to detail

Communication

Collaboration

Problem-solving

Stakeholder engagement

Documentation

Testing

Continuous improvement

Tools

SQL

ETL tools

Data modeling

Collibra

EDM/DRM

Job description

The successful candidate will act as a key data partner, delivering data insights, quality, and governance across the organization.

Responsibilities

• Analyze complex datasets to identify trends, patterns, and insights that support business objectives
• Translate business requirements into technical specifications for data solutions
• Perform data profiling, source-to-target mapping, and validation to ensure accuracy and consistency
• Support the implementation and maintenance of data governance frameworks and standards
• Ensure data quality through regular audits, validation processes, and adherence to data management policies
• Document data flows, data lineage, and system integrations across upstream and downstream systems
• Collaborate with stakeholders to define and maintain data definitions, business rules, and metadata
• Help design and develop ETL (Extract, Transform, Load) processes to support data integration initiatives
• Work with cloud‑based data platform and relational databases, SQL queries, and data modeling techniques to support analytical needs
• Troubleshoot data‑related issues and provide technical support for production systems
• Participate in testing activities by supporting QA resources with test case development, execution, and defect tracking
• Partner with business stakeholders, IT teams (ETL, QA & production support)
• Communicate findings, insights, and recommendations clearly to both technical and non‑technical audiences
• Participate in cross‑functional project teams to support enterprise and vertical initiatives
• Contribute to continuous improvement efforts by identifying opportunities for automation and process optimization

Requirements

• 5+ years required; 7+ years preferred
• 5 or more years’ experience in SQL and relational database management systems
• 3 or more years’ experience with data warehouse concepts and data modeling concepts and practices
• 2 or more years’ experience with cloud‑based data platforms (e.g., AWS, Azure, Google Cloud)
• 2 or more years’ experience in ETL processes and data integration tools
• Experience in Microsoft Excel (advanced formulas, pivot tables, and data manipulation)
• Experience in data governance activities (business glossary, data catalogs, source‑to‑target mappings); exposure to Collibra preferred
• Experience in reference data management (tools like EDM / DRM preferred)

Hard Skills

• SQL
• Data modeling
• ETL
• Data profiling
• Data validation
• Data governance
• Data quality
• Data integration
• Data analysis
• Data manipulation

Soft Skills

• Collaboration
• Communication
• Problem‑solving
• Analytical thinking
• Attention to detail
• Continuous improvement
• Stakeholder engagement
• Technical support
• Documentation
• Testing