• Build and optimize scalable data pipelines (ETL-V) using Spark and Delta Lake. • Implement transformation logic and analytical models with dbt (Data Build Tool) across the Preparation, Public and Trilhas layers. • Design and manage resilient workflows using Apache Airflow. • Implement and maintain Open Metadata and Hive to record metadata and end-to-end data lineage, essential for certification. • Develop audit controls, data reconciliation tests and technical documentation to demonstrate data provenance and integrity from sources to BI (PostgreSQL/Metabase). • Optimize PostgreSQL for Business Intelligence consumption, ensuring compliance with business requirements.

• The Sr IBM iSeries Engineer is responsible for maintaining customer IBM i /iSeries environments and solving technical problems in an efficient manner. • Help plan and migrate customer systems via tape save/restore or software replication. • Expand existing customer environments and ensure proper handling of system backups. • React in a break/fix capacity to escalate technical issues that compromise system operability and functionality. • Work directly with implementations and new projects.

• Provides technical analysis and reviews for energy efficiency projects, provides project risk assessment • Perform building walk through and identify energy conservation measures (architectural, mechanical, electrical, etc.) in commercial, institutional, and industrial facilities • Customizes software and spreadsheets to achieve desired technical results and presentations • Provides project financial analysis including energy savings, simple payback, project life cycle costs and comparisons to relevant options • Serves as interface with utility incentive programs, determines project qualifications, completes required calculations or energy models, performs onsite project reviews with utility authorities, guides and completes post installation measurement and verification and analysis of data for submission to utility • Determines and proscribes best methods for measurement and verification of system performance • Conducts interim reviews during project construction to assess impact of any changes to the original contract scope of work • Creates energy models (TRACE, eQuest, DOE2) to assess and quantify energy savings for the proposed scope of work including equipment replacements, controls installation and for optimizing control strategies • Performs preliminary equipment selections in DST • Maps out and designs project layout (baseline information) in energy/utility accounting software • Analyzes data output for trends and/or any deviations that need further investigating • Provides expertise in new technologies and new techniques for project implementation • Reviews contract documents and conducts job surveys • Assists in the preparation of cost estimates for projects • Reviews equipment submittals for incorporation into design • Maintains customer satisfaction by investigation concerns, implementing corrective action and communication with staff, as needed, providing customer feedback • Participates in sales calls and project specific presentations • Trains sales and support staff in use of evaluation tools, and utility/state/federal energy efficiency specific programs, new technologies, basic HVAC concepts and system operations

• You'll prepare cost estimates and cost plans, incorporating benchmarking data for review. • You'll develop value engineering and life cycle costing options to optimize project efficiency. • You'll identify potential risks and help maintain the project’s Risk Register. • You'll contribute to pre-contract process meetings, offering cost-related insights. • You'll create and manage cost control reports to track financial performance. • You'll attend client meetings with senior colleagues and document key discussion points and actions. • You'll participate in design team meetings, assess cost implications, and implement agreed outcomes. • You'll assist in developing standardized project templates for consistent documentation. • You'll prepare and manage change order logs, invoice logs, and detailed cost reports. • You'll oversee measurements and pricing research for development appraisals and qualification reviews.