Jobs via Dice
Job Title
Data Warehouse Analyst Location
Tallahassee, FL (On-site) Duration
6 Months + Extension Job Description
The 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 / PowerCenter. 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. Education & Experience
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. Required Skills & Knowledge (KSAs)
Data warehousing and data integration expertise (ETL/ELT). Snowflake Data Cloud design, administration, and performance tuning. Informatica IICS, PowerCenter, Data Quality, and PowerExchange (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. Why Join Us
Trilyon, Inc. offers a comprehensive benefits package. Opportunities for growth and professional development. Collaborative and inclusive company culture. Equal Employment Opportunity (EEO) Statement
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
#J-18808-Ljbffr
Data Warehouse Analyst Location
Tallahassee, FL (On-site) Duration
6 Months + Extension Job Description
The 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 / PowerCenter. 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. Education & Experience
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. Required Skills & Knowledge (KSAs)
Data warehousing and data integration expertise (ETL/ELT). Snowflake Data Cloud design, administration, and performance tuning. Informatica IICS, PowerCenter, Data Quality, and PowerExchange (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. Why Join Us
Trilyon, Inc. offers a comprehensive benefits package. Opportunities for growth and professional development. Collaborative and inclusive company culture. Equal Employment Opportunity (EEO) Statement
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
#J-18808-Ljbffr