Data Warehouse Analyst

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 18 Month(s)
No Travel Required

Skills

Data Management
Cloud Computing
Dashboard
Data Extraction
Microsoft Power BI
Problem Solving
JCL
Data Modeling
Data Quality
ELT
Extract
Transform
Load
Decision-making
Reporting
Warehouse
Red Hat Linux
Oracle
Microsoft SQL Server

Job Details

Job Title: Data Warehouse Analyst Advanced

Education

  • Bachelor s Degree in Computer Science, Information Systems, or related field.

  • Equivalent work experience may be considered.

  • Scope of Services

    The Data Warehouse Analyst will be responsible for gathering and assessing business information needs, preparing system requirements, and performing data analyses in a Snowflake cloud data warehouse environment. This role requires expertise in data design, database architecture, and data management utilizing Informatica PowerCenter, Informatica IDMC tools, Intelligent Data Quality, and Enterprise Data Catalog.

    The Analyst will work with the user community to produce reporting requirements, validate and ensure accuracy of data loaded into the warehouse, and provide technical consulting on data usage. Responsibilities include prototyping solutions, building and testing data integrations, and supporting enterprise data modeling and administration in Snowflake and Informatica environments.

    Primary Duties & Tasks

    1. Perform strong data integration and warehousing using Informatica IDMC tools (CDI, MI, CAI, etc.).

    2. Execute ETL/ELT tasks for data extraction, transformation, and loading.

    3. Administer IDMC platform, Secure Agent Infrastructure, and Snowflake Data Cloud platform.

    4. Utilize relational database platforms including DB2, SQL Server, Snowflake, and Oracle.

    5. Analyze transactional data stores and develop optimized data warehouse models.

    6. Administer Red Hat Linux applications (security patching, file system management, startup scripts).

    7. Implement Change Data Capture (CDC) solutions using Informatica connectors (e.g., PowerExchange, ServiceNow).

    8. Develop and maintain methods, standards, and documentation.

    9. Support legacy IBM Mainframes with COBOL, JCL, and DB2 analysis.

  • Required Experience

    • Minimum 7 years of IT work experience in data management, business intelligence, and data warehousing.

    • Extensive experience with Informatica PowerCenter and Snowflake Data Cloud.

    • Strong experience with Power BI, Tableau, and Cognos for BI reporting and dashboarding.

    • Hands-on experience with Informatica IDMC Cloud and Snowflake administration.

    • Proven expertise in performance tuning for Informatica IDMC and Snowflake environments.

  • Key Knowledge, Skills, and Abilities (KSAs)

    Job-Specific KSAs:

    • Data modeling for BI tools (Power BI, Cognos).

    • Development with Snowflake Data Cloud.

    • Metadata collection and management.

    • Cloud performance tuning (IDMC, Snowflake).

    • Report/dashboard prototyping with Power BI and Cognos.

    General KSAs:

    • Initiative: Ability to organize work, meet deadlines, and act independently.

    • Communication: Strong written and verbal communication across diverse settings.

    • Customer Service: Ability to assess needs and resolve issues effectively.

    • Decision Making: Sound, objective, and timely decision-making.

    • Flexibility: Adaptability to new processes and conditions.

    • Interpersonal: Professional, polite, and collaborative demeanor.

    • Leadership: Motivates and guides others toward goals.

    • Problem Solving: Strong analytical and evaluative skills.

    • Team Building: Encourages collaboration and achievement of shared goals.

    • Quality Assurance: Knowledge and application of QA techniques and tools.

    • Communication Proficiency

      • Strong oral and written communication skills required.

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.

About Influx Info Systems