Yale University
Yale University

Data Analytics and Reporting Specialist ( F2F interview at Long Island City, NY)

New York, NY, US • Posted 60+ days ago • Updated 1 hour ago
Full Time
On-site
Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

  • System Integration Testing
  • Data Analysis
  • Database
  • Data Warehouse
  • Access Control
  • Environment Management
  • NATURAL
  • Cloud Computing
  • Microsoft Power BI
  • Data Flow
  • DAX
  • Data Visualization
  • Semantics
  • Modeling
  • SQL
  • Oracle
  • PL/SQL
  • Stored Procedures
  • Microsoft SQL Server
  • Oracle Fusion
  • OCI
  • Data Integration
  • Extract
  • Transform
  • Load
  • ELT
  • FOCUS
  • Data Quality
  • Testing
  • Data Modeling
  • Dimensional Modeling
  • Snow Flake Schema
  • Dashboard
  • Data Governance
  • Meta-data Management
  • Documentation
  • KPI
  • Reporting
  • Git
  • Version Control
  • Continuous Integration
  • Continuous Delivery
  • Microsoft Azure
  • DevOps
  • GitLab
  • Analytics
  • Analytical Skill
  • Performance Tuning

Summary

Job Title: Data Analytics and Reporting Specialist

Location: Long Island City, NY

Duration: Long Term

Consultants willing to work on W2

Statement of the Job
  • As a Data Analytics and Reporting Specialist, candidate will translate business reporting needs into a modern, scalable analytics and reporting ecosystem.
  • You will design and deliver reports and dashboards using Power BI and Oracle Analytics Cloud (OAC), supported by well-governed data models, curated datasets, and reliable integration pipelines.
  • Candidate will integrate data from multiple sources, implement transformations, and ensure consistent performance, governance, and observability across the reporting platforms.
  • This role is ideal for a hands-on analytics developer with strong SQL and data warehousing skills, experience building semantic models for self-service analytics, and working knowledge of Azure data services, Power BI and the Oracle/OCI ecosystem.
  • Beyond the technical stack, we are looking for someone who enjoys the detective work of discovery, someone who can sit down with the business, ask the right questions, to understand the actual need.

Responsibilities to include but not limited to:
  • Partner with business owners to clarify reporting needs, define success criteria, and translate requirements into metrics, dashboards, and reports.
  • Serve as a SME for data analytics, ensuring business team goals are addressed efficiently. Regularly monitor user feedback and adjust tools as needed. Create easy-to-follow guides explaining data sources and meaning for all employees.
  • Conduct an analysis of existing application databases and data warehouses to identify relevant data sources for reporting purposes.
  • Design, build, and maintain Power BI and OAC dashboards and reports, including drilldowns, filters, and KPI scorecards.
  • Develop and optimize data models/semantic layers and curated datasets to enable self-service analytics.
  • Build and operate automated, scalable data pipelines and integrations; implement validation checks and documentation.
  • Ensure governance and reliability: metadata consistency, lineage, access controls, and environment management.
  • Monitor and optimize query/report performance; troubleshoot data issues end-to-end (source to dashboard).
  • Enable repeatable deployments by using Git and CI/CD practices (Azure DevOps and/or GitLab) where applicable.
  • Own assigned deliverables end-to-end and communicate status, risks, and timelines.

Qualifications and Skills required
  • 8+ years of experience building analytics/reporting solutions, including data modeling, transformations, and report/dashboard development.
  • Demonstrates strong interpersonal skills in engaging with stakeholders, understanding business objectives, and determining optimal technical solutions to support user needs.
  • Natural ability to bridge the gap between the business and IT; should be comfortable translating complex data concepts for non-technical teammates and vice versa. Proficient at analyzing user requirements and identifying the data needs that may not be explicitly communicated. Experienced in collaborating across departments to ensure final reports effectively enhance operational performance.
  • Hands-on expertise developing interactive dashboards and data visualizations in Power BI and Oracle Analytics Cloud (OAC).
  • Experience building and maintaining semantic layers (Power BI semantic model, OAC semantic model), datasets/dataflows, and reusable KPI definitions; including strong working knowledge of DAX and Power Query (M), gateway/on-prem data connectivity.
  • Experience with Data Visualization, Answers, semantic modeling, and security/configuration in OAC; familiarity with OTBI/FAW is a plus if Oracle Fusion is in scope.
  • Advanced SQL skills with experience across Oracle (including PL/SQL, stored procedures) and SQL Server; familiarity with Oracle Fusion/OCI data sources is a plus.
  • Experience leading discovery sessions to flesh out user needs, ensuring the final solution actually solves the request's problem rather than just displaying data.
  • Experience designing data integration ETL/ELT processes with a focus on data quality, testing/validation, performance, and maintainability.
  • Strong data modeling skills for analytics (dimensional modeling, star/snowflake schemas) and ability to create efficient, reusable models tailored to reporting and dashboards.
  • Knowledge of data governance practices (metadata management, lineage documentation, schema evolution, and KPI definitions) to ensure trusted and auditable reporting.
  • Working knowledge of DevOps practices, including Git-based version control, CI/CD automation (Azure DevOps and/or GitLab), and Infrastructure-as-Code.
  • Demonstrated ability to partner with business and application teams to gather requirements and deliver end-to-end analytics solutions.
  • Strong analytical, troubleshooting, and performance-optimization skills.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTL939169
  • Position Id: f66c2f7830469e96ba5551fd256d12b4
  • Posted 30+ days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Analytics and Reporting Specialist ( Snowflake/SQL)

New York, New York

•

Today

Full-time

Data Analytics and Reporting Specialist ( Snowflake/SQL)

Queens, New York

•

4d ago

Easy Apply

Contract

Depends on Experience

10967 IT Data Scientist Principal I

Newark, New Jersey

•

Today

Full-time

USD 107,600.00 - 170,300.00 per year

Data Analyst III

New York, New York

•

Today

Full-time

USD 114,192.00 - 142,740.00 per year

Search all similar jobs