Data Warehouse Analyst | Snowflake & BI Dashboards

Artifintech; Tallahassee (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC seeks a data integration specialist in Florida to design data models for BI tools and optimize Snowflake-based data warehouses. You will work on ETL/ELT tasks, mentor teammates, and create dashboards in Power BI and Tableau.

Responsibilities include strategic planning for data warehouse design, performance tuning, and governance practices. Proactive collaboration across teams is expected.

Qualifications

• Experience designing data models for BI tools like Power BI and Tableau.
• Experience with Informatica on-premises products like PowerCenter and DataQuality.
• Experience with ELT with ChangeDataCapture solutions like PowerExchange.
• Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
• Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
• Ensures data warehouse metadata is collected and maintained.
• Experience with Informatica IICS Cloud Performance Tuning.
• Experience with Snowflake Data Cloud Performance Tuning.
• Experience with Data Governance products, like EDC, Axon, and CDGC.

Responsibilities

• Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development.
• Analyzes transactional data stores and develops data warehouse models to optimize reporting and analytics.
• Coaches and mentors peers in data warehousing concepts and tools.
• Prototype, build, and test Power BI and Tableau reports and dashboards.
• Assist with development and maintenance of methods and practices documentation.

Skills

Data integration

ETL/ELT

Mentoring

Analytical thinking

Tools

Informatica PowerCenter

Informatica IICS Cloud

Snowflake Data Cloud

Tableau

PowerExchange

COBOL

DB2

Job description

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC seeks a data integration specialist in Florida to design data models for BI tools and optimize Snowflake-based data warehouses. You will work on ETL/ELT tasks, mentor teammates, and create dashboards in Power BI and Tableau.

Responsibilities include strategic planning for data warehouse design, performance tuning, and governance practices. Proactive collaboration across teams is expected.