Job Title : Data Warehouse Analyst
Job Location : Tallahassee, FL (on-site)
Job Duration : Contract through June + extension
Job Tasks and Activities :
- 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.
Required Experience :
7 Years experience in Data Warehousing and Data Integration4 Years experience designing, developing, and supporting ETL / ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutionsExtensive knowledge of data warehouse and data mart conceptsAbility to model transactional data for data warehousing usageKnowledge of and skill in Snowflake cloud data warehouse functionalityExtensive knowledge of and expert skill in use of Informatica PowerCenter Cloud PlatformKnowledge of and skill in Informatica Data Quality functionalityKnowledge of and skill in Informatica Data Catalog functionalityKnowledge of and skill in Power BI, Tableau, and other reporting tools functionalityKnowledge of and skill in relational database platforms including DB2, SQL Server, and OracleDexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.
Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https : / / dexian.com / .
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.