[Active Hring] Data Engineer - Junior

At Gensler, we design for people. We leverage our global perspective and local presence to innovate at every scale. We’re not just designers—we’re tinkerers, craftspeople, visionaries, and thought leaders. Fueled by passion and entrepreneurial spirit, our people bring new ideas forward to solve the world’s most challenging problems, designing a more resilient, inclusive, and equitable future for our communities and cities. Gensler’s global marketing and brand communications studio is a multi-disciplinary content team that elevates the work, people, and ideas of the world’s foremost architecture and design firm through bold creativity and brand innovation. We are a radically collaborative team of storytellers, media strategists, marketers, and designers who bring our mission and purpose to life through compelling narratives that grow the firm and attract the world’s top talent. Your Role As a Junior Data Engineer in the Gensler Research Institute, you will work closely with the Institutes’ team of researchers, data analysts, and communications professionals to implement and manage content in our data store, and to develop tools that allow Gensler practitioners to interact with the data. This includes building Tableau and/or Power BI dashboards as well as supporting the Institute’s SharePoint library. This role’s initial focus will be on major strategic initiative to assemble the database for major, exploratory research projects focused on the future of cities, workplaces, consumer experiences, etc around the globe. In addition to working closely with the Institute’s team, you will also work closely with Gensler’s data platform and information technology teams to ensure tools and processes fully leverage Gensler’s data infrastructure and are built for ongoing evolution and maintenance. Qualified candidates should be collaborative, flexible, self-motivated, quick learners, and have an entrepreneurial spirit. What You Will Do

• 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.
• To the extent possible, provide advice and technical support related to our various research tools for other GRI members and Gensler practitioners.

Your Qualifications

• Bachelor’s degree in Computer Science or a related field, with 2+ years of relevant experience, or a Master’s degree in a related field.
• 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
• 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

Preferred

• Familiarity with GIS tools such as ArcGIS or PostGIS
• Familiarity with a data blending tool like Alteryx
• Experience with MS Azure cloud platform services including Azure BLOB storage, Azure Databricks, Azure Data Lake Storage, Azure SQL database and Azure SQL Datawarehouse
• Experience with Spark and/or Trino SQL
• Experience using NLP tools, libraries, and models
• R programming experience
• The compensation range for this role is estimated to be between $95-105k plus bonuses and benefits and contingent on relevant experience.

Life at Gensler We encourage our employees to lead a healthy and balanced life. Our comprehensive benefits include medical, dental, vision, disability and wellness programs. We also offer profit sharing and twice annual bonus opportunities. As part of the firm’s commitment to licensure and professional development, Gensler offers reimbursement for certain professional licenses and associated renewals and exam fees. In addition, we reimburse tuition for certain eligible programs or classes. We view our professional development programs as strategic investments in our future.