Apply on Employer Site

Dexian · 7 hours ago

Data Warehouse Analyst

Tallahassee, FL

Full-time

Onsite

Senior Level

7+ years exp

Dexian is a leading technology and professional staffing company with a global presence. They are seeking a Data Warehouse Analyst to prototype, build, and test ETL jobs while optimizing data warehouse models for reporting and analytics.

ConsultingHuman ResourcesInformation TechnologyProfessional ServicesStaffing Agency

H1B Sponsor Likely

Responsibilities

Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs

Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics

Creates designs, diagrams, and documents to support data integration and data warehouse solutions

Ensures data warehouse metadata is collected and maintained

Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse

Assists with the development and maintenance of methods and practices documentation

Qualification

Data WarehousingETL/ELT DevelopmentInformatica IDMCInformatica PowerCenterSnowflakeData QualityData CatalogPower BITableauRelational DatabasesData ModelingCoachingDocumentation

Required

7 Years experience in Data Warehousing and Data Integration

4 Years experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions

Extensive knowledge of data warehouse and data mart concepts

Ability to model transactional data for data warehousing usage

Knowledge of and skill in Snowflake cloud data warehouse functionality

Extensive knowledge of and expert skill in use of Informatica PowerCenter Cloud Platform

Knowledge of and skill in Informatica Data Quality functionality

Knowledge of and skill in Informatica Data Catalog functionality

Knowledge of and skill in Power BI, Tableau, and other reporting tools functionality

Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle

Company

Dexian

Glassdoor3.5

Dexian provides services for staffing, talent development, and consulting, with a focus on technology, finance, and project management.

Founded in 1994

Mclean, Virginia, USA

1001-5000 employees

https://dexian.com

H1B Sponsorship

Dexian 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 (65)