Data Warehouse Analyst

Cloud Analytics Technologies, LLC; Tallahassee (FL); On-site; USD 85,000 - 130,000; Full time

Benefits offered by this job

Equal Opportunity Employer

Job summary

CLOUD ANALYTICS TECHNOLOGIES LLC is seeking a data integration and data warehousing specialist with strong Snowflake and Informatica experience to design and optimize enterprise data warehouse/ data lakehouse solutions.

You will prototype and validate Power BI and Tableau dashboards, mentor peers, and contribute to governance and best practices. The role emphasizes ELT/ETL, metadata maintenance, and collaboration with strategic planning for cloud data platforms.

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 Change DataCapture 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

• Analyses transactional data stores and develops data warehouse models for reporting and analytics.
• Prototypes, builds, and tests Power BI and Tableau dashboards.
• Coaches and mentors peers in data warehousing concepts and tools.
• Participates in strategic planning for Snowflake enterprise data warehouse design and development.
• Assists with methods and practices documentation.

Skills

Snowflake Data Cloud

Informatica IICS Cloud Data

ETL/ELT

Power BI

Tableau

Data warehousing design

Mentoring / coaching

Tools

PowerCenter

DataQuality

PowerExchange

COBOL

JCL

DB2

Informatica IICS Cloud Administration

Snowflake Data Cloud Administration

Job description

StrongDataIntegration andDataWarehousing experience with SnowflakeDataCloud and Informatica IICS CloudDataIntegration tools.

Strong Experience withDataIntegration tasks like extraction, transformation, and load (ETL or ELT) tasks

Participates in strategic planning for the Snowflake enterprisedatawarehouse/data-lake-house design and development.

Analyzes transactionaldatastores and developsdatawarehouse models to optimize the warehouse for reporting andanalytics.

Coaches and mentors' peers indatawarehousing concepts and the tools utilized to analyzedata, design the warehouse models, and populate the warehouse.

Prototypes, builds, and tests Power BI and Tableau reports and dashboards.

Assists with the development and maintenance of methods and practices documentation.

Job Specific Knowledge, Skills, and Abilities:-

Experience designingdatamodels for Business Intelligence tools like Power BI and Tableau.

Experience with Informatica on-premises products like PowerCenter andDataQuality.

Experience with ELT with ChangeDataCapture solutions like PowerExchange.

Experience with IBM Mainframes COBOL, JCL, and DB2analysis.

Experience with IICS Cloud Administration and SnowflakeDataCloud Administration.

Ensuresdatawarehouse metadata is collected and maintained.

Experience with Informatica IICS Cloud Performance Tuning

Experience with SnowflakeDataCloud Performance Tuning

Experience withDataGovernance products, like EDC, Axon, and CDGC

CLOUD ANALYTICS TECHNOLOGIES is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract

Equal Opportunity Employer

CLOUD ANALYTICS TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract