Enterprise Data Warehouse Analyst

Agama Solutions•Tallahassee, FL

1d•Onsite

About The Position

This role supports cloud-based data integration initiatives by translating business needs into system and integration requirements. The analyst will design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC), ensuring reliable delivery of accurate, consistent, and governed data. Responsibilities include collaborating with stakeholders, supporting data flows, conducting data modeling, optimizing performance, and converting legacy mainframe code to modern IDMC workflows. The role also involves analyzing legacy logic, rearchitecting processes, producing documentation, prototyping, building, and testing ETL/ELT jobs, and developing data warehouse models. Additionally, the analyst will create designs and documentation, maintain data warehouse metadata, and mentor peers.

Requirements

Minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.

Responsibilities

Support cloud-based data integration initiatives by translating business needs into system and integration requirements.
Design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC), including cloud data integration.
Ensure reliable delivery of accurate, consistent, and governed data across relational databases and mainframe flat files.
Collaborate with business stakeholders to document reporting and analytics requirements.
Validate that integrated data supports decision-making needs.
Support real-time and batch data flows.
Conduct data modeling for cloud data warehousing.
Optimize performance and data quality enforcement through modular pipeline design and orchestration.
Convert legacy mainframe code (JCL, COOLGEN, COBOL, FOCUS, WebFOCUS) into modern IDMC data integration workflows.
Analyze existing legacy logic, reports, and data flows to identify transformation requirements.
Rearchitect legacy processes using IDMC tools and implement equivalent cloud-native functionality.
Apply expertise in legacy data retrieval, report logic translation, and integration design aligned with best practices.
Produce clear documentation, structured testing, and collaborate closely with business and technical teams to ensure fidelity and completeness of conversions.
Prototype, build, and test ETL/ELT jobs.
Analyze transactional data stores and develop data warehouse models optimized for reporting and analytics.
Create designs, diagrams, and documentation supporting data integration and warehouse solutions.
Ensure data warehouse metadata is collected and maintained.
Coach and mentor peers in data warehousing concepts and tool usage.
Assist in development and maintenance of methods and practices documentation.