Capital Technology Alliance

About the Company

At Capital Technology Alliance, we are committed to pioneering the future of technology consulting. Our mission is to provide exceptional staff augmentation and consulting services to state and local entities, focusing on integrating innovative solutions and elevating operational efficiency. We strive to be more than a service provider; we aim to be a trusted partner, working hand-in-hand with our clients to tackle complex challenges and achieve sustainable success. Through our dedication to quality, collaboration, and forward-thinking, we empower organizations to embrace the future confidently. With Capital Technology Alliance, you don’t just adapt to change – you lead it. Innovate, Integrate, Elevate: Your Partner for the Future.

Listed Jobs

Company Name

Capital Technology Alliance

Job Title

Data Warehouse Analyst

Job Description

**Job Title** Data Warehouse Analyst **Role Summary** The Data Warehouse Analyst designs, develops, and maintains enterprise data warehouses and integration pipelines. With deep expertise in Informatica, Snowflake, and relational databases, the analyst ensures high‑quality, performant data models for reporting and analytics. The role also involves mentoring colleagues, documenting best practices, and collaborating with business stakeholders to meet data needs. **Expectations** - 7+ years of experience in data warehousing and integration. - 4+ years with Informatica IDMC, Informatica PowerCenter Cloud, and on‑prem solutions. - Proven ability to design ETL/ELT pipelines, model transactional data, and optimize warehouse architectures. - Strong command of Snowflake, Power BI, Tableau, and relational databases (DB2, SQL Server, Oracle). - Leadership in coaching, documentation, and process improvement. **Key Responsibilities** - Prototype, build, and test ETL/ELT jobs using Informatica tools. - Analyze transactional data stores and develop data warehouse models for reporting and analytics. - Create and maintain designs, diagrams, and documentation for data integration solutions. - Capture, update, and enforce data warehouse metadata management. - Mentor peers on data warehousing concepts, tool usage, and best practices. - Assist in developing and maintaining methods, practices, and documentation standards. **Required Skills** - Advanced knowledge of data warehouse and data mart concepts. - In‑depth proficiency in Informatica PowerCenter Cloud Platform, IDMC, Data Quality, and Data Catalog. - Expertise in Snowflake cloud data warehouse. - Strong ETL/ELT development skills (Informatica, SQL). - Experience with BI tools: Power BI, Tableau. - Solid foundation in relational database platforms: DB2, SQL Server, Oracle. - Excellent communication, customer service, decision‑making, flexibility, interpersonal, leadership, problem‑solving, and team‑building abilities. **Required Education & Certifications** - Bachelor’s Degree in Computer Science, Information Systems, or related field (or equivalent experience). - Relevant Informatica certifications (e.g., Informatica Cloud Data Integration, PowerCenter) strongly preferred.

Tallahassee, United states

On site

Senior

12-01-2026