NYC SCA Data Analytics and Reporting Specialist

Opportunity Details

Full Time NYC SCA Data Analytics and Reporting Specialist


New York, NY


Outcomes. Delivered.

Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide.

For example, our technology:

• Facilitates access to nutritious food for children of mothers participating in the WIC program
• Supports first responders in reducing opioid overdoses within their communities
• Empowers colleges and universities to identify and thwart financial aid fraud
• Equips teachers with valuable insights to identify students requiring additional support
• Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers

With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy.


We're more than a technology company -- we're an outcomes company.

We encourage our employees to think differently, ask tough questions, and relentlessly pursue what's best for our customers and the residents they serve.

We believe that the value of technology is defined by its human impact. If you agree, you've come to the right place.


Voyatek is seeking applicants to occupy the position of Data Analytics and Reporting Specialist within our team NYC School Construction Authority located in New York, NY.


Key Responsibilities:

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.

• Partner with business owners to clarify reporting needs, defi ne 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:

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 fi nal 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 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.

Preferred Qualifications:


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 with Data Visualization, Answers, semantic modeling, and security/configuration in OAC; familiarity with OTBI/FAW is a plus if Oracle Fusion is in scope.


The wage range for this role reflects the wide array of factors considered in compensation decisions. These factors include, but are not limited to, skill sets, experience, training, licensure certifications, and geographic location. Compensation decisions are based on the unique facts and circumstances of each case. A reasonable estimate of the hourly range is $ 60 .00 - $ 65 .00.

At Voyatek, we believe in supporting our employees with a comprehensive benefits package designed to enhance their well-being and professional growth. Please note that eligibility for certain benefits may vary based on your role and employment status.

• Flexible Work Schedules
• Health, Dental, and Vision Insurance
• Medical, Limited, & Dependent Flexible Spending Accounts (FSA)
• Health Savings Account (HSA) with Employer Contributions
• Company-Paid and Voluntary Life Insurance
• Long and Short-Term Disability Insurance
• Accident, Critical Illness, & Hospital Indemnity Insurance
• 401(k) Retirement Plan with Company Match and Immediate Vesting
• Wellhub Fitness and Wellness Platform
• Pet Insurance
• Training Opportunities
• Employee Referral Bonus Program

We are committed to fostering a workplace that supports both your personal and professional aspirations.


As part of our commitment to maintaining a compliant workplace, all final candidates will undergo and must successfully pass a pre-employment (post offer) background check. The background check may include, but is not limited to, verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. For certain positions, additional client-specific background screenings may be required at the time of hire or in the future, in accordance with client requirements.


If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions!

Voyatek provides equal employment opportunities to all employees and applicants for employment. Voyatek will make employment decisions without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Employment decisions include all terms and conditions of employment, including recruitment and hiring, job assignment/ placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.