Data Analyst

Data Ideology; Pittsburgh (Allegheny County); Remote; USD 70,000 - 90,000; Full time

Job summary

A data analytics company located in Pittsburgh is seeking a Data Analyst to drive data insights and support a data warehouse consolidation project. The ideal candidate will have experience analyzing data, conducting ETL processes, and collaborating with both business and technical teams. Requirements include a bachelor's degree in a related field and proficiency with SQL and other programming languages. This role offers remote work options and emphasizes teamwork and effective communication.

Qualifications

• 2+ years’ experience with any programming language.
• 3+ years’ experience in data analytics on any data warehouse.
• Healthcare experience preferred.

Responsibilities

• Conduct in-depth analysis to identify trends in data.
• Assist with ETL processes for data extraction.
• Perform data validation and testing to ensure quality.
• Collaborate with teams on goals and deliverables.
• Accurately document data mappings and processes.

Skills

Data analysis

SQL

Problem solving

Collaboration

Documentation

Education

Bachelor’s degree in healthcare or computer science

Tools

Oracle

SQL

Snowflake

Python

PLSQL

Job description

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, visitwww.dataideology.com.

Data Analyst

We are looking for a Data Analyst to join our growing team. A Data Analyst will leverage their business and technical knowledge to organize and manage deliverables in a data warehouse consolidation and business intelligence implementation project, while also working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Key Responsibilities

• Data Analysis and Interpretation:
  • Conduct in-depth analysis using the data warehouse to identify trends, patterns, and insights.
  • Interpret complex data sets and communicate findings to both technical and non-technical stakeholders.
• Data Extraction and Transformation:
  • Assist with ETL processes to extract, transform, and load data from various sources.
  • Collaborate with IT teams to create seamless data integrations.
• Quality Assurance and Testing:
  • Perform thorough data validation and testing to ensure the highest possible data quality.
  • Clearly define and communicate when quality standards are not being met.
• Problem Solving:
  • Perform root cause analysis to identify the underlying or fundamental causes of an issue or problem.
  • Demonstrate ability to offer suggestions and solutions to remedy issues and promote sustainability.
• Collaboration and Communication:
  • Work closely with cross-functional teams, including IT and business stakeholders, to align on goals and key deliverables.
  • Effectively prioritize tasks to meet established team goals.
• Documentation:
  • Accurately document data mappings and definitions.
  • Outline standard processes and procedures of core activities.

Supervisory Responsibilities

None

Qualifications

Education and Experience

• Bachelor’s degree in healthcare or computer science related field preferred, but not necessary.
• 2+ years’ experience with any programming language (SQL, PLSQL, R, Python, etc).
• 3+ years’ experience in data analytics on any data warehouse (Oracle, SQL, Snowflake).
• Healthcare experience a plus.
• Agile/SAFe 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.
• Occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
• Constantly operate a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
• Frequent communication with clients and coworkers. Must be able to exchange accurate information in these situations.

Data Ideology is an EEO Employer.