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.
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
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
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 StageRecent News
Company data provided by crunchbase