Top Senior Analysis Reporting Jobs in Rochester, NY

Designs and leads scalable, secure, and cost-efficient Snowflake data platforms supporting enterprise analytics, operational reporting, and generative AI applications. Serves as the technical authority for data architecture, modeling, lakehouse design, Snowflake services, dbt transformation frameworks, and Python/Snowpark development. Provides hands-on architectural leadership while influencing executive-level technology strategy.

Designs scalable data models, optimized SQL queries, analytics infrastructure, semantic layers, and data applications. Partners with data science, product, engineering, and business teams to enable dashboards, self-service analytics, reporting, and enterprise data-driven decision-making. The role also establishes analytics engineering best practices, improves developer experience, and supports secure, compliant data warehousing.

Lead business intelligence strategy across product, clinical, commercial, finance, and engineering teams. Build measurement frameworks, semantic layers, reporting solutions, and visualizations that demonstrate business value and support data-informed decisions. Own the data lifecycle from ideation through client-facing delivery, ensure data governance and integrity, and translate complex datasets into actionable insights. Collaborate on scalable data architecture and apply statistical methods, advanced analytics, and emerging AI-driven BI capabilities.

Build and maintain automated ETL/ELT data pipelines, improve data quality and monitoring, optimize Postgres and BigQuery schemas and queries, develop internal tooling, support data governance (HIPAA), participate in on-call rotation, and collaborate across engineering teams to scale data systems.

Designs, builds, and maintains enterprise data pipelines, ETL processes, integrations, cloud data infrastructure, and complex data models. Supports analytics partners, develops data warehouse solutions, tunes SQL and database performance, troubleshoots production issues, and delivers end-to-end data engineering projects. The role collaborates with architects, analysts, developers, and business stakeholders, applies big data technologies, supports agile delivery, and mentors team members.

Lead business intelligence and analytics for executive dashboards, planning, performance reporting, and strategic decision support. Own Power BI and Microsoft Fabric semantic models, data products, governance, lineage, and reporting architecture. Conduct root-cause, trend, scenario, and opportunity analyses, translating ambiguous business questions into actionable recommendations. Partner with finance, strategy, sales, operations, engineering, and analytics teams to improve data quality, scalability, self-service analytics, and AI-ready reporting foundations.

Build and operate a governed Snowflake enterprise data warehouse, including ingestion, orchestration, dbt transformations, infrastructure as code, security controls, reliability checks, and CI/CD. Partner with data owners and BI teams during migration from legacy systems, ensure compliance for sensitive financial data, support reconciliation and incident resolution, and mentor engineers. The role requires hands-on ownership of pipelines and platform components across development and production environments.

Design and implement scalable, secure enterprise data solutions on Databricks and Azure using Delta Lake and Medallion Architecture. Lead and mentor data engineering teams; define integration patterns, governance, security (Unity Catalog, RBAC, masking, row/column-level security), and CI/CD/IaC practices. Ensure data quality, lineage, monitoring, and optimize Spark/Delta workloads for performance and cost while aligning solutions with business needs.

Own the customer experience data foundation by designing dbt models, pipelines, data quality tests, documentation, semantic layers, dashboards, and self-service datasets. Integrate support, KYC, withdrawal, CRM, workforce management, and market resolution data into the cloud warehouse. Identify recurring support issues, communicate findings to stakeholders, and partner with data engineering on infrastructure and governance.

Design and implement end-to-end cloud data solutions, lead or mentor engineering teams, ensure performance, security, and scalability, integrate diverse data sources, write and optimize SQL, program in Java/Python/Scala, produce presentations and detailed solution documentation, and engage directly with clients to deliver production-ready systems.