Apply Now

Data Analytics & Reporting Specialist

New York, NY, US • Posted 30+ days ago • Updated 13 days ago

Full Time

On-site

Depends on Experience

UNIVERSAL Technologies

Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

Access Control
Analytical Skill
Analytics
Cloud Computing
Communication
Computer Science
PL/SQL

Summary

UNIVERSAL Technologies is seeking a Data Analytics & Reporting Specialist with experience in Power BI and Oracle Analytics Cloud (OAC) for an onsite role in Long Island City, NY to design and deliver scalable analytics solutions that translate business reporting needs into actionable insights. Active LinkedIn preferred. This role focuses on building modern reporting ecosystems using Power BI and Oracle Analytics Cloud, supported by robust data models, integration pipelines, and governance frameworks.

***Hybrid work may be considered after 90 days.

***Must be able to work for UNIVERSAL Technologies directly.

WHO WE ARE
UNIVERSAL Technologies is a certified Women-Owned Business Enterprise (M/WBE) specializing in IT consulting and professional services. We provide experienced technology professionals to government agencies and private-sector clients, delivering cost-effective solutions that drive innovation and operational excellence.

WHAT WE OFFER
• Competitive pay
• Health/Dental Insurance
• Group Life Insurance
• 401K
• HSA/FSA
• Pre-Tax Transportation Program
• Generous Paid Time Off/Holiday Policy

MANDATORY SKILLS/EXPERIENCE
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field (or equivalent experience)
• Minimum eight (8) years of experience building analytics and reporting solutions, including data modeling, transformations, and dashboard/report development
• Hands-on expertise developing interactive dashboards and visualizations using Power BI and Oracle Analytics Cloud (OAC)
• Strong experience building and maintaining semantic layers (Power BI and OAC), datasets, dataflows, and reusable KPI definitions
• Advanced proficiency in DAX and Power Query (M), including experience with gateway/on-premises data connectivity
• Strong SQL skills with experience in Oracle (including PL/SQL, stored procedures) and SQL Server
• Experience designing and implementing ETL/ELT data integration processes with a focus on data quality, validation, and performance
• Strong data modeling expertise, including dimensional modeling, star and snowflake schemas, and development of scalable reporting models
• Experience building and maintaining automated, scalable data pipelines and integrations
• Knowledge of data governance practices including metadata management, lineage documentation, schema evolution, and KPI standardization
• Experience with Oracle Analytics Cloud features including data visualization, semantic modeling, and security configuration; familiarity with OTBI/FAW is a plus
• Working knowledge of Azure data services and Oracle/OCI ecosystem
• Experience with DevOps practices including Git-based version control and CI/CD pipelines (Azure DevOps and/or GitLab)
• Proven ability to lead discovery sessions, gather requirements, and translate business needs into technical solutions
• Strong interpersonal and communication skills with the ability to bridge business and technical teams
• Demonstrated analytical, troubleshooting, and performance optimization skills

SCOPE OF SERVICES
• Partner with business stakeholders to define reporting needs, success criteria, and translate requirements into dashboards, reports, and metrics
• Serve as a subject matter expert for data analytics, ensuring solutions align with business objectives and user needs
• Analyze existing databases and data warehouses to identify and integrate relevant data sources for reporting
• Design, develop, and maintain Power BI and Oracle Analytics Cloud dashboards, including drilldowns, filters, and KPI scorecards
• Develop and optimize semantic models and curated datasets to enable self-service analytics
• Build and manage automated, scalable data pipelines and integrations with appropriate validation and documentation
• Ensure governance and reliability across reporting platforms, including metadata consistency, lineage tracking, and access controls
• Monitor and optimize query and report performance; troubleshoot data issues across the full data lifecycle
• Implement repeatable deployment processes using Git and CI/CD practices
• Create documentation and user guides to support data understanding and adoption across business teams
• Own deliverables end-to-end, including communication of status, risks, and timelines

UNIVERSAL Technologies is an equal opportunity employer.

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: 10205691a
Position Id: 3958
Posted 30+ days ago

Company Info

About UNIVERSAL Technologies

“Our Mission is to become an extension of our client’s IT organization”

