SMX Services & Consulting, Inc. ยท 1 day ago
Data Warehouse Analyst
Tallahassee, FL
Contract
Onsite
Senior Level
7+ years expSMX Services & Consulting, Inc. is seeking an experienced Advanced Data Warehouse Analyst to support cloud-based data integration initiatives for the Florida Department of Transportation. 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.
Information ServicesInformation Technology
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
Qualification
Required
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 PowerCenter 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
Company
SMX Services & Consulting, Inc.
Driving the Future with Technology, Talent, and Strategic Solutions At SMX Services & Consulting, Inc., we transform the way businesses manage their technology and talent by providing comprehensive solutions in IT & Engineering Staffing, SAP, Cybersecurity, Managed Services, and Digital Health.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Richard Quevedo
CEO
Steve Hodges
Chief Technology Officer
Company data provided by crunchbase