Data Analyst
New
Source API remote eligibility restrictions: United StatesFull-Time
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PostgreSQLSQLMicrosoft Power BITableauCommunication SkillsAnalytical SkillsMicrosoft ExcelProblem SolvingLooker
Requirements
- Bachelor's degree in Data Science, Computer Science, Information Systems, or related field (or equivalent experience)
- 3+ years of daily experience with PostgreSQL, demonstrating expert-level proficiency in advanced joins, window functions, common table expressions (CTEs), recursive queries, and complex subqueries. The ideal candidate can write and tune high-performance analytical queries, interpret execution plans, and handle large, multi-source datasets with precision and accuracy.
- 3+ years of experience developing analytical content in business intelligence platforms such as Tableau, Power BI, Amazon QuickSight, or Looker, using custom SQL as the foundation for datasets and visualizations. The ideal candidate is comfortable translating complex analytical logic directly into SQL-driven dashboards and reports rather than relying on built-in data modeling tools.
- 2+ years of advanced Microsoft Excel experience, including proficiency with functions such as XLOOKUP, INDEX-MATCH, and nested logical formulas for data validation and analysis (experience with VBA is preferred).
- Experience building reports that measure industrial asset performance and maintenance effectiveness
- Excellent analytical and problem-solving skills
- Strong communication skills with ability to present technical information to non-technical audiences
Responsibilities
- Optimize and expand existing PostgreSQL-based analytics pipelines, ensuring performance, scalability, and data accuracy across large operational datasets.
- Extend existing analytical models and reports to incorporate new data sources, asset types, or mission areas under the government contract.
- Develop interactive dashboards, reports, and data visualizations using business intelligence tools leveraging custom SQL as the foundation for all datasets.
- Analyze industrial asset performance metrics – including operational availability, reliability, and maintenance success rates – to identify trends and improvement opportunities.
- Support the development and continuous improvement of key performance indicators (KPIs) that measure maintenance performance, asset reliability, and lifecycle effectiveness.
- Extract, transform, and analyze data from ERP and CMMS systems.
- Perform data validation and continuous quality assurance to ensure consistency and accuracy across reports and source systems.
- Collaborate with stakeholders to understand reporting requirements and translate business needs into technical solutions.
- Ensure data quality, integrity, and security in compliance with applicable government standards.
- Document analytical processes, methodologies, and SQL logic for traceability and reproducibility.
- Support ad-hoc data analysis requests and provide actionable insights to leadership.
- Contribute to the enhancement of established data workflows and reporting standards to improve scalability, consistency, and usability across contracts.
View Full Description & ApplyYou'll be redirected to the employer's site
