Data Warehousing Specialists

Visionet Systems; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Visionet Systems is seeking a Data Warehousing Specialist in Pittsburgh to design and implement data solutions, develop dashboards with Power BI and Tableau, and manage ETL processes across Snowflake, Oracle, and cloud services. The role emphasizes collaboration with clients, documentation, and adherence to architectural standards.

The candidate will work within a sprint framework, communicate progress to stakeholders, and contribute to data movement and modeling using SQL, AWS Glue, and IICS.

Qualifications

• Bachelor of Science in Information Technology, Computer Science or related.
• 2 years of experience in the offered position or related roles.
• Experience with Snowflake cloud database and AWS services.
• Proficiency with SQL, Oracle, DBT, and data integration tools.

Responsibilities

• Create and review technical documentation for applications and reports.
• Develop reports and dashboards using Power BI and Tableau.
• Design workable software solutions and follow an agile sprint model.
• Manage ETL pipelines and data movement using IICS, SQL, and AWS Glue.
• Handle administration & troubleshooting of data platforms (Power BI, Tableau On-Prem).
• Define architecture collaboratively and align with technology standards.

Skills

Communication skills

Documentation

Project coordination

Education

Bachelor of Science in Information Technology/CS

Tools

Power BI

Tableau

SQL

Snowflake

Oracle

DBT

GitLab

VS Code

AWS

Azure

AWS Glue

IICS

Job description

Data Warehousing Specialists with the following duties:

• Create and review technical documentation for applications and reports. Design workable software solution
• Follow sprint model, communicate regular updates about project to client and stakeholders
• Develop reports and dashboard using reporting tools like Power BI and Tableau
• General administration of Power BI On-Prem and Tableau On-Prem servers
• Develop ETL or pipelines for data movement and modelling using tools and programs like IICS, SQL, and AWS Glue
• Manage and troubleshoot ETL processes, perform DBA/Admin tasks on SQL, Snowflake, Informatica IICS, AWS, Azure and ensure efficient scheduling and error handling for data integration workflows
• Support in defining implementation architecture based on expertise in the Azure/AWS technologies, construct applications and services using the Azure and AWS platforms, and help drive automation & integration aspects around the platform
• Assure that application architecture, design and implementation are consistent with technology strategy and software standards

Requirements:

Educational requirements: Bachelor of Science in Information Technology, Computer Science or related.

2 years of experience in the offered position, or in the alternate job title of Senior Managing Consultant Data Analytics, Managing Consultant Data Analytics, or a related occupation.

2 years of experience in following skill sets:

• Snowflake Cloud Database
• AWS- Amazon Cloud Services (S3, Athena, Glue, CLS)
• Oracle, DBT
• GitLab, VS Code

Employer will accept any suitable combination of education, training or experience.

Job Site:

The position is currently located in Pittsburgh, PA, but may require medium to long-term relocation to either Cranbury, NJ or other unanticipated locations in the US.