Intermediate Data Warehouse Analyst

Veriipro; Orlando (FL); On-site; USD 80,000 - 110,000; Full time

Job summary

Veriipro is looking for a data specialist in Orlando, Florida, to develop and maintain ETL and ELT pipelines primarily with Azure Data Factory. The role requires strong SQL skills as well as hands-on experience with Snowflake, along with proficiency in reporting tools like Power BI or Sigma.

The ideal candidate will collaborate across teams to define data transformation logic and ensure data integrity. Excellent analytical and communication abilities are essential. Familiarity with OLAP vs. OLTP design concepts will be beneficial.

Qualifications

• Strong SQL experience is mandatory for this SQL-heavy role.
• Hands-on experience with Snowflake.
• Familiarity with cloud environments, preferably Microsoft Azure.

Responsibilities

• Develop and maintain ETL/ELT pipelines, primarily using Azure Data Factory.
• Perform SQL development for data extraction, transformation, and loading.
• Design, implement, and maintain data models in Snowflake.

Skills

SQL experience

Snowflake

ETL/ELT development

Reporting tools (Power BI or Sigma)

Data warehousing concepts

Microsoft Azure

OLAP and OLTP concepts

Analytical skills

Communication skills

Job description

Roles and Responsibilities

• Develop and maintain ETL/ELT pipelines, primarily using Azure Data Factory (ADF).
• Perform SQL development for data extraction, transformation, and loading.
• Design, implement, and maintain data models in Snowflake.
• Build and maintain business reporting dashboards using Power BI or Sigma.
• Work with large, complex datasets to support business and enterprise reporting requirements.
• Collaborate with cross‑functional teams to define data requirements and transformation logic.
• Ensure adherence to SDLC processes and support production data environments.
• Troubleshoot data issues and ensure data integrity.
• Contribute to data warehousing design, including OLAP and OLTP concepts and relational structures.

Required Skills & Qualifications

• Strong SQL experience (mandatory; this is an SQL-heavy role)
• Hands‑on experience with Snowflake
• Experience with ETL/ELT development, preferably using Azure Data Factory (ADF)
• Experience with reporting tools such as Power BI or Sigma
• Understanding of data warehousing concepts, data flows, and transformation logic
• Familiarity with cloud environments, preferably Microsoft Azure
• Understanding of OLAP vs. OLTP design concepts and relational data structures
• Strong analytical and problem‑solving skills
• Excellent communication skills and ability to work in a team-oriented environment
• Ability to organize work independently and manage multiple tasks/projects

Preferred

• Experience with Informatica or Oracle Warehouse Builder if ADF experience is limited
• Previous experience in production support for data platforms