Data Analyst
Job Description
Use analytics to support PMO decision-making by turning structured and unstructured data into dashboards, models, and executive-ready insights.
Responsibilities
- Analyze structured and unstructured datasets to uncover trends, patterns, and anomalies tied to program and project performance
- Build metrics, KPIs, reports, and executive reporting to support program-level decisions
- Run ad hoc and recurring analyses to address business and program questions
- Collaborate with technology teams and business end users to understand data sources, definitions, and analytical requirements
- Translate business questions into technical and data requirements
- Partner with Program Managers to align analytics with project milestones, risks, budgets, and resource needs
- Work with Program Managers, Program Administrators, and Data Management Specialists to identify, map, and capture data from internal systems and external sources
- Ensure data quality, consistency, and integrity across reporting and analytical deliverables
- Support design and maintenance of PMO data structures, taxonomies, and documentation
- Develop and maintain statistical models for ongoing monitoring and deep-dive analyses
- Validate model outputs and refine methodologies as data availability and business needs change
- Create and maintain dashboards, reports, and presentations using data visualization tools (Power BI, Tableau, or similar)
- Apply data storytelling techniques so complex trends and patterns are actionable for PMO leadership and stakeholders
- Continuously improve visualization standards, templates, and self-service reporting capabilities
- Design and maintain information architecture across SharePoint, Microsoft Teams, network drives, and other collaboration platforms for intuitive access
- Reduce duplication by eliminating redundant files, duplicate dashboards, obsolete documents, and disconnected repositories to support a single source of truth
- Perform periodic audits of digital repositories to identify outdated, duplicate, or conflicting content and coordinate cleanup with content owners
- Support ongoing implementation and improvement of SharePoint, Microsoft Teams, Power BI, and other digital collaboration tools
- Serve as a PMO data resource supporting Program Managers, Program Administrators, and Data Management Specialists for status reporting, forecasting, and risk/issue tracking
- Contribute to PMO process improvements focused on data collection, reporting cadence, and analytical rigor
Requirements
- Bachelor’s degree in Data Analytics, Statistics, Business, Information Systems, or related field (or equivalent experience)
- 2–4+ years of experience in data analysis, business intelligence, or a related analytical role
- Proficiency with SQL and at least one data visualization tool (Power BI, Tableau, Qlik, etc.)
- Experience working with structured data (databases, spreadsheets) and unstructured data (text, logs, documents)
- Strong statistical foundations and basic modeling techniques
- Excellent communication skills, including the ability to present insights to non-technical audiences
- Experience supporting a PMO, program/project management function, or portfolio reporting
- Familiarity with project management tools such as MS Project, Jira, Smartsheet, or ServiceNow
- Experience with Python or R for data manipulation and statistical analysis
- Understanding of data governance, data management principles, or ETL processes
- Exposure to Agile and Waterfall program delivery frameworks
Technologies
- SQL
- Power BI
- Tableau
- Qlik
- Python
- R
- SharePoint
- Microsoft Teams
- MS Project
- Jira
- Smartsheet
- ServiceNow
- Agile/Waterfall
Benefits
- Health, dental, vision, disability, life insurance; FSA and HSA
- Voluntary life/AD&D, voluntary critical illness, accident prevention, and hospital indemnity
- 401K, Profit Sharing, and Employee Stock Purchase Plan
- Astronics Corporation Profit Sharing/401(k) Plan: company contribution of 3% of eligible wages, with an additional annual discretionary adder
- Employee Assistance Program and Wellness Program
- Generous Paid Time Off (PTOS), Volunteer Time Off Program (VTO), Paid Holidays, and Paid Parental Leave
- Tuition Reimbursement Program
Compensation & Additional Details
- Base salary: $85,000 - $115,000, influenced by experience, skill set, education, certifications, market conditions, and business needs
- Eligible for a Quarterly Incentive compensation bonus
- May involve access to items subject to U.S. export-control laws; employment contingent on authorization to access such items under applicable law
Work Environment
- Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions
- Personal Protective Equipment may be required when working in designated areas
- Moderate noise level
Location: Waukegan, IL (onsite)
Minimum Experience: 2 years