Data Analyst

Data Ideology•Pittsburgh, PA

1d•Remote

About The Position

At Data Ideology (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. 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.

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)

Nice To Haves

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

Responsibilities

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