Senior Data Engineer

Job description

Position Summary Climate Pros is seeking a Senior Data Engineer to support the design, development, and modernization of our data platform. This role focuses on building scalable, secure, and high-performing data systems aligned with long-term architecture and business needs. You will contribute to key initiatives including transitioning to cloud-managed relational databases (currently SQL Server on AWS RDS, with future consideration for platforms such as PostgreSQL), evolving toward Microsoft Fabric, and enabling data for advanced analytics and AI. Key Responsibilities: Data Architecture & Modeling: - Design scalable data models for operational and analytical use - Develop relational, dimensional, and analytical data structures - Ensure consistency and integrity across systems - Design solutions portable across database platforms where practical Data Engineering & Pipelines: - Build and maintain ETL/ELT pipelines - Support batch and near real-time data processing - Automate ingestion and transformation processes Platform Modernization: - Support SQL Server workloads in AWS RDS - Assist transition toward Microsoft Fabric - Align with long-term data platform strategy Scalability & P...