Data Warehouse Analyst; Advanced

Position

Data Warehouse Analyst (Advanced)

605 Suwannee St., Tallahassee, FL 32399

6 Months + Extension

This role supports cloud‑based data integration initiatives, translating business needs into system and integration requirements for government clients. The analyst will design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud, ensuring accurate, reliable, and governed data across diverse platforms.

• Translate business needs into system and integration requirements.
• Design, develop, and manage scalable ETL/ELT pipelines using Informatica IDMC.
• Collaborate with business stakeholders to document reporting and analytics requirements and validate data quality.
• Support real‑time and batch data flows and conduct data modeling for cloud data warehousing.
• Optimize performance and data quality through modular pipeline design and orchestration.
• Convert legacy mainframe scripts (JCL, COOLGEN, COBOL, FOCUS, WebFOCUS) into modern IDMC workflows, ensuring functional equivalence.
• Document testing strategies and maintain clear documentation throughout the conversion process.
• Coach and mentor peers on data warehousing concepts and tool usage.

• Bachelor’s Degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
• Minimum 7 years of IT experience with data management, business intelligence, and data warehousing tools.
• Extensive knowledge of data warehouse and data mart concepts.
• Experience designing, developing, and supporting ETL/ELT pipelines using Informatica IDMC and on‑prem solutions.
• Knowledge of Snowflake, Informatica Power Center Cloud, Data Quality, and Data Catalog.
• Proficiency with Power BI, Tableau, and other reporting tools.
• Experience with relational database platforms such as DB2, SQL Server, and Oracle.
• Ability to model transactional data for data warehousing usage.
• Familiarity with scripting languages and evolving cloud ecosystem.

• Comprehensive benefits package.
• Opportunities for growth and professional development.
• Collaborative and inclusive company culture.

Mid‑Senior level

Full‑time

Information Technology

Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.