Data Analyst

13 hours ago

⚔️ Virginia – Remote

Although this job is listed in Virginia, this company may be open to hiring remote in other states.

⏰ Full Time

🟡 Mid-level

🟠 Senior

📉 Data Analyst

Apply Now

Receive Emails with Similar Jobs

TechFlow, Inc.

WebsiteLinkedInAll Job Openings

Energy • Transport • Government

TechFlow, Inc. is a 100% employee-owned company specializing in a range of advanced technological fields. The company provides innovative services that include digital services, energy and mobility solutions, and operations and maintenance for both government and commercial sectors. TechFlow prides itself on cutting-edge innovation and a personal touch, ensuring partnerships built on trust and respect. The company is involved in driving change through advanced data analysis, evident in its work with the Transportation Security Administration to improve equipment maintenance at federal airports. With a strong focus on future-proofing investments, TechFlow leverages the latest technologies to lead organizations into a sustainable future, emphasizing net-zero goals and energy-saving technologies.

201 - 500 employees

Founded 1998

⚡ Energy

🚗 Transport

🏛️ Government

📋 Description

• 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