Data Engineer/BI Developer

Note: This role is open to remote workers. Gensler’s technology office assists clients across the globe with leveraging the value of their real estate data through spatial analytics, interactive tools, and technology. Our fast-paced, innovative office is constantly developing new ways to help clients access and leverage their real estate data. Learn more about our office at www.gensler.com/gis. Your Role We are looking for a talented and versatile Data Engineer / BI Developer who’s passionate about the art and science of data - someone who values data integrity, is skilled at cloud-based data engineering with modern tooling, and is able to create appealing visualizations via reports and dashboards within our B2B SaaS products. We are looking for a self-starter who is happy working independently and with a team. Someone who can communicate with technical and client-facing teams, while maintaining and modernizing our products. What You Will Do Build data pipelines and data models to support our SaaS products Implement auditing and error handling best practices for data pipelines Extend existing pipelines and data models to enable advanced analytics capabilities, including analysis of semi-structured and unstructured data Incorporate new sources of data, both internal and external Collaborate with cross-functional team of software and SQL developers, testers, product managers, client services and IT throughout the software development lifecycle to deliver dynamic, high-quality report and dashboard solutions Understand user personas - their goals and problems - to define, create, build and deploy visualizations in client-facing SaaS products Analyze data and requirements, identify and articulate right-sized solution Provide design options, alternatives and recommendations based on best practices for reporting and dashboard design Develop and maintain a variety of reports and dashboards, including but not limited to tabular, drill down, graphs and charts Utilize existing functions and/or write new statements using SQL and/or Python as appropriate for the creation and maintenance of data visualizations Provide suggestions to enhance current and future product needs Deploy to a multi-environment, multi-server platform Monitor overall data integrity utilizing scheduled processes with automated notifications Apply test-driven development and peer reviews to ensure quality Drive results through feasible estimations and timelines Your Qualifications Degree in Information Systems, Computer Science, Data Science or similar field 5 years professional experience using relational database technologies to optimize and manage large datasets 2 years of Python experience or similar Experience with Azure Data Factory / Azure Synapse Analytics Proficiency with Excel, reporting, business intelligence and dashboard platforms Knowledge and experience utilizing T-SQL and ETL tools Advanced query, data analysis and data visualization skills Analytical with strong attention to detail Proven experience delivering high-quality, client-facing reports and dashboards Self-motivated, organized, collaborative with strong written and verbal communication skills Experience working in an agile development environment An enthusiastic team player, passionate problem solver and great collaborator Preferred Qualifications Experience with Databricks / Delta Lake a plus Experience working within SaaS products also a plus Examples of work (if possible and not proprietary) Life at Gensler Gensler has been providing workplace management SaaS solutions to corporate real estate clients for over 20 years. To meet the changing needs of the workplace, we are creating a powerful suite of digital tools that unite people, place, and performance to enhance how we understand and engage with the workplace. We are looking for talented and passionate candidates to help us design, create, build and support best-in-class workplace experience software. At Gensler, we leverage our global perspective and local presence to innovate at every scale. We’re not just designers. We’re tinkerers, craftspeople, visionaries, innovators and thought leaders. Fueled by passion and entrepreneurial spirit, our people bring new ideas to solve challenging problems. At our core we embody an entrepreneurial spirit, always looking ahead for new ways to innovate and add to our clients' success. We share the belief that design has the power to transform organizations and change lives. Our work reflects an enduring commitment to sustainability, and we believe that a diversity of voices and cultures is one of the most powerful strategic tools for securing lasting competitive advantage. We encourage our employees to be pioneers by emphasizing flexibility, connection, and productivity from the office, home, or anywhere in between. With a team-first mentality, you will be surrounded by colleagues who are committed to helping each other grow, where ongoing feedback flows freely. We encourage every person at Gensler to lead a healthy and balanced life. Our comprehensive benefits include: Retirement: 401k, profit sharing, employee stock ownership Twice annual bonus opportunities Medical Dental Vision Disability Wellness programs Flex spending Paid holidays Paid time off Training and professional development As part of the firm’s commitment to licensure and professional development, Gensler offers reimbursement for certain professional licenses, exam fees, and certain eligible programs or classes. We view our professional development programs as strategic investments in our future.