> Markdown version of [/jobs/ext/491825-data-engineer-fellow](https://www.wearedevelopers.com/jobs/ext/491825-data-engineer-fellow). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer Fellow - **Company:** Hispanic Health Council - **Location:** Hartford, CT, United States - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Geographic Information Systems, Artificial Intelligence, BigQuery, Cloud Database, Information Systems, Data Governance, Extract Transform Load (ETL), Data Structures, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, Federal Information Processing Standards (FIPS), Python (Programming Language), Machine Learning, Metadata, SQL Databases, Data Processing, Scripting, Information Technology - **Published:** June 7, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=589e6ee256cc4061 ## About the Role Do you have experience in Query management?, Do you have a Bachelor's degree?, + Bachelor's degree (completed or in progress) in Computer Science, Data Science, Information Systems, Statistics, or related field + Demonstrated proficiency in SQL, including joins, aggregations, and table creation (DDL) + Experience working with structured datasets (CSV, Excel, relational tables) + Experience cleaning, transforming, and standardizing data + Basic proficiency in Python (or similar scripting language) for data processing + Familiarity with geographic identifiers (e.g., FIPS, GEOID) or demonstrated ability to work with geographic data structures + Strong analytical and problem-solving skills + Ability to document data transformations and assumptions clearly + Ability to work independently and meet defined project milestones Preferred Qualifications: * + Experience working with cloud data warehouses e.g., BigQuery. + Experience designing relational schemas or dimensional models (e.g., fact and dimension tables) + Experience integrating public-sector datasets (e.g., Census, CDC, CMS, BLS) + Experience building or supporting ETL/ELT workflows + Familiarity with data governance concepts (metadata, lineage, documentation practices) + Exposure to AI/ML concepts or interest in applying AI techniques to structured population health datasets + Experience using AI-assisted data tools for cleaning or query generation + Interest in contributing to AI-enabled analytics built on top of structured data foundations, The ideal candidate demonstrates strong SQL proficiency and practical experience designing scalable relational schemas within a cloud-based data warehouse environment. They possess the ability to clean, standardize, and integrate structured public datasets across mixed geographies and time dimensions. The Fellow is detail-oriented, execution-driven, and capable of building reliable, well-documented data structures that support visualization, research analysis, and future AI-enabled analytics aligned with NHHRI's long-term objectives. ## Description As a Data Engineer Fellow, you will support the development and maintenance of NHHRI's cloud-based population health data warehouse by designing scalable schemas, integrating public-sector datasets, and ensuring data quality and reliability. NHHRI seeks a Data Engineer Fellow to design and implement relational structures within the organization's BigQuery environment. The Fellow will standardize, clean, and integrate federal and state datasets into a governed warehouse framework, supporting board reporting, research analysis, and future AI-enabled analytics. This role focuses on building the structured data foundation that enables visualization, research, and strategic decision-making., * + Design and implement scalable relational schemas in BigQuery + Develop and maintain core reference tables (e.g., dim_geography, dim_time) + Build and maintain standardized fact tables for integrated indicators + Load, clean, and standardize federal and state datasets + Harmonize mixed geographic levels (state, county, tract, ZIP as applicable) + Transform datasets into consistent long-format structures where appropriate + Write validation and quality-control SQL queries + Optimize tables using partitioning and clustering strategies + Monitor query efficiency and usage + Maintain organized raw, staging, and curated data structures + Document schema design decisions and transformation logic + Support reproducibility and governance standards + Collaborate with Visualization and Research Fellows to ensure consistent metric definitions. * NOTE: It's an unpaid fellowship. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top 6 Hackathons for Developers in 2023](https://www.wearedevelopers.com/magazine/263-top-6-hackathons-for-developers-in-2023)