Overview
Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
50% Travel
Skills
INFORMATICA
SNOWFLAKE
MAINFRAME
ETL
Job Details
Role: Sr. Data Analyst
Location: Tallahassee, FL (2 days onsite and 3 days Remote)
Duration: 12+ months
Interview: PH/MS Teams
Address: 3185 S. Blair Stone Road Tallahassee, FL 32301
We are seeking a highly skilled and experienced Data Analyst to join our IT team. This position will be Hybrid, and is a contract position.
What You'll Do:
- Gather and assess business information needs and prepare system requirements
- Analyze, develop, and evaluate data mining processes in the Snowflake cloud data warehouse
- Design data, database architecture, and manage data using Informatica PowerCenter, Intelligent Data Quality and Enterprise Data Catalog
- Use data analysis tools like Power BI and Tableau
- Review and validate data accuracy in the data warehouse
- Interact with users to gather reporting requirements
- Provide technical consulting and advise on data usage
- Prototype, build, and test solutions for Snowflake data population (replication, extraction, loading, cleansing, transformation)
- Perform enterprise data modeling
- Administer IDMC platform and Secure Agent Infrastructure
- Administer Snowflake Data Cloud platform
- Analyze transactional data stores and develop optimized data warehouse models
- Administer Redhat Linux applications (security patching, disk management, scripts)
- Develop and test Power BI and Cognos reports/dashboards
- Ensure metadata is collected and maintained
- Tune performance for both Informatica IDMC Cloud and Snowflake Data Cloud
- Assist with documentation of methods and practices
What You'll Need:
Required
- 7+ years in IT using data management, BI tools, and data warehousing
- Extensive experience with Informatica PowerCenter and Snowflake
- Strong experience with Informatica IDMC tools (CDI, MI, CAI, etc.)
- Experience with ETL/ELT tasks
- Experience with PowerExchange and other IDMC connectors
- Experience with DB2, SQL Server, Oracle, and Snowflake
- Experience with IBM Mainframes (COBOL, JCL, DB2)
- Experience designing data models for Power BI and Cognos
- Experience with Informatica Data Quality
- Experience with IDMC Cloud Administration and Performance Tuning
- Experience with Snowflake Administration and Performance Tuning
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.