Title: Enterprise Data Warehouse Analyst
Location: Tallahassee, FL
Job Description:
Key Responsibilities
Required Qualifications
Work Environment
Education / Experience
Location: Tallahassee, FL
Job Description:
Key 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.
Required Qualifications
- Minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
Work Environment
- Onsite work at the reporting location, Monday-Friday, during business hours.
- Flexibility to work hours between 7:00 AM & 7:00 PM and/or Saturdays, on rotation or as part of an on-call schedule.
- Occasional remote work may be approved at the discretion of the hiring manager.
Education / Experience
- Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.