Senior Data Warehouse Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

SGS Technologie · 17 hours ago

Senior Data Warehouse Analyst

SGS Technologie is seeking an experienced Senior Data Warehouse Analyst with strong expertise in Snowflake Data Cloud and Informatica IICS Cloud Data Integration. The role involves designing, developing, and maintaining data integration and warehousing solutions to support reporting and analytics initiatives.

AnalyticsAppsDigital MarketingInternetSEOSoftwareWeb AppsWeb DesignWeb DevelopmentWeb Hosting
check
H1B Sponsor Likelynote
Hiring Manager
Supraja Krish
linkedin

Responsibilities

Design, develop, and maintain data integration and data warehousing solutions using Snowflake and Informatica IICS
Perform ETL / ELT processes including data extraction, transformation, and loading
Participate in enterprise data warehouse and data lakehouse architecture planning
Analyze transactional data sources and develop optimized data warehouse models
Build, prototype, and test Power BI and Tableau dashboards and reports
Mentor and coach team members on data warehousing concepts and best practices
Maintain documentation for data integration methods, standards, and processes
Ensure accurate collection and maintenance of data warehouse metadata

Qualification

Snowflake Data CloudInformatica IICS Cloud Data IntegrationData WarehousingBusiness IntelligenceData Governance toolsPower BITableauData ModelingPerformance TuningAnalytical SkillsCommunication Skills

Required

Bachelor's Degree in Computer Science, Information Systems, or a related field (required)
Equivalent professional experience may be considered in lieu of a degree
7+ years of IT experience in data management, data warehousing, and business intelligence
Strong hands-on experience with Informatica IICS Cloud Data Integration and Snowflake Data Cloud
Design, develop, and maintain data integration and data warehousing solutions using Snowflake and Informatica IICS
Perform ETL / ELT processes including data extraction, transformation, and loading
Participate in enterprise data warehouse and data lakehouse architecture planning
Analyze transactional data sources and develop optimized data warehouse models
Build, prototype, and test Power BI and Tableau dashboards and reports
Mentor and coach team members on data warehousing concepts and best practices
Maintain documentation for data integration methods, standards, and processes
Ensure accurate collection and maintenance of data warehouse metadata
Strong experience designing data models for BI tools such as Power BI and Tableau
Hands-on experience with Informatica PowerCenter and Data Quality
Experience with ELT and Change Data Capture (CDC) tools such as PowerExchange
Knowledge of IBM Mainframe technologies including COBOL, JCL, and DB2 (analysis level)
Experience with IICS Cloud Administration and Snowflake Administration
Proven expertise in performance tuning for Informatica IICS and Snowflake
Experience with Data Governance tools such as EDC, Axon, and CDGC

Preferred

Strong analytical and problem-solving abilities
Excellent communication and documentation skills
Experience working in large enterprise or government environments

Company

SGS Technologie

twittertwittertwitter
company-logo
SGS Technologies is a web design and development company that offers a range of web development and optimization services to its clients.

H1B Sponsorship

SGS Technologie has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (18)
2024 (43)
2023 (49)
2022 (28)
2021 (32)
2020 (38)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Arun Venkatesan
CEO
linkedin
leader-logo
Karthikeyan Lakshmanan, CSM
Client Partner
linkedin
Company data provided by crunchbase