Data Analyst (Pittsburgh)

Data Ideology; Pittsburgh (Allegheny County); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Remote work from home

Job summary

Data Ideology is seeking a Data Analyst in Pittsburgh to organize and manage deliverables in a data warehouse consolidation and BI implementation project. You will collaborate with business and IT teams to understand objectives, gather requirements, and ensure solutions meet client needs throughout the analytics lifecycle.

The role emphasizes data analysis, data quality, ETL support, and cross-functional collaboration with stakeholders.

Qualifications

• 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)
• 2+ years’ experience in data analytics on any data warehouse (Oracle, SQL, Snowflake)
• Healthcare experience a plus
• Remote work from home.
• Hours of work and days are generally Monday through Friday.

Responsibilities

• Data Analysis and Interpretation: conduct in-depth analysis to identify trends and insights.
• Data Extraction and Transformation: assist with ETL to load data from various sources.
• Quality Assurance and Testing: validate data quality and communicate when standards are not met.
• Problem Solving: perform root cause analysis and propose solutions.
• Collaboration and Communication: work with IT and business stakeholders to align goals.
• Documentation: document data mappings and standard processes.

Skills

Data analysis

Business awareness

Education

Bachelor's degree in healthcare or computer science related field

Tools

SQL

PLSQL

R

Python

Oracle

Snowflake

Job description

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 (Pittsburgh)

We are looking for 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

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.

• 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:

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)
• 2+ years’ experience in data analytics on any data warehouse (Oracle, SQL, Snowflake)
• Healthcare experience a plus
• 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.