Data Engineer I (R-19886)

The Data Engineer I work as part of an agile team supporting the organization's Research and Managed Services. This is a hands-on, hybrid, technical, and operational role. The team members will actively write and maintain code to build data tools, automations, and pipelines, while also performing day-to-day operational tasks that keep Research and Managed Services running reliably. The role includes identifying and evaluating internal and external data sources to feed AI-enabled and traditional research workflows. The team member will assess source relevance, quality, coverage, accessibility, reliability, compliance considerations, and applicability to defined business and technical use cases. The role drives best-in-class standards and continuous improvement and requires an adaptable professional who is willing and able to learn and adopt new technologies as they are introduced to the organization

Key Responsibilities:

Coding & Development
Write, review, test, and maintain code, including SQL and Python, to build data tools, automations, and ingestion and transformation workflows that support Research and Managed Services
Automate manual processes and develop data tools to improve efficiency, accuracy, quality, and throughput
Develop and promote coding standards and contribute to code reviews within the agile team
Build and maintain web-scraping solutions, API integrations, and reusable data-processing components
Support scalable ETL/ELT pipelines for structured and unstructured data
Source Evaluation & AI Enablement
Identify prospective sources that can feed AI solutions and Research and Managed Services workflows
Define and apply source-evaluation criteria covering relevance, authority, freshness, completeness, coverage, consistency, accessibility, legal or licensing constraints, privacy, security, and technical compatibility
Perform source profiling, sample validation, proof-of-concept testing, and comparative assessments before recommending onboarding
Document source decisions, metadata, lineage, ownership, limitations, refresh expectations, and approved use cases
Implement and support AI-enabled workflows using LangChain or equivalent orchestration frameworks, large language models, embeddings, retrieval-augmented generation, vector databases, and prompt-engineering approaches where applicable
Monitor source and AI-workflow performance and recommend remediation, replacement, or additional sources when quality or coverage falls below requirements
Operational Tasks
Perform day-to-day operational activities supporting Research and Managed Services, including monitoring, exception handling, data maintenance, and issue resolution
Perform database administration activities, including performance tuning and implementation of best practices
Implement new data-maintenance processes and provide end-to-end process ownership
Ensure data integrity by validating, reconciling, and regularly cleaning data
Investigate and resolve production incidents, pipeline failures, data-quality issues, and operational exceptions
Follow applicable data governance, security, and operational standards
Collaboration & Continuous Learning
Evaluate and implement new technology solutions, and proactively learn and adopt new tools, platforms, and methodologies introduced by the organization
Communicate with stakeholders and conduct knowledge-exchange sessions for technical and non-technical audiences
Develop and maintain data documentation, including data dictionaries, source assessments, data-flow diagrams, data mappings, runbooks, and data lineage
Collaborate with cross-functional teams across Data & Analytics, Technology, Research Services, Managed Services, Product, and Data Governance
Additional duties as assigned.

Key Skills:

• Strong SQL and Python skills, with demonstrated ability to write and maintain code as a core part of daily work
• Experience with Playwright, Selenium, and other web-data collection techniques
• Experience developing and supporting data-ingestion, transformation, and ETL/ELT workflows
• Ability to collect and interpret data from multiple sources, including web scraping and GCS/S3, and formats including delimited files, XML, JSON, and PDF
• Working knowledge of data systems and databases used to maintain data pipelines
• Experience with Power BI, Tableau, or other dashboard tools
• Experience managing stakeholders and project plans
• Proficiency in Microsoft Office Suite
• Willingness and demonstrated ability to learn new technologies as they are introduced
• BigQuery experience and knowledge of AWS and/or GCP
• Hands-on experience implementing AI solutions using LangChain or an equivalent orchestration framework
• Exposure large language models, prompt engineering, retrieval-augmented generation, embeddings, vector databases, AI agents, or graph databases
• Knowledge of Data Operations methodologies, data management approaches, ServiceNow, and/or Jira
• Experience with NoSQL technologies, SQL Server administration, R programming, web technologies, and data mapping from multiple sources.