Data Warehouse Analyst

🚨 Now Hiring: Data Warehouse Analyst (Advanced) 🚨 We’re looking for an experienced Data Warehouse Analyst (Advanced) to support a large-scale cloud data integration and modernization initiative for a major state government project. 📍 Location: Tallahassee, FL (Onsite – occasional remote flexibility at manager’s discretion) ⏳ Duration: ASAP through 06/30/2026 (with possible extension) 🕘 Schedule: Monday–Friday (flexible hours between 7 AM – 7 PM; occasional Saturdays may be required) 🔍 Role Overview You will play a key role in designing, developing, and supporting enterprise-level data warehouse and integration solutions. This position focuses heavily on Informatica IDMC, cloud ETL/ELT pipelines, and Snowflake, while also supporting legacy mainframe modernization efforts. 🛠 Key Responsibilities • Design, build, and optimize ETL/ELT pipelines using Informatica IDMC • Support cloud data warehousing and integration initiatives • Convert legacy mainframe logic (COBOL, JCL, COOLGEN, FOCUS/WebFOCUS) into modern cloud workflows • Perform data modeling for analytics and reporting • Collaborate with business and technical stakeholders to translate requirements into solutions • Ensure data quality, governance, and performance optimization • Create technical documentation, diagrams, and integration designs • Mentor team members on data warehousing best practices ✅ Required Skills & Experience • 7+ years of experience in Data Warehousing & Data Integration • 4+ years hands-on experience with Informatica IDMC / PowerCenter • Strong experience with Snowflake • Expertise in ETL/ELT design and data modeling • Experience with Informatica Data Quality & Data Catalog • Knowledge of Power BI, Tableau, or similar BI tools • Strong SQL and experience with DB2, SQL Server, or Oracle • Bachelor’s degree or equivalent experience