TechFlow

TechFlow

TechFlow is a 100% employee-owned government contractor in San Diego, offering tailored IT solutions and services to government agencies, specializing in program management, software development, and base operations with a focus on innovation and excee...

IT Services
51-250
Founded 1995

Description

  • Optimize and expand PostgreSQL-based analytics pipelines for performance, scalability, and data accuracy.
  • Extend analytical models and reports to incorporate new data sources, asset types, and mission areas.
  • Build interactive dashboards, reports, and visualizations using business intelligence tools and custom SQL datasets.
  • Analyze asset performance metrics such as availability, reliability, and maintenance success rates to identify trends and improvement opportunities.
  • Develop and continuously improve KPIs that measure maintenance performance, asset reliability, and lifecycle effectiveness.
  • Extract, transform, and analyze data from ERP and CMMS systems.
  • Perform data validation and quality assurance across reports and source systems.
  • Collaborate with stakeholders to translate reporting requirements into technical solutions.
  • Document analytical processes, methodologies, and SQL logic for traceability and reproducibility.
  • Support ad hoc analysis requests and provide actionable insights to leadership.
  • Improve existing data workflows and reporting standards to increase scalability, consistency, and usability.

Requirements

  • Bachelor's degree in Data Science, Computer Science, Information Systems, or a related field, or equivalent experience.
  • 3+ years of daily experience with PostgreSQL, including advanced joins, window functions, CTEs, recursive queries, and complex subqueries.
  • Experience writing and tuning high-performance analytical queries and interpreting execution plans.
  • 3+ years of experience developing analytical content in BI platforms such as Tableau, Power BI, Amazon QuickSight, or Looker.
  • Experience using custom SQL as the foundation for datasets and visualizations in dashboards and reports.
  • 2+ years of advanced Microsoft Excel experience, including XLOOKUP, INDEX-MATCH, and nested logical formulas.
  • VBA experience is preferred.
  • Experience building reports that measure industrial asset performance and maintenance effectiveness.
  • Strong analytical and problem-solving skills.
  • Strong communication skills with the ability to present technical information to non-technical audiences.
  • Ability to obtain and maintain Public Trust Clearance; U.S. citizenship is required.
  • Master’s degree in a related field is preferred.
  • AWS certifications such as Cloud Practitioner, AI Practitioner, ML Engineer Associate, Data Engineer Associate, or ML Specialty are preferred.
  • Experience with AWS GovCloud or similar federal data environments is preferred.
  • Knowledge of data governance, security best practices, and federal compliance frameworks such as NIST 800-53, FedRAMP, and FISMA is preferred.
  • Experience querying semi-structured JSON or JSONB data in PostgreSQL is preferred.
  • Experience working with ERP or CMMS data is preferred.
  • Knowledge of asset lifecycle management principles and maintenance strategies is preferred.
  • Experience building machine learning models for predictive maintenance or asset performance optimization is preferred.
  • Familiarity with Python or R for data analysis is preferred.
  • Experience supporting government contracts is preferred.
  • Understanding of industrial operations, fleet management, or facilities management is preferred.

Benefits

  • Employee stock ownership plan (ESOP) with annual employer contribution, per plan guidelines.
  • 401(k) plan with Roth option, employer match eligibility, and immediate vesting.
  • 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 including short-term and long-term disability, legal and identity theft protection, and pet insurance.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Director, B2B Data Strategy & Revenue Analytics

Wpromote 251-1K Media

Wpromote is hiring a remote Director of B2B Data Strategy & Revenue Analytics to own end-to-end marketing measurement across tracking, marketing operations, CRM, and analytics, ensuring campaign activity is accurately tied to pipeline and revenue.

CRM Google Analytics Google Tag Manager HubSpot Salesforce SQL
2 hours, 50 minutes ago

Especialista de Negócios - Crédito e Cartões | Remoto

Harford County Public Library 51-250 Diversified Consumer Services

Stone is hiring a remote Business Specialist focused on credit and cards to monitor product performance, analyze customer behavior across the funnel, and help prioritize initiatives that improve credit product results.

CRM SQL
3 hours, 53 minutes ago

Construction/ Architect Analyst - AI Evaluation Team

Real Dev 1-10 Internet Software & Services

REAL is seeking a Construction/Architect Analyst on its AI Evaluation Team to turn fragmented real estate and construction documents into structured, high-quality data for its AI execution platform.

4 hours, 5 minutes ago

Data Analyst

ADF Medical 1-10 Professional Services

ADF Medical Services is hiring a fully remote Data Analyst to support its Analytics & Business Intelligence team by turning patient and operational data into actionable business insights.

6 hours, 2 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers