The Gensler Research Institute needs a Junior Data Engineer to implement and manage content in their data store, develop tools for practitioners to interact with data, and build dashboards for major research projects focused on the future of cities, workplaces, and consumer experiences.
Requirements
- Excellent programming skills in Python.
- Experience working with relational databases writing high quality, maintainable SQL on large datasets
- Experience with scalable ETL/integration pipelines using an enterprise level ETL/Integration tool like SnapLogic, Azure Data factory, Informatica, Talend, SSIS etc.
- Intermediate/Advanced level skills in designing dashboards using Tableau and/or Power BI
- Familiarity with NLP concepts such as sentiment analysis, tokenization, and embeddings
- Familiarity with GIS tools such as ArcGIS or PostGIS
- Experience with Spark and/or Trino SQL
Responsibilities
- Design database schemas and collaborate with both internal engineers and external consultants to build out databases in our data store.
- Design scalable ETL processes and data processing workflows and oversee their implementation.
- Design processes and provide support to ensure data quality and maintenance.
- Prepare aggregated data sources for reporting and create clear and attractive dashboards in Tableau and Power BI.
- Help maintain GRI’s SharePoint sites and related Power Apps tools.
- Address questions and concerns from downstream data consumers
- Work closely with researchers, analysts, and writers to make sure data tools and products clearly address their needs.
Other
- This position is based onsite 5 days a week out of either our New York or Washington, DC office.
- Effective communication, troubleshooting, and organizational skills and the ability to complete assigned work with minimal supervision
- Strong behavioral skills including but not limited to problem-solving, work prioritization, communication, self-direction, and time management
- Willingness to learn recent technologies and innovative ways of approaching projects.
- High tolerance for messy data and processes
