Data Engineer
Share
Job Location:
Chantilly, VA - USA
Monthly Salary:
Not Disclosed
Posted on:
12 hours ago
Vacancies:
1 Vacancy
Job Summary
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
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 organizations data strategy including analytics and reporting needs by designing building andmaintainingreliable data pipelines data models and core data infrastructure. This role is hands-on and execution-focused responsible for enablingaccurate scalable andtimelydata 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 viaFivetran transformation and modeling usingdbt 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 leveragingdbttests and documentation where appropriate
- Analytics Enablement: Provide clean well-structured and documented datasets including analytics-readydbtmodels 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 foundationrequiredto track value creation initiatives and operational improvements
- Data Governance: Implement data quality rules andoperatewithin data governed environments. Support master data management processes and enforce standards naming conventions and metadata management
- Continuous Improvement:Identifyopportunities to improve data architecture automate pipelines and strengthen data reliability over time usingFivetran-managed connectorsdbtbest practices and blob storage as part of the data architecture
Basis Qualifications:
- Bachelors degree in Computer Science Data Engineering Information Systems or a related field
- 3 to 7 years of experience in data engineering analytics engineering or a similar technical role
- Strong SQL skills and experience building andmaintainingrelational data models includingdbt-based transformations
- Experience working with cloud blob or object storage such as Azure Blob Storage Amazon S3 or Google Cloud Storage
- Experience designing andmaintainingdata pipelines across multiple source systems
- Experience implementing andmaintainingenterprise metadata and data catalogs
- Familiarity with BI tools such as Power BI or Tableau from a backend or data modeling perspective
- Experiencevalidating monitoring and troubleshooting data quality issues
- Strong problem-solving skills and attention to detail
- Comfort working in a fast-moving results-oriented environment
Preferred Qualifications
- Experience designing andmaintainingdata pipelines across multiple source systems including ELT tools such asFivetranand transformation frameworks such asdbt
- 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 includingdbtFivetran 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.
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.
Required Experience:
IC
Key Skills
About Company
In an era where the threat of wildfires grows more pronounced, the demand for advanced fire management and safety strategies is at an all-time high. Pavion is at the vanguard, driving forward with innovative technologies not...
