Data Analytics & Reporting Specialist Job at Universal Technologies, Long Island City, NY

emVLbVJacS9RVmhjT0xENVV6VTA0MzF2Nnc9PQ==
  • Universal Technologies
  • Long Island City, NY

Job Description

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.

Job Tags

Similar Jobs

Prairie Ridge Health Inc.

Patient Care Technician (CNA) - 0.9 FTE (Night Shift) Job at Prairie Ridge Health Inc.

 ...pediatric and infant patients. They communicate in a timely manner with the patient, family and healthcare team, and document care per hospital protocol. They may be required to work on other units according to the distribution of staff, patients and individual competency.... 

Outcome School

Volunteer Grant Researcher for Tech Education Access Job at Outcome School

 ...educational organization based in California is seeking a Grant Researcher to help identify funding opportunities. This fully remote...  ..., curious, and enjoy research while being part of a dedicated volunteer team aimed at making an impact. This role offers flexibility,... 

TNT Heating & Air Inc.

Experienced HVAC Installer Job at TNT Heating & Air Inc.

Job Description Job Description Experienced HVAC Installer TNT Heating & Air Inc. is a 34-year-old licensed and insured HVAC company servicing both North Carolina and South Carolina. Our concept is to provide efficient and quality work in all areas of HVAC service...

Global Elite

Managers in Training (Virtual/ Work from home) Job at Global Elite

 ...Managers In Training (Virtual/ Work From Home) With our company growing faster than ever, we are looking for individuals with amazing...  .... What We Offer: Stable, work from home position Paid on a weekly basis Full-time position Incentives including... 

Primoris

Laborer Civil - Nexus - Primoris Energy Services Job at Primoris

 ...Laborer Civil - Nexus - Primoris Energy Services Primoris Energy Services is seeking applications from local Laborers for the Nexus project in Hubbard, TX. The Laborer assists with various labor-related tasks including, but not limited to, flagging, spotting and project...