Senior Analytics Data Architect — Snowflake & ELT

Pmalladmin; Jericho (NY); On-site; USD 95,000 - 105,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid vacation

Paid holidays

Employee discount

EAP & mental health

HSA/FSA

Annual merit increases

Job summary

Pmalladmin in Jericho, NY is seeking a Senior Data Solutions Engineer to lead analytics-focused data products. You will shape the analytics data layer, standardize KPIs, and deliver trusted, scalable data solutions for self-service analytics across BI tools.

You will partner with business users, analytics colleagues, and data engineering teams to ensure data reliability, documentation, and readiness for AI and advanced analytics initiatives.

Qualifications

• 5+ years in data analytics, analytics engineering, or data engineering.
• Advanced SQL skills and experience with Snowflake.
• Experience building ELT pipelines with Coalesce.io or dbt.
• Proficiency with BI tools Sigma, Power BI, Tableau, Looker.
• Strong data modeling knowledge including fact and dimension tables and star schemas.
• Ability to translate business needs into scalable data solutions.
• Strong analytical thinking and problem-solving skills.

Responsibilities

• Design, build, and own analytics-ready datasets in Snowflake via curated ELT pipelines.
• Develop Snowflake semantic views to standardize KPIs and metrics across teams.
• Translate analytical needs into scalable, reusable data solutions for business stakeholders.
• Enable and support self-service analytics across BI tools such as Sigma and Power BI.
• Document datasets, metrics, and analytical models clearly and accessibly.
• Monitor, validate, and improve data quality, performance, and reliability.

Skills

SQL

Snowflake

ELT pipelines

dbt

Coalesce.io

Sigma

Power BI

Tableau

Looker

Data modeling

Tools

Coalesce.io

dbt

Job description

Pmalladmin in Jericho, NY is seeking a Senior Data Solutions Engineer to lead analytics-focused data products. You will shape the analytics data layer, standardize KPIs, and deliver trusted, scalable data solutions for self-service analytics across BI tools.

You will partner with business users, analytics colleagues, and data engineering teams to ensure data reliability, documentation, and readiness for AI and advanced analytics initiatives.