Trinnex is seeking a Senior Data Engineer to join our growing Digital Engineering team. Trinnex is building next generation tools that integrate sensor/IoT data, models, and geospatial data and machine learning to solve unique engineering and environmental issues.
This role requires a deep understanding of various data sources, data modeling, ETL processes, and scripting. You will work on integration of client data sources and enterprise applications with existing Trinnex products and new custom developed solutions. Example data sources include ESRI GIS, Customer Information Systems (CIS), CMMS, IoT, relational databases and other data systems. Ideally, you should have extensive experience in the development of ETL’s, data management, and usage of APIs.
Responsibilities In This Role Include
- Designing and Developing ETL Processes: Creating ETL workflows that extract data from source systems, transform it into a suitable format, and load it into target systems such as data warehouses.
- Data Integration: Ensuring the smooth and efficient transfer of data between different systems, consolidating data from multiple sources, and maintaining data quality.
- Automation: Automating ETL workflows to save time and reduce errors, enabling faster data integration and analysis.
- Data Quality and Consistency: Ensuring that data is complete, accurate, and consistent throughout the ETL process.
- Collaboration: Working with other data professionals to design and implement data models, troubleshoot data integration issues, and ensure data quality
- Implements the development of software solutions for custom projects. Ensures development documentation for applications is performed and complete.
- Collaborate with software developers, data scientists, and other stakeholders to understand data requirements and deliver high-quality data solutions.
- Optimize data storage solutions, including data warehouses and data lakes, for performance and scalability.
- Stay up to date with the latest industry trends and technologies in data architecture and recommend best practices.
- Support creativity, efficient decision making and elegant code. Write and review clean code. Generate reusable code libraries.
- Liaise with developers, designers, and DevOps to identify new features, and review code and deliverables.
- Performs other duties as required.