Note: The job is a remote job and is open to candidates in USA. Data Ideology is a company that provides Data & Analytics expertise to drive measurable business outcomes. They are seeking a Data Analyst to support a cloud data warehouse migration by analyzing data, defining requirements, and delivering scalable data solutions in collaboration with cross-functional teams.
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
Skills
- 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)
- Experience querying and analyzing semi-structured or non-relational data (e.g., JSON)
- Familiarity with Agile development methodologies
- Healthcare industry experience a plus
Benefits
- Eligible for Medical, Dental, Vision, 401(k) and flexible time off in accordance with company policies.
Company Overview