Data Analyst

Reposted 3 Days Ago
Pittsburgh, PA, USA
In-Office
Junior
Database • Analytics
The Role
The Data Analyst will support cloud data warehouse migration, analyze data, write SQL queries, validate data quality, and collaborate with cross-functional teams to deliver scalable data solutions.
Summary Generated by Built In

Data Ideology 
At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious.  For more information about Data Ideology, visit www.dataideology.com  
Data Analyst
Job Type: Full-Time, 6-Month Fixed-Term (Renewable)
This is a full-time position with an initial 6-month term. Employment may be extended based on business needs and performance but is not guaranteed.

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.
Key Responsibilities
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
Supervisory Responsibilities: None
Qualifications
Education and Experience:
Education and Experience:
  • 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
Work Environment:
  • 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.
Data Ideology is an EEO Employer
 

Skills Required

  • Bachelor's degree in Computer Science or related field
  • 2+ years of experience writing SQL queries and/or stored procedures
  • 3+ years of experience performing data analysis within a data warehouse environment
  • Experience working with cloud-based data platforms like Snowflake or Azure SQL
  • Experience querying and analyzing semi-structured or non-relational data
  • Familiarity with Agile development methodologies
  • Healthcare industry experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pittsburgh, PA
43 Employees
Year Founded: 2017

What We Do

Based in Pittsburgh, Pennsylvania, Data Ideology is the region's fastest-growing data & analytics consultancy serving the area’s largest enterprises in healthcare and technology. Our team consists of highly competitive individuals who are experts in the field and passionate about data and the value it can bring to organizations. We specialize in data warehouse modernization , data warehouse migration, eliminating data silo’s , data governance , data visualization , and enterprise deployment , bringing data together , eliminating complexity and providing top-notch training solutions. At Data Ideology, we drive a culture of empowerment at the top level of management and ownership of results so that our customers win every day. Our main focus is on our clients, as well as on their processes, data and technology to help them realize greater value with their analytics investments. We work one on one with companies to leverage their data assets by implementing our methodology and framework to strengthen the strategic value of data within their organizations, respectively.

Similar Jobs

Agero Logo Agero

Data Analyst

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
USA
1600 Employees
110K-135K Annually

PNC Bank Logo PNC Bank

Data Analyst

Machine Learning • Payments • Security • Software • Financial Services
Hybrid
Pittsburgh, PA, USA
55000 Employees
55K-131K Annually

Zeta Global Logo Zeta Global

Data Analyst

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Remote or Hybrid
United States
2429 Employees
85K-95K Annually

GoodRx Logo GoodRx

Data Analyst

Consumer Web • Coupons • Healthtech • Social Impact • Pharmaceutical
Remote or Hybrid
USA
800 Employees
75K-229K Annually

Similar Companies Hiring

Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Other • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account