Data Warehouse Analyst

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.

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.

• 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, 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.

• 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.

Thank you
Anjali Sharma