Data Warehouse Analyst

Robotics Prcocess Automation, LLC; Tallahassee (FL); On-site; USD 85,000 - 110,000; Full time

Job summary

A leading automation technology company in Tallahassee, Florida is seeking an experienced professional with strong data integration and warehousing experience. The role involves strategic planning for data warehouse design and development using Snowflake and Informatica. The ideal candidate will have expertise in ETL/ELT processes, data governance, and be proficient in designing BI models with Power BI and Tableau. Join a dynamic team and contribute to innovative data solutions.

Qualifications

• Strong knowledge of data integration and warehousing best practices.
• Experience with IBM Mainframes, JCL, and DB2 analysis.
• Ability to design data models for Business Intelligence tools.

Responsibilities

• Participates in strategic planning for data warehouse design.
• Analyzes transactional data stores for optimization.
• Coaches peers on data warehousing concepts.

Skills

Data Integration

Data Warehousing

Snowflake Data Cloud

Informatica IICS

ETL/ELT processes

Power BI

Tableau

Change Data Capture

COBOL

DB2

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

ROBOTIC PROCESS AUTOMATION 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. ROBOTIC PROCESS AUTOMATION 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 ROBOTIC PROCESS AUTOMATION 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