Data Warehouse Analyst
Job in
Tallahassee, Franklin County, Florida, 32318, USA
Listed on 2026-01-12
Listing for:
SMX Services & Consulting, Inc.
Full Time
position Listed on 2026-01-12
Job specializations:
-
IT/Tech
Data Engineer, Data Warehousing, Data Analyst, Database Administrator
Job Description & How to Apply Below
Advanced Data Warehouse Analyst
The Florida Department of Transportation (FDOT) is seeking an experienced Advanced Data Warehouse Analyst to support cloud-based data integration initiatives for the PALM program.
This role focuses on translating business needs into system and integration requirements, designing and managing scalable ETL/ELT pipelines, and ensuring accurate, reliable, and governed data delivery across multiple platforms.
The ideal candidate will have deep experience with Informatica Intelligent Data Management Cloud (IDMC), cloud data warehousing, and legacy system modernization, including mainframe code conversion.
Key Responsibilities- Design, develop, test, and maintain ETL/ELT pipelines using Informatica IDMC and related tools.
- Translate business, reporting, and analytics requirements into technical integration solutions.
- Support both batch and real‑time data integration workflows.
- Analyze transactional data sources and design optimized data warehouse and data mart models.
- Perform data modeling to support cloud data warehousing initiatives.
- Convert legacy mainframe code (JCL, COOLGEN, COBOL, FOCUS, WebFOCUS) into modern IDMC workflows.
- Analyze existing legacy logic, reports, and data flows to ensure accurate functional translation.
- Ensure data quality, performance optimization, and governance standards are met.
- Create technical designs, diagrams, and documentation for data integration solutions.
- Maintain and manage data warehouse metadata.
- Coach and mentor team members on data warehousing concepts and tools.
- Assist in developing and maintaining standards, methods, and best‑practice documentation.
- Minimum 7 years of IT experience in data warehousing and data integration.
- At least 4 years of experience designing, developing, and supporting ETL/ELT pipelines using Informatica IDMC and Informatica on‑prem solutions.
- Extensive experience with data warehouse and data mart concepts.
- Strong expertise in modeling transactional data for analytical use.
- Experience with Snowflake cloud data warehouse.
- Expert‑level skill with Informatica Power Center Cloud Platform.
- Experience with Informatica Data Quality and Informatica Data Catalog.
- Proficiency with reporting and analytics tools such as Power BI and Tableau.
- Experience with relational databases including DB2, SQL Server, and Oracle.
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Equivalent professional experience may be substituted for formal education.
- Excellent written and verbal communication skills.
- Strong customer service orientation.
- Sound decision‑making and problem‑solving abilities.
- Ability to adapt to changing priorities and technologies.
- Strong interpersonal and teamwork skills.
- Demonstrated leadership and mentoring capability.
- Commitment to quality assurance and best practices.
- Seniority level:
Mid‑Senior level. - Employment type:
Contract. - Job function:
Information Technology. - Industry: IT Services and IT Consulting.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×