Tallahassee, Florida
Duties
- Participates in strategic planning for the Snowflake enterprise data warehouse
- Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics
- Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs
- Prototypes, builds, and tests data quality processes and related jobs
- Ensures data warehouse metadata is collected and maintained
- Prototypes, builds, and tests Power BI reports and dashboards
- Prototypes, builds, and tests Tableau reports and dashboards
- 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
Mandatory Requirements
- Experience (8+ Years)
Requirements
- This is an 100% onsite.
- A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing. Extensive experience with Informatica PowerCenter and Snowflake is preferred.
- 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 Informatica PowerCenter functionality
- Knowledge of and skill in Informatica Intelligent Data Quality functionality
- Knowledge of and skill in Informatica Enterprise Data Catalog functionality
- Knowledge of and skill in Power BI functionality
- Knowledge of and skill in Tableau functionality
- Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle