Software Engineer I - Data

Position Summary:

The candidate will be responsible for the configuration and delivery of client-facing applications.  The candidate may assist with support for the development of process enhancements under the guidance of the Sr. Software Engineer and the Manager, Technical Operations. Responsibilities will also include day-to-day maintenance of the health care application systems in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation, root cause analysis, manage communication and client relationship management in partnership with Infrastructure Service Support team members. 

Essential Functions of the Job include but are not limited to:

• Prepare, transform, and structure client‑specific data exactly as per requirements gathered by Engagement and Product teams, while adhering to Medical, Legal, and Regulatory (MLR) guidelines.
• Design, generate, and maintain baseline and customised messaging datasets (categories, key messages, content, footnotes, metadata) used across IVA client demos, frameworks, and productions.
• Process and integrate data received from multiple third‑party vendors per client, applying business logic and transformation rules to produce client‑ready datasets.
• Represent the Data Operations / Data Engineering function on all active client and product initiatives.
• Participate in daily data operations and development stand‑up meetings to review data readiness, defects, transformations, and deployments.
• Follow established change‑management procedures for data updates, transformations, and environment promotions.
• Document and maintain data pipelines, transformation logic, and data standard operating procedures (SOPs).
• Create and maintain WIKI articles for reusable data processes, transformation patterns, and troubleshooting guides.
• Coordinate with Application Development, Product, and Front‑End teams to ensure data structures, tags (BR, span, classes), and attributes are optimized for UI rendering and configurability.
• Support and execute data deployments across multiple environments (Development, UAT, Production) using Octopus Deploy and controlled release processes.
• Manage and validate data flows from Goliath servers to Core servers and ultimately into Salesforce via stored procedures and Boomi ETL workflows.
• Set up and maintain data configurations for new client implementations, including environment‑specific data variations and vendor inputs.
• Assist in developing and maintaining automated data validation checks and regression test datasets to support future testing efforts.
• Measure and track data‑related KPIs such as data quality metrics, transformation accuracy, defect leakage, re‑processing rates, and turnaround times.

Future Functions of the Job include but are not limited to:

• Work closely with Product and Platform teams to support new data‑driven features, enhancements, and messaging capabilities.
• Ensure all data changes align with defined lifecycle methodologies, auditability requirements, and risk guidelines.
• Actively collaborate with end users, internal stakeholders, front‑end developers, external vendors, data analysts, and Engagement teams to resolve data issues and drive continuous improvement.
• Contribute to the evolution of scalable, reusable data models and messaging frameworks across products.

Minimum Required:

• Bachelor’s degree in Technology, Engineering, Data Science, Computer Science, or equivalent discipline.
• 1–3 years of experience in a data‑centric role such as Data Engineer, Data Analyst, Application Support (Data), or ETL / Integration role.
• Strong working knowledge of SQL and experience writing complex queries, stored procedures, and data validation logic.
• Hands‑on experience with data transformation and processing using SQL, scripting, or backend technologies (.NET / C#).
• Experience working with relational databases (SQL Server preferred).
• Understanding of Agile development methodologies and sprint‑based delivery.
• Experience with multi‑environment data handling (Dev, UAT, Prod).
• Operational knowledge of Azure DevOps, Team Foundation Server, Octopus Deploy, or similar tools.
• Basic understanding of HTML, tags, and structured content to support front‑end rendering requirements.
• Exposure to continuous integration and deployment concepts, especially for data pipelines.
• Experience with Salesforce or Veeva CRM data models is a plus.

Other Required:

• Working knowledge of US Healthcare or Market Access data concepts is a strong advantage.
• Familiarity with Azure hosting components and data‑related services.
• Ability to analyse and reconcile large datasets from multiple vendors and sources.
• May require domestic and/or international travel, including overnight stays, up to 5%.

Preferred Skills:

• Experience with ETL/ELT tools such as Boomi, SSIS, or similar integration platforms.
• Experience working with complex data models supporting front‑end applications.
• Knowledge of C#, .NET, or scripting used for data processing and transformation logic.
• Experience supporting Salesforce data integrations and environment‑specific configurations.
• Understanding of healthcare data standards and structures (HL7, FHIR preferred).
• Experience designing scalable, reusable, enterprise‑grade data solutions.
• Exposure to workflow engines and message‑driven architectures.
• Experience working with message queues or event‑based data processing.
• Strong analytical and problem‑solving skills with attention to detail and data quality.

Soft Skills:

• Communication Skills - Written, Verbal, and Presentation: The successful candidate must have the ability to read, analyze, and interpret production data, financial reports, and legal documents. Excellent verbal, written, presentation, interpersonal skills including ability to clearly respond to common inquiries or complaints from customers, employees, and members of the business community. Must possess a rapid agility to reply to emails, provide instructions of work stream necessities or issues encountered, business and report writings in a succinct and informative manner
• Business Judgment and Strategic Thinking: Ability to think, act, and deliver value in the best interest of our clients with respect to common practices of the healthcare consulting field. Ability to extrapolate from the specific to the general and interpret from the general to the specific
• Analytic Skills: Framing macro problems into action steps or work plans for resolutions. Structuring a persuasive client presentation based on in-depth or expansive excel spreadsheets. Demonstrable interpretive and solution identification skills with the ability to understand multiple types of quantitative and qualitative data heightened with strong resolution skills
• Collaboration and Teamwork: Ability to give and receive constructive feedback and work effectively across the organization to accomplish team goals is critical. The successful candidate must possess excellent judgment, management, and conflict resolution skills. Ability to work with team members to convey results, incorporate enhancements and productionize processes across projects
• Must be able to understand the dynamics of how a team interconnects and relies upon every member.
• Strategic Thinking: Conceptualize outside of the aspects of a project at hand, with an ability to visualize how the work contributes to and drives forward the overall project
• Solutions oriented: must be able to display resourcefulness and confidence under pressure
• Resilience: must be able to look past obstacles and roadblocks, ask questions and for support, and find their way around any obstacle