Data Analyst

Data Inc
Pittsburgh, United States of America
5 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Remote
Pittsburgh, United States of America

Tech stack

Agile Methodologies
Data analysis
Big Data
Data Validation
ETL
Data Presentation
Data Warehousing
Relational Databases
Database Queries
Document-Oriented Databases
JSON
Microsoft SQL Server
SQL Azure
Oracle Applications
SQL Stored Procedures
SQL Databases
Test Case Design
Cloud Platform System
Snowflake
Information Technology
Data Pipelines

Job description

We are seeking a Data Analyst to join our growing team. In this role, you will combine business and technical expertise to support a cloud data warehouse migration, partnering with cross-functional teams to analyze data, define requirements, and deliver scalable data solutions., To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

  • Analyze source systems and data warehouse structures to support transformation into new data products, including performing gap analysis and identifying data requirements
  • Write and execute SQL queries to explore, validate, and interpret data across systems with limited documentation
  • Translate complex data logic into clear insights for both technical and non-technical stakeholders, including identifying edge cases and validating business rules
  • Support ETL processes and collaborate with developers and stakeholders to ensure solutions align with business needs and are feasible
  • Perform data validation, testing, and root cause analysis to ensure data quality and resolve issues
  • Contribute to proof-of-concepts, test case development, and scalable validation approaches for complex datasets
  • Partner with cross-functional teams to prioritize work, present findings, and support data storytelling through reports, visualizations, and diagrams
  • Document data mappings, definitions, and standard processes to support ongoing development and maintenance

Requirements

  • Bachelor's degree in Computer Science, a related field, or equivalent experience
  • 2+ years of experience writing SQL queries and/or stored procedures, with the ability to work independently on data exploration
  • 3+ years of experience performing data analysis within a data warehouse environment (e.g., Oracle, SQL Server, Snowflake)
  • Experience working with cloud-based data platforms (e.g., Snowflake, Azure SQL) preferred
  • Experience querying and analyzing semi-structured or non-relational data (e.g., JSON) preferred
  • Familiarity with Agile development methodologies
  • Healthcare industry experience a plus, This position is not eligible for visa sponsorship. Candidates must have current and ongoing authorization to work in the United States and must not require now or in the future employer-sponsored immigration petitions. Please note that dependent Employment Authorization Document (EAD) holders, including H-4 and L-2 visa holders, are not eligible for this role due to project continuity and stability requirements.

Benefits & conditions

  • Remote work from home.
  • Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

Physical Demands:

  • Must be able to remain in a stationary position 50% of the time.
  • The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
  • Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
  • The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.

Benefits: Eligible for Medical, Dental, Vision, 401(k) and flexible time off in accordance with company policies.

Apply for this position