At AssistRx, the business problem is to simplify patient access and drive better health outcomes by combining AI technology and human insight, and the Data Solutions Consultant role is expected to empower clients in unlocking the value of their data through effective alignment of business needs with technical capabilities.
Requirements
- Advanced SQL proficiency for data exploration and transformation.
- Familiarity with data warehouse environments (Snowflake, MS SQL).
- Understanding of data modeling, normalization, and CRM ecosystems (Salesforce, Veeva, HubSpot).
- Experience documenting transformation logic and integration workflows.
- Bonus: Knowledge of Python, API data structures (JSON/XML), and AI/ML feature engineering.
- Experience with data validation and reconciliation.
- Understanding of data quality and lineage in healthcare ecosystems.
Responsibilities
- Lead technical discovery sessions with clients to assess workflows, CRM data (e.g., Salesforce, Veeva), and backend data systems.
- Develop and execute SQL queries and BI reports to explore, validate, and reconcile client data.
- Design and document data mapping between client objects and internal data models, defining transformation and normalization logic.
- Translate client business requirements into clear, actionable technical specifications for engineering teams.
- Review and validate code outputs and workflow logic to ensure alignment with design requirements and data accuracy.
- Produce technical and client-facing documentation explaining data flow, logic, and solution design.
- Provide quality assurance (QA/QC) oversight for data transformations, ensuring completeness, integrity, and reliability.
Other
- Bachelor's degree in Healthcare Informatics, Statistics, Data Science, Computer Science, Information Systems, Business Analytics, or equivalent experience.
- 4–7 years in data integration, analytics, or client-facing roles.
- Ability to lead client discovery sessions and map business objectives to data capabilities.
- Strong communication skills for bridging business and technical teams.
- Experience creating clear documentation for clients and engineers.
