We respectfully request that 3rd parties refrain from contacting us regarding this posting. Overview Our client is seeking a highly skilled and hands-on Data Warehouse Developer to lead the design, development, and optimization of the enterprise data warehouse and reporting infrastructure. This role is critical to ensuring the success of their data integration efforts following a recent platform migration. The ideal candidate will bring a strategic mindset and deep technical expertise to rebuild and enhance the data architecture, enabling accurate reporting and seamless data flow across systems. You will be responsible for architecting scalable ETL solutions, implementing dimensional models (star and snowflake schemas), and ensuring data integrity across legacy and modern platforms. Your work will directly support executive decision-making and operational efficiency in a complex insurance and finance environment. Responsibilities • Architect and implement robust ETL pipelines to support data migration, transformation, and integration between legacy systems and Guidewire. • Rebuild and optimize the data warehouse using star and snowflake schema models to support accurate and timely reporting. • Design and implement data cubes and OLAP structures to enable multidimensional analysis for business and finance teams. • Collaborate with business stakeholders to understand reporting needs and translate them into scalable data solutions. • Ensure data integrity, version control, and traceability across systems. • Troubleshoot and resolve data linkage issues between legacy and Guidewire platforms. • Provide hands-on development using ETL tools and scripting languages to deliver production-ready solutions. • Document architecture, data flows, and transformation logic for transparency and maintainability. Qualifications • Proven experience as an ETL Architect and Developer with a strong background in data warehouse design and implementation. • Deep expertise in dimensional modeling, including star and snowflake schemas. • Hands-on experience with data cube design and OLAP technologies. • Strong understanding of insurance and finance domain terminology and data structures. • Experience working with Guidewire systems is highly preferred. • Proficiency in SQL, data transformation tools (e.g., Informatica, DBT, Talend), and scripting (e.g., Python, Shell). • Familiarity with cloud-based data platforms (e.g., Snowflake, Azure Data Lake, AWS Redshift) is a plus. • Excellent problem-solving skills and the ability to work independently and collaboratively.