Senior Data Engineer

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

Job summary

ASB Resources seeks a Senior Data Analyst to bridge business teams and the Enterprise Data group. You will transform data into insights, define metrics, ensure quality, and help expand a Snowflake-based analytics platform.

You will build dashboards with Tableau, optimize SQL pipelines, and collaborate with Finance, Sales, Operations, Product, and Engineering to deliver trusted data products and AI-ready data assets.

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 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 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.

Responsibilities

• 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, opportunities, and improvements.
• Define, calculate, and maintain standardized KPIs and business metrics.
• Present analytical findings to stakeholders and leadership.
• Develop and maintain SQL-based data transformation logic, views, and stored procedures in Snowflake.

Skills

Analytical thinking

Stakeholder management

Communication

Problem-solving

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field

Tools

Snowflake

Tableau

SQL

Python

Git

AWS (S3, Glue, Lambda)

Job description

The Senior Data Analyst will serve as the bridge between business stakeholders and the Enterprise Data team. This individual will transform data into actionable insights, define business metrics, ensure data quality, and help expand company's AI-ready data platform. They will work closely with Finance, Sales, Operations, Product, Customer Success, and Engineering to deliver trusted analytics, semantic models, dashboards, and data products.

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.