Data Engineer

Pavion Connects and Protects by providing innovative fire, security, and communication integration solutions to customers across 70+ U.S. locations and 22 countries. We bring industry-leading expertise to clients in enterprise, healthcare, education, government, data center, and retail industries.

As a global leader, Pavion specializes in the design, installation, service, and maintenance of cutting-edge fire alarm systems, critical communications, video surveillance, access control, and advanced AV technologies. Our mission is to bring clarity and transformation to safety, security, and communication through integral technology and radical service.

With a commitment to safety, reliability, and operational excellence, Pavion ensures scalable, future-ready solutions tailored to meet and exceed our clients' needs. Learn more at www.pavion.com

Pavion and our family of companies are seeking a talented and motivated Data Engineer to join our shared services. The Data Engineer will support the organization's data strategy, including analytics and reporting needs by designing, building, and maintaining reliable data pipelines, data models, and core data infrastructure. This role is hands-on and execution-focused, responsible for enabling accurate, scalable, and timely data across operations, finance, sales, and M&A activities. The ideal candidate is technically strong, detail-oriented, and comfortable working with imperfect source data in a fast-paced, private equity environment.

Primary Responsibilities:

• Data Pipelines and Modeling: 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.
• Data Preparation and Quality: 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
• Analytics Enablement: Provide clean, well-structured, and documented datasets, including analytics-ready dbt models, that support BI tools such as Power BI.
• Data Enablement: Partner with analytics and business teams to ensure data is accessible, understandable, and fit for reporting and analysis
• Cross-Functional Collaboration: Work closely with analytics, IT, and business stakeholders to understand data requirements and support reporting, analytics, and M&A needs
• M&A Support: 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
• Performance Monitoring: Support the data foundation required to track value creation initiatives and operational improvements
• Data Governance: Implement data quality rules and operate within data governed environments. Support master data management processes and enforce standards, naming conventions and metadata management
• Continuous Improvement: 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

Basis Qualifications:

• 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

Preferred Qualifications

• Experience designing and maintaining data pipelines across multiple source systems, including ELT tools such as Fivetran and transformation frameworks such as dbt
• Familiarity with field service, operations, or financial systems
• Exposure to cloud data platforms or modern data stacks
• Experience supporting M&A data integration or post-acquisition reporting
• Knowledge of Python or similar tools for data processing and automation
• Exposure to cloud data platforms or modern data stacks, including dbt, Fivetran, and blob-based data lake patterns
• Experience managing and integrating no-SQL databases, including columnar and document stores
• Experience with data catalog and metadata management tools such as Collibra, Alation, Amazon Glue, etc.

Salary: $130k-160k depending on experience.

Disclaimer: This job description should not be construed to imply that these requirements are the exclusive standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as may be required. The employer has the right to revise this job description at any time. The job description is not be construed as a contract for employment.

Pavion is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.