Data Engineer

🕒 May 6

⚔️ Virginia – Remote

⚔️ Virginia – Remote

💵 $130k - $160k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Pavion

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🔐 Security

🏢 Enterprise

🤝 B2B

💰 Private equity on 2016-12

Security • Enterprise • B2B

Pavion is a provider of integrated fire protection, security, and audiovisual systems for commercial and institutional clients. The company offers end-to-end services including consulting and design, installation and technology integration, proactive monitoring, IT managed services, maintenance/subscription plans, and AI-enabled video surveillance. Pavion serves enterprise and B2B customers across sectors such as retail, data centers and technology, education, healthcare and pharmaceutical, government and defense, and property management, emphasizing compliance, reliability, and long-term service partnerships.

📋 Description

• Design, build, and maintain scalable data pipelines (ETL/ELT) and data models that support operational KPIs, financial performance, customer metrics, and growth initiatives, including ingestion via Fivetran, transformation and modeling using dbt, and processing structured and unstructured data from BLOG, RDBMS, and no-SQL data sources. • Extract, transform, and load data from ERP, CRM, field service systems, and blob or database storage, implementing data quality checks to ensure accuracy, completeness, and consistency, leveraging dbt tests and documentation where appropriate • Provide clean, well-structured, and documented datasets, including analytics-ready dbt models, that support BI tools such as Power BI. • Partner with analytics and business teams to ensure data is accessible, understandable, and fit for reporting and analysis • Work closely with analytics, IT, and business stakeholders to understand data requirements and support reporting, analytics, and M&A needs • Assist with data integration for acquisitions, including onboarding new source systems, ingesting historical or ad hoc data delivered via blob storage or flat files, and supporting post-acquisition reporting • Support the data foundation required to track value creation initiatives and operational improvements • Implement data quality rules and operate within data governed environments. Support master data management processes and enforce standards, naming conventions and metadata management • Identify opportunities to improve data architecture, automate pipelines, and strengthen data reliability over time, using Fivetran-managed connectors, dbt best practices, and blob storage as part of the data architecture

🎯 Requirements

• Bachelor’s degree in computer science, Data Engineering, Information Systems, or a related field • 5+ years of experience in data engineering, analytics engineering, or a similar technical role • Strong SQL skills and experience building and maintaining relational data models, including dbt-based transformations • Experience working with cloud blob or object storage such as Azure Blob Storage, Amazon S3, or Google Cloud Storage • Experience designing and maintaining data pipelines across multiple source systems • Experience implementing and maintaining enterprise metadata and data catalogs • Familiarity with BI tools such as Power BI or Tableau from a backend or data modeling perspective • Experience validating, monitoring, and troubleshooting data quality issues • Strong problem-solving skills and attention to detail • Comfort working in a fast-moving, results-oriented environment • Experience with Athena, Lambda, Power BI, Lake Formation, Glue Data Catalog and Glue Data Quality