TechFlow, Inc.

Data Analyst

TechFlow, Inc.

full-time

Posted on:

Location Type: Remote

Location: Remote • Virginia • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AWSCloudERPPostgresPythonSQLTableauVBA

About the role

  • 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.
Benefits
  • 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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PostgreSQLSQLbusiness intelligenceTableauPower BIAmazon QuickSightLookerMicrosoft Exceldata analysismachine learning
Soft skills
analytical skillsproblem-solving skillscommunication skills
Certifications
AWS Certified Cloud PractitionerAI PractitionerML Engineer AssociateData Engineer AssociateML Specialty