Data Analyst

TechFlow, Inc.

Remote Workable locations: Arlington, Virginia, United StatesFull-TimeMiddle

Salary not disclosed

Apply NowOpens the employer's application page

Job Details

Experience: 3+ years of daily experience with PostgreSQL 3+ years of experience developing analytical content in business intelligence platforms 2+ years of advanced Microsoft Excel experience
Required Skills: PostgreSQLPythonSQLData AnalysisMicrosoft Power BIVBATableauMicrosoft ExcelJSONLookerR

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

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