Data Warehouse Analyst
Listed on 2026-01-01
-
IT/Tech
Data Engineer, Data Warehousing
Job Title
Data Warehouse Analyst
LocationTallahassee, FL (On-site)
Duration6 Months + Extension
Job DescriptionThe Data Warehouse Analyst will be responsible for designing, developing, and supporting enterprise data warehouse and analytics solutions for a large government client. This role requires close collaboration with business users, data architects, and technical teams to ensure accurate, optimized, and governed data solutions.
Key Responsibilities- Gather, analyze, and document business and reporting requirements.
- Design and evaluate data warehouse architecture and enterprise data models.
- Develop and support data integration solutions using Snowflake Data Cloud and Informatica IICS / Power Center.
- Perform ETL/ELT development, including data extraction, transformation, loading, cleansing, replication, and validation.
- Analyze transactional data sources and optimize warehouse models for analytics and reporting.
- Review and validate data accuracy and completeness in the data warehouse.
- Prototype, build, and test reports and dashboards using Power BI and Tableau.
- Provide technical consulting and guidance to users on data usage, conflicts, and best practices.
- Support metadata management and data governance initiatives using tools such as EDC, Axon, and CDGC.
- Perform performance tuning for Snowflake and Informatica IICS environments.
- Mentor and coach team members on data warehousing concepts and tools.
- Maintain documentation, standards, and best practices for data warehousing and analytics.
- 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, data warehousing, and business intelligence solutions.
- Strong hands‑on experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration preferred.
- Data warehousing and data integration expertise (ETL/ELT).
- Snowflake Data Cloud design, administration, and performance tuning.
- Informatica IICS, Power Center, Data Quality, and Power Exchange (CDC).
- Business intelligence tools:
Power BI and Tableau. - Enterprise data modeling and metadata management.
- Data governance tools: EDC, Axon, CDGC.
- Experience analyzing IBM Mainframe environments (COBOL, JCL, DB2).
- Strong analytical, communication, and collaboration skills.
- Trilyon, Inc. offers a comprehensive benefits package.
- Opportunities for growth and professional development.
- Collaborative and inclusive company culture.
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.
Trilyon, Inc. has been a leader in global workforce solutions for over 16 years, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies.
Apply via Dice today!
Thank you
Anjali Sharma
(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).