Data Warehouse Analyst

Tallahassee, FL - USA

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

For over 16 years Trilyon has been a leader in global workforce solutions 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. For additional information or to view all of our job opportunities please visit our website:

We are seeking a Data Warehouse Analyst to join our team. This role will involve gathering and analyzing business requirements designing and managing enterprise data warehouse solutions and developing analytics and reporting capabilities within a Snowflake cloud environment. The ideal candidate will have strong experience in data warehousing ETL/ELT processes Informatica tools and business intelligence platforms along with a passion for data-driven decision-making and enterprise analytics.

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 include:

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.

Thank you
Anjali Sharma

For over 16 years Trilyon has been a leader in global workforce solutions 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. For additional...