IT Analyst
New Era Cap, LLCNew Era Cap, LLC. is an international lifestyle brand headquartered in Buffalo, NY with an authentic sports heritage that dates back over 100 years. Best known for being the official on-field cap for MLB, official sideline cap for NFL, and official on-court cap for NBA, New Era Cap is the brand of choice not only for its headwear collection, but also for its accessories and apparel lines for men, women and youth. The brand is worn as a symbol of self-expression by athletes, artists and some of the most interesting people around the globe. New Era Cap encourages people to truly express their personal style and individuality through its products. Since 1920, this family-owned business has hired employees who are masters of their craft. We are innovators, architects of culture, experts, and forward thinkers. We demand excellence because we pride ourselves on the quality of our products and the authenticity of our brand. Interested in working with us? Check out this exciting opportunity at New Era Cap’s Headquarters (HQ) building located in downtown Buffalo, NY. This role is 100% on-site, encouraging employees to collaborate and connect in person five days a week. HQ offers an inviting atmosphere, complete with an on-site café, fitness center, and Flagship store. Apply to join New Era's team! New Era is continuing its digital transformation – from customer-facing initiatives like tier-one commerce and 3PL transformations, to internal changes in how we deliver programs through Agile frameworks and innovation. As our team evolves, we recognize the need to add skillsets that support this shift. The IT Analyst (Data) role plays a key part in supporting New Era’s data and analytics capabilities by turning raw data into trusted, actionable insight. Based at Headquarters, the Data Analyst works primarily within New Era’s Snowflake-based data platform, building and maintaining dashboards and reports in Power BI – with Tableau in the mix – that give business and IT stakeholders the visibility they need to make informed decisions. The role partners closely with the Data & Analytics and Enterprise Architecture teams to ensure data is accurate, well-modeled, and consistently defined across the organization. The Information Technology team at New Era Cap enables the organization’s operations by delivering reliable, secure, and innovative technology solutions. They manage enterprise systems, infrastructure, and digital tools to support day-to-day business activities and enhance productivity across teams. The team partners cross-functionally to implement technology initiatives, provide technical support, and drive continuous improvement in system performance, data security, and user experience. Responsibilities Design, build, and maintain interactive dashboards, reports, 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-…