In This Role
We are seeking a Data Engineer / Analytics Engineer to support the collection, integration, and analysis of operational technology (OT) and infrastructure data across large-scale, mission-critical facilities. This role will focus on extracting data from building management, automation, monitoring, and other vendor platforms, transforming and normalizing data into standardized schemas, and integrating it into enterprise analytics and telemetry platforms.
Responsibilities
- Design, develop, and maintain data architectures and schemas to support data ingestion from multiple operational and infrastructure systems.
- Develop and maintain automated ETL/ELT processes for extracting, transforming, and loading data from diverse data sources.
- Build and support API integrations, database queries, scripting solutions, and file-parsing methods to acquire device inventory and configuration-state data.
- Normalize and standardize data across various platforms and vendor applications into a common data model.
- Integrate data into enterprise telemetry, monitoring, reporting, and analytics platforms.
- Design and optimize data pipelines to support compliance monitoring, change tracking, and operational analytics.
- Implement and maintain moderately complex logical and physical database designs.
- Create and maintain dashboards, reports, and data visualizations using real-world operational datasets.
- Troubleshoot and resolve production data collection, integration, and quality issues.
- Develop technical documentation, data schemas, interface specifications, and telemetry requirements.
- Collaborate with internal stakeholders, subject matter experts, and external vendors to gather requirements and support project delivery.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field.
- 3–5 years of experience in Data Engineering, Analytics Engineering, Business Intelligence, or a related field.
- 3+ years of experience with Microsoft analytics and data platform technologies.
- Strong experience with Kusto Query Language (KQL), Microsoft SQL Server / SQL development, ETL/ELT processes, and Power Apps or Power Automate.
- Experience with data extraction, transformation, and integration from multiple source systems.
- Strong understanding of relational database concepts, data modeling, and database design.
- Experience building and supporting automated data flows and telemetry pipelines.
- Experience working with APIs, scripting, database queries, and structured data formats.