Top Senior Analysis Reporting Jobs in Buffalo, NY

Own data ingestion, validation, reconciliation, and quality pipelines using Python, advanced SQL, and PostgreSQL. Design schemas, indexes, migrations, automated tests, and CI/CD workflows while handling unreliable third-party feeds. Develop test plans, track defects, establish quality metrics, conduct performance and security testing, and support compliance documentation. Preferred experience includes AWS event-driven architectures, healthcare or payer data, orchestration tools, infrastructure as code, FedRAMP environments, data quality frameworks, and anomaly detection.

Designs, develops, and maintains Databricks-based ETL pipelines, data lake architectures, datasets, and data quality processes supporting reporting, analytics, and AI/ML workloads. Maintains and migrates legacy SSIS and SQL Server systems, optimizes pipeline performance, and supports complex SSRS reporting. Collaborates with business users, analysts, and IT teams to define data requirements, troubleshoot issues, document solutions, and advance AI-assisted engineering practices.

Lead design and delivery of scalable, secure cloud data pipelines and products. Translate requirements into architecture, apply advanced data modeling (Data Vault 2.0/dimensional), embed data quality, observability, security, and DataOps/CI-CD practices, optimize performance and cost, mentor engineers, and enable AI/ML-ready datasets within an agile DevSecOps model.

Leads and scales a global data engineering and analytics team while remaining hands-on with architecture, pipelines, data quality, dimensional modeling, dashboards, reporting, and customer-facing deliverables. Owns the analytical data platform supporting clinical, operational, product, financial, and customer data. Partners with cross-functional stakeholders, investigates complex data issues, improves platform reliability and security, and mentors engineers.

Designs, develops, and maintains Databricks ETL pipelines, data lake architectures, datasets, and data integrations supporting reporting, analytics, and AI/ML workloads. Troubleshoots and optimizes Databricks and SSIS processes, maintains legacy systems, implements data quality controls, and supports data warehousing. Maintains SSRS reports and collaborates with business users, analysts, and IT teams to deliver reporting solutions. Documents work, communicates technical information, and contributes to AI-assisted development practices.

Build scalable data pipelines, ELT processes, infrastructure, and dimensional data models supporting internal analytics and customer-facing data products. Implement data quality monitoring, auditing, alerting, warehouse optimization, and governed semantic layers for AI and LLM-enabled analytics. Partner with technical and business stakeholders, improve data processes using AI, and deliver reliable metrics from diverse data sources.

Leads complex, cross-functional business intelligence initiatives from strategy and scoping through delivery. Partners with senior leaders across Sales, Marketing, Finance, and Operations to build scalable data products and actionable insights. Establishes standards for metrics, data modeling, governance, quality, and storytelling; designs data infrastructure using modern tools such as dbt. Drives data literacy, mentors analysts, contributes to analytics roadmaps, and ensures data assets are trusted, discoverable, secure, and fit for executive decision-making.

Develop enterprise Power BI solutions from discovery through adoption. Responsibilities include semantic modeling, advanced DAX and Power Query development, dashboard UX/UI design, governance, performance optimization, stakeholder workshops, client presentations, usability testing, adoption tracking, proposal support, and mentoring junior team members.

Lead the architecture and implementation of complex cloud-based data solutions for customers. Define strategic data roadmaps, support pre-sales engagements as a data engineering subject matter expert, interview and mentor architects and engineers, and oversee data standards and operating procedures. The role requires extensive AWS data architecture experience across traditional and modern data platforms, including big data, machine learning, generative AI, DataOps, infrastructure as code, CI/CD, and Python automation.

Design, build, and optimize enterprise ETL/ELT pipelines, cloud data lakes, lakehouse solutions, data models, and semantic layers across AWS and Azure. Ensure data quality, security, performance, reliability, and governance while supporting analytics, reporting, and AI initiatives. Collaborate with product, engineering, IT, and business stakeholders to translate requirements into scalable data solutions, monitor pipeline health, troubleshoot issues, and improve data architecture and practices.