Data Analyst

TechFlow Inc. is a leading provider of technology solutions and professional services to government agencies, delivering innovative solutions that drive mission success. We are seeking an experienced Data Analyst to join our Platform Services Division in support of a large government contract. This fully remote position focuses on expanding and refining analytics capabilities that measure asset performance, maintenance effectiveness, and operational reliability across a nationwide equipment fleet. The ideal candidate combines advanced technical expertise in PostgreSQL and business intelligence tools with the ability to translate complex operational data into clear, actionable insights that support mission objectives and program performance.

Key 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.

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
• Ability to obtain and maintain Public Trust Clearance. (US Citizenships is Required).

Preferred Qualifications

• Master’s degree in Data Science, Computer Science, Information Systems, or related field (or equivalent experience).
• AWS Certified Cloud Practitioner, AI Practitioner, ML Engineer Associate, Data Engineer Associate, or ML Specialty.
• Experience with the unique challenges and limitations in AWS GovCloud or similar federal data environments.
• Knowledge of data governance, security best practices, and federal compliance frameworks such as NIST 800-53, FedRAMP, and FISMA.
• Experience querying and analyzing semi-structured data stored in nested JSON or JSONB within PostgreSQL, including use of JSON path expressions and operators.
• Experience working with ERP (Enterprise Resource Planning) or CMMS (Computerized Maintenance Management System) data.
• Knowledge of asset lifecycle management principles and maintenance strategies.
• Experience building machine learning models for predictive maintenance or asset performance optimization.
• Familiarity with Python or R for data analysis.
• Experience supporting government contracts.
• Understanding of industrial operations, fleet management, or facilities management.

#techflow

Benefits

Founded in 1995 at the start of the dot-com revolution, TechFlow helped large commercial clients such as Dreamworks, Toshiba, MGM, and others modernize their business systems. Today, with deep operational roots in the bi-coastal innovation hubs of California and Washington DC, TechFlow continues as a leader in applying innovative engineering, technology, integration solutions, and support services to the Federal Government’s most demanding mission and business challenges.

Our culture thrives on out-of-the-box thinking and the unique powerful entrepreneurial expressions of our employee-owners. As a 100% employee-owned company, we have a shared expectation of commitment, accountability, and responsibility driven by a culture that embraces innovation and new ideas. Our goal is not to do what has been done, but to do it better.

TechFlow has four principal lines of business: Platform Services, Digital Services, Base Operations, and Energy and Mobility Solutions. Our company has a strong track record of successful contracts in both areas and encourages cross-collaboration.

TechFlow, Inc is 100% employee-owned. Come make a difference in a job that contributes to your future and helps us build an agile workplace!

• Employee stock ownership plan (ESOP) – Pride in being an employee-owner and annual employer contribution (per plan guidelines)
• 401k plan with Roth option.
• Eligibility for an employer match.
• Immediate vesting
• Paid time off
• Holidays – 11 paid holidays per year
• Comprehensive medical, dental, and vision plans
• Company-paid Life & AD&D insurance plan
• Employee Assistance Program
• Wellness Resources
• Company-paid training and development program
• Voluntary benefits include:
• Life & AD&D Insurance for employee, spouse, and children
• Short-term and long-term disability (per plan guidelines)
• Legal Shield and Identity Theft protection plans
• Pet Insurance