Data Analyst Job at Data Ideology, LLC, Pittsburgh, PA

TXJPVTJBaXVWVVE1dGZjZGt2anZqeU9HVmc9PQ==
  • Data Ideology, LLC
  • Pittsburgh, PA

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, visit   


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

Job Tags

Full time, Fixed term contract, Work at office, Remote work, Monday to Friday, Flexible hours

Similar Jobs

Executive Alliance

Senior Structural Steel Detailer Job at Executive Alliance

 ...The primary job of the Senior Structural Steel Detailer is to generate comprehensive erection and shop drawings of all fabricated members, complete with a detailed bill of materials, encompassing field fastens and miscellaneous items. This task involves utilizing relevant... 

UF Health Jacksonville

Pulmonary Critical Care Medicine, UF Health St. Johns| Pulmonology/Critical Care Physician| Coast... Job at UF Health Jacksonville

 ...Job Description UF Health St. Johns is seeking a BC/BE Pulmonology/Critical Care Medicine physician to joinanestablished, highly respected pulmonology teamthat will staffour newesthospitallocation in St. Johns Countyat Durbin Park . As part of the... 

Petco

Ecommerce EPJ Operator (Sun-Thu 8a-4:30p) $19hr Job at Petco

Want to help pets live their best lives? We're proud to be where the pets go and where the pet people go. If you want to make a real difference, create an exciting career path, feel welcome to be your whole self and nurture your wellbeing, Petco is the place for you...

UCHealth

Anesthesia Technician YVMC Job at UCHealth

 ...Shift: Days Pay: $21.06 - $31.59 / hour. Pay is dependent on applicant's relevant experience Summary : Assists licensed anesthesia provider with duties related to the care and monitoring of patients and equipment. Responsibilities : Cleans, sterilizes... 

LHH US

Senior Staff Accountant, 75K-85K (Hybrid) Job at LHH US

 ...will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: The California Fair Chance Act Los Angeles City Fair Chance Ordinance Los...