— JOAO RAQUEL, CEO

UNIVERSAL Technologies, LLC, focuses on supporting client engagements by seamlessly integrating our staff with the client’s existing Information Technology environment. Headquartered in New York City with additional offices in Albany, New York, we provide decades of experience to deliver measurable results within State and local government agencies and other large organizations.

What We Do

UNIVERSAL Technologies provides projects, personnel and solutions with a focus on ensuring that our clients’ infrastructure and computing environments are well designed, well managed, stable, and secure. We offer a wide range of services and products, from individual engagements to enterprise-wide solutions.

UNIVERSAL’s consulting practice and resources cross the technology boundaries of product specializations and its application requirements. Practice areas include but are not limited to:

· IT SUPPORT FOR HETEROGENEOUS ENTERPRISE

· SOFTWARE DEVELOPMENT

· PROJECT MANAGEMENT

· PROGRAM MANAGEMENT

· BUSINESS ANALYSIS

· SYSTEM ADMINISTRATION

· SYSTEMS ARCHITECTURE

Our Systems Integration management experience and core competencies span the life cycle of enterprise implementation from requirements analysis through design, deployment, and operation in a wide range of disciplines:

•DATA CENTER ARCHITECTURE

•VIRTUAL CLOUD ARCHITECTURE AND DEPLOYMENT

•VIRTUALIZATION ARCHITECTURE, DESIGN AND DEPLOYMENT

•ENTERPRISE SYSTEMS AND NETWORK INTEGRATION

•ENTERPRISE DISASTER RECOVERY PLANNING, DESIGN AND DEPLOYMENT

•STORAGE MANAGEMENT

•ENTERPRISE SECURITY ARCHITECTURE, DESIGN AND DEPLOYMENT

•ENTERPRISE OPERATIONS MANAGEMENT

Our Clients

UNIVERSAL Technologies has a history of providing IT services to some of the leading New York State and New York City government agencies.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Oracle Cloud Administrator

New York, New York

•

13d ago

UNIVERSAL Technologies is seeking an Oracle Cloud Infrastructure Certified Architect and/or OCI Database Management Specialist for an onsite position in Long Island City, NY. Active LinkedIn preferred. May change to hybrid after 90 days. The selected consultant will serve as the primary technical authority responsible for administering and optimizing Oracle Cloud Infrastructure (OCI) environments, including Oracle Fusion ERP and Oracle Autonomous Databases (ATP/ADW). This role ensures high avail

Easy Apply

Full-time

Depends on Experience

Technical/Business Data Analyst

Hybrid in Albany, New York

•

3d ago

UNIVERSAL Technologies is seeking a Technical/Business Data Analyst for a hybrid role in Albany, NY supporting business process analysis, operational documentation, reporting, and data-driven decision-making initiatives. Local candidates with an active LinkedIn preferred. This position requires strong experience in business analysis, SQL development, data analysis, stakeholder engagement, and documentation within enterprise environments. Onsite 2 days/week. 1 year contract approximately. WHO WE

Easy Apply

Contract

Depends on Experience

Business/Data Analyst

Hybrid in Albany, New York

•

3d ago

UNIVERSAL Technologies is seeking a Business / Data Analyst for a hybrid role in Albany, NY to support enterprise reporting, data analysis, and business intelligence initiatives within a client-facing environment. Local candidates with an active LinkedIn preferred. The ideal candidate will possess strong SQL development, analytical, reporting, and documentation skills with the ability to translate complex data into meaningful business insights and actionable recommendations. Onsite 2 days/week.

Easy Apply

Contract

Depends on Experience

Business Analyst

Hybrid in Albany, New York

•

3d ago

UNIVERSAL Technologies is seeking a Business Analyst for a hybrid role in Albany, NY to support business process analysis, operational documentation, workflow improvement, and recurring reporting initiatives within a client-facing enterprise environment. Local candidates with an active LinkedIn preferred. The ideal candidate will possess strong analytical, documentation, stakeholder engagement, and reporting coordination skills with experience supporting operational and business process improvem

Easy Apply

Contract

Depends on Experience

Search all similar jobs