On-Site Data Analytics IT Analyst (Power BI, Snowflake)

NFL; Buffalo (NY); Presencial; USD 85.000 - 105.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

On-site café

Fitness center

Flagship store discounts

Paid parking

Professional development opportunities

Descripción de la vacante

New Era Cap, LLC. in Buffalo, NY is seeking an IT Analyst (Data) to turn raw data into trusted insights within a Snowflake-based platform, building dashboards in Power BI and Tableau. You will partner with Data & Analytics and Enterprise Architecture to ensure accurate, well-modeled data for business decisions.

The role is 100% on-site at HQ, offering a collaborative, fast-paced environment. Requires 4+ years in Power BI, SQL, Snowflake, and Tableau with data modeling expertise.

Formación

• Bachelor’s degree in CS/IS/Data Analytics or related field.
• 4+ years building Power BI reports with DAX and data modeling.
• 2-3 years with Snowflake or similar cloud data warehouse.
• Experience with Tableau preferred.
• Strong SQL skills with large datasets.
• Experience with data pipelines/ELT tools such as Fivetran or dbt is a plus, but not required.
• Microsoft Certified: Power BI Data Analyst Associate, SnowPro Core, or similar is a plus.
• Experience in consumer products/retail/apparel preferred.

Responsabilidades

• Design, build, and maintain dashboards and data visualizations in Power BI, with Tableau support where needed, to answer business questions and track KPIs
• Write and optimize SQL queries against Snowflake to extract, transform, and validate data for reporting and analysis
• Partner with business stakeholders across functions to gather requirements and translate business questions into data models and visualizations
• Build and maintain semantic layers, data models, and calculated measures (DAX) that support self-service analytics and consistent metric definitions
• Monitor data quality, integrity, and pipeline health across Snowflake data sources, flagging and helping resolve discrepancies
• Support and document data pipelines feeding Snowflake, partnering with the data engineering team on ingestion tools such as Fivetran where applicable
• Maintain data dictionaries, report documentation, and metric definitions so reporting stays consistent and auditable across teams
• Collaborate with the Enterprise Architecture and data platform teams on Snowflake performance tuning, warehouse usage, and cost optimization
• Provide ad hoc data analysis and reporting to support leadership decision-making
• Support migration and consolidation of legacy reports into Power BI and Snowflake
• Stay current on Power BI, Tableau, and Snowflake platform capabilities, including AI-assisted analytics features, and recommend improvements to reporting practices
• Keep all sensitive matters confidential
• Other duties as assigned

Conocimientos

Power BI

Snowflake

Tableau

SQL

Data modeling

DAX

Data visualization

Stakeholder communication

ETL/ELT

Fivetran

dbt

Microsoft Office

Educación

Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or related field

Herramientas

Power BI

Snowflake

Tableau

Fivetran

dbt

Descripción del empleo

New Era Cap, LLC. in Buffalo, NY is seeking an IT Analyst (Data) to turn raw data into trusted insights within a Snowflake-based platform, building dashboards in Power BI and Tableau. You will partner with Data & Analytics and Enterprise Architecture to ensure accurate, well-modeled data for business decisions.

The role is 100% on-site at HQ, offering a collaborative, fast-paced environment. Requires 4+ years in Power BI, SQL, Snowflake, and Tableau with data modeling expertise.