Senior Data Analyst – Enterprise Data & Analytics

ASB Resources; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

ASB Resources in New York is seeking a seasoned Business Intelligence Engineer to design and maintain executive dashboards and data workflows using Tableau and Snowflake. You will partner with Finance, Sales, Operations, Product, and Customer Success to translate business needs into scalable analytics solutions and drive data‑driven decisions.

You will own data quality, governance, and semantic models, contribute to ETL/ELT development, and validate AI‑ready data outputs.

Qualifications

• Bachelor's degree in a related field.
• 4–7 years of data analytics or BI experience.
• Advanced SQL with complex queries and performance tuning.
• Experience with Snowflake and Tableau.

Responsibilities

• Develop and maintain executive dashboards, reports, and scorecards.
• Translate business requirements into analytical solutions with cross-functional partners.
• Perform ad hoc analysis to identify trends and opportunities.
• Define and maintain KPIs and metrics across the organization.
• Present findings to stakeholders and leadership.
• Develop SQL-based data transformation logic in Snowflake.
• Support ETL/ELT pipelines from source systems (PostgreSQL, SQL Server, Salesforce, APIs, S3).
• Validate data ingestion for completeness and accuracy.
• Troubleshoot pipeline issues with Data Engineers.
• Optimize SQL queries, data models, and reporting structures.
• Participate in SDLC, change management, and environment deployments.
• Contribute to data modeling and curated reporting datasets.
• Monitor data quality and establish governance standards.
• Validate AI-assisted analytics and improve metadata and definitions.

Skills

SQL proficiency

Data analytics

Stakeholder management

Communication

Agile methodologies

Problem-solving

Attention to detail

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics

Tools

Snowflake

Tableau

Git

Python

AWS S3 / Glue / Lambda

Job description

Key Responsibilities

Business Intelligence & Analytics

• Develop and maintain executive dashboards, reports, and scorecards using Tableau and Snowflake.
• Partner with Finance, Sales, Operations, Product, and Customer Success to translate business requirements into analytical solutions.
• Perform ad hoc analysis to identify trends, business opportunities, and operational improvements.
• Define, calculate, and maintain standardized KPIs and business metrics across the organization.
• Present analytical findings and recommendations to business stakeholders and executive leadership.
• Develop and maintain SQL-based data transformation logic, views, and stored procedures within Snowflake.
• Support the design, testing, and maintenance of ETL/ELT data pipelines from source systems such as PostgreSQL, SQL Server, Salesforce, APIs, and Amazon S3.
• Validate data ingestion processes to ensure completeness, consistency, and accuracy across enterprise data platforms.
• Troubleshoot data pipeline issues, perform root cause analysis, and work with Data Engineers to resolve production incidents.
• Assist in optimizing SQL queries, data models, and reporting structures for scalability and performance.
• Participate in deploying data enhancements through Development, QA, Stage, and Production environments while following SDLC and change management processes.
• Contribute to data modeling initiatives, including dimensional models and curated reporting datasets.

Data Quality & Governance

• Monitor and improve enterprise data quality by identifying anomalies, inconsistencies, and reconciliation issues.
• Develop data validation processes and reconciliation reports between source systems and Snowflake.
• Maintain business definitions, data dictionaries, metadata, and documentation for enterprise reporting assets.
• Collaborate with business and engineering teams to define data standards, governance policies, and reporting consistency.

AI & Advanced Analytics

• Support the development and maintenance of semantic models used by Snowflake AI and enterprise data agents.
• Validate AI-generated responses and improve metadata, synonyms, and business definitions to enhance accuracy.
• Assist in evaluating emerging AI capabilities that improve analytics, reporting, and business decision‑making.
• Work closely with Data Engineers, Software Engineers, Product Managers, and business stakeholders to deliver enterprise data solutions.
• Participate in requirements gathering, solution design, testing, and user acceptance activities.
• Identify opportunities to automate manual reporting processes and improve operational efficiency.
• Promote best practices in analytics, data engineering, documentation, and data governance.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field.
• 4–7 years of experience in data analytics, business intelligence, or analytics engineering.
• Advanced SQL with experience writing complex queries, views, stored procedures, and performance tuning.
• Experience with Snowflake or another cloud data warehouse.
• Experience with Tableau or a comparable BI platform.
• Working knowledge of ETL/ELT concepts and modern data architectures.
• Familiarity with AWS services such as S3, Glue, or Lambda is preferred.
• Experience working with APIs and semi‑structured data (JSON, XML, Parquet).
• Basic Python scripting for data analysis or automation is a plus.
• Experience with Git, SDLC processes, and Agile methodologies.
• Excellent analytical, problem‑solving, communication, and stakeholder management skills.

This job description reflects someone who can not only build dashboards but also understand how data is ingested, transformed, governed, and consumed—making them an effective bridge between business users and your data engineering team while supporting your Snowflake‑based data platform.