Data Analytics & Reporting Specialist

Universal Technologies; United States; Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

HealthDental Insurance

Group Life Insurance

401K

HSAFSA

Pre Tax Transportation Program

Generous Paid Time Off/Holiday Policy

Job summary

UNIVERSAL Technologies in Long Island City, NY, seeks a Data Analytics & Reporting Specialist with hands-on Power BI and Oracle Analytics Cloud (OAC) experience to design scalable analytics solutions that translate business needs into actionable insights.

You will build modern reporting ecosystems, create robust data models and pipelines, govern data assets, and deliver interactive dashboards while collaborating with business partners to enable data-driven decisions.

Qualifications

• Bachelor's degree or equivalent experience in a relevant field.
• 8+ years building analytics and reporting solutions with data modeling and dashboards.
• Hands-on dashboards with Power BI and Oracle Analytics Cloud (OAC).
• Strong SQL skills in Oracle and SQL Server; PLSQL experience a plus.
• ETL/ELT design, data quality, governance, and scalable reporting models.

Responsibilities

• Define reporting needs with stakeholders and translate to dashboards and metrics.
• Serve as SME for data analytics and governance across platforms.
• Analyze databases and data warehouses to identify sources for reporting.
• Design and maintain Power BI and OAC dashboards with drilldowns and KPI scorecards.
• Develop semantic models and curated datasets for self-service analytics.
• Build automated scalable data pipelines with validation and documentation.
• Ensure metadata, lineage, access controls, and governance across platforms.
• Monitor query performance and troubleshoot data issues end-to-end.
• Implement repeatable deployment via Git and CI/CD practices.
• Create user guides to support data understanding and adoption.

Skills

Power BI

Oracle Analytics Cloud (OAC)

Data modeling

DAX

SQL

ETL/ELT

Data governance

Dashboards

Stakeholder mgmt

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics or related field

Tools

SQL Server

Oracle DB

ETL Tools

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

WHAT WE ARE

UNIVERSAL Technologies is a certified Women Owned Business Enterprise MWBE 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
• HealthDental Insurance
• Group Life Insurance
• 401K
• HSAFSA
• Pre Tax Transportation Program
• Generous Paid Time OffHoliday Policy

MANDATORY SKILLS EXPERIENCE

• Bachelors 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 dashboardreport 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 gatewayon premises data connectivity
• Strong SQL skills with experience in Oracle including PLSQL stored procedures and SQL Server
• Experience designing and implementing ETLELT 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 OTBIFAW is a plus
• Working knowledge of Azure data services and OracleOCI ecosystem
• Experience with DevOps practices including Git based version control and CICD pipelines Azure DevOps andor 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 CICD 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