Junior Business Intelligence & Data Analyst (Government Operations)

Unity Technologies Corporation; Philadelphia (Philadelphia County); On-site; USD 60,000 - 90,000; Full time

Job summary

UnityTec in Philadelphia, PA seeks a Junior BI & Data Analyst (Government Operations) to transform data from multiple sources into dashboards, reports, and actionable insights. Under a senior analyst, you will use Excel, Power BI or Tableau, and basic SQL to identify trends and monitor KPIs.

This onsite role supports government operations and DHS/FPS priorities, with responsibilities to communicate findings to leadership and contribute to continuous improvement.

Qualifications

• At least 1 year of experience in BI, data analysis, or operations analysis.
• Advanced Excel skills including PivotTables and data cleaning.
• Experience creating reports/dashboards with Power BI or Tableau.
• Foundational SQL for querying structured data.

Responsibilities

• Data analysis and insight development from multiple reports.
• Dashboarding and data visualization with BI tools.
• Reporting and performance measurement with periodic analyses.
• Data management and quality assurance.
• Support business process and operational analysis.
• Communicate findings to stakeholders with clear visuals.

Skills

Excel advanced

Data analysis

Dashboard creation

Education

Bachelor's degree (preferred)

Tools

Power BI

Tableau

SQL

Job description

Junior Business Intelligence & Data Analyst (Government Operations)

• Philadelphia, PA
• Administrative

Company Overview

UnityTec is an SBA-certified Woman-Owned Small Business (WOSB) delivering high-impact professional and technical services to government agencies. With deep expertise in Industrial and Enterprise Systems Modernization, FIAR (Financial Improvement and Audit Readiness), Industrial Facility Transformation, Program and Project Management, Enterprise Support and Consulting, and Advanced Analytics, we empower organizations to modernize operations and advance mission priorities. Our disciplined approach—grounded in dedicated talent, proactive planning, rigorous quality assurance, agile methodologies, cost-effective delivery, and uncompromising ethics—positions UnityTec as a trusted partner committed to achieving measurable, enduring results for our clients.

Job Overview

We are seeking a Junior Business Intelligence & Data Analyst (Government Operations) to join our team. You will support government operational and acquisition-management teams by transforming data from multiple sources into dashboards, reports, and actionable performance insights. Working under senior analyst oversight, you will use Excel, Power BI or Tableau, and basic SQL to identify trends, monitor KPIs, and support continuous process improvement. This is an onsite position available in Philadelphia, PA.

Responsibilities include, but are not limited to:

• Data Analysis and Insight Development: Collect, clean, validate, and analyze data from multiple reports and structured data sources. Identify trends, anomalies, risks, and key performance indicators that inform operational and management decision-making.
• Dashboarding and Data Visualization: Develop and maintain clear, leadership-ready dashboards, visualizations, scorecards, and recurring reports using Power BI, Tableau, Excel, or comparable business-intelligence tools. Translate complex data into concise, actionable visual narratives.
• Reporting and Performance Measurement: Support the preparation of periodic performance reports and ad hoc analyses. Track operational metrics, assess performance against established goals, and provide data-based observations to support division priorities.
• Data Management and Quality Assurance: Assist with data cleaning, reconciliation, formatting, and quality checks to improve the reliability, consistency, and usability of reporting data. Maintain organized source files, report documentation, and analytical work products.
• Business Process and Operational Analysis: Support the analysis of business processes, operational workflows, and reporting practices. Help identify inefficiencies, bottlenecks, and opportunities to improve data collection, reporting timeliness, and mission performance.
• Continuous Improvement Support: Provide analytical support for continuous-improvement initiatives by developing baseline measures, tracking results, and communicating data-driven recommendations under senior staff direction.
• Stakeholder Communication: Communicate analytical findings effectively in writing and verbally to technical and non-technical stakeholders. Prepare charts, summaries, and briefing materials that enable leadership to understand performance and make informed decisions.
• Government and DHS/FPS Mission Support: Support activities in accordance with applicable government, DHS, and Federal Protective Service policies, directives, regulations, and acquisition-management practices. Apply relevant government-contractor or public-sector experience to support mission requirements.
• Junior-Level Analytical Support: Perform assigned functional duties under the guidance of senior analysts and program personnel. Build technical proficiency, contribute to team deliverables, and provide reliable analytical support across concurrent priorities.

Required Qualifications:

• A minimum of one (1) year of relevant professional experience in business intelligence, data analysis, performance reporting, operations analysis, or a related field.
• Advanced working proficiency with Microsoft Excel, including formulas, PivotTables, charting, and data-cleaning techniques.
• Experience with creating reports and dashboards with Power BI, Tableau, or similar visualization platforms.
• Foundational SQL capability for querying and extracting structured data.

Preferred Qualifications:

• Familiarity with DHS, Federal Protective Service (FPS), government acquisition management, and federal policies or directives, is highly desired.
• A bachelor’s degree in a related field of study.
• Any related certifications.

Clearance Requirements:

• Must be a U.S. citizen.

UnityTec is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.