Gensler is a global architecture, design, and planning firm with 53 locations and more than 7,000 professionals networked across the Americas, Europe, Greater China, Asia Pacific, and the Middle East. Founded in 1965, the firm works globally with more than 4,000 clients across more than 29 practice areas spanning the work, lifestyle, community, and health sectors.

Everything we do is guided by our mission: To create a better world through the power of design.

We believe the power of design can spark positive change and create a future that promotes equity, resilience, and wellbeing for everyone.

The Data Platform Integrations Team in our Oakland office has a key position available for a data analyst with SQL experience and background in data. In this position, you will have the opportunity to wear many hats and to learn a wide variety of technologies. This role is part of the Data Platform Group which owns traditional duties such as analyzing the data for our internal Gensler applications, reporting via Tableau or Power-BI dashboards, and analyzing data across multiple application databases. Cross collaboration with other teams such as IT, HR, Marketing or Finance will be required. We are looking for candidates who are ready to roll up their sleeves and solve problems.

What You Will Do

• Analyze performance of Gensler Core Data processes and work with data owners to improve performance
• Write T-SQL queries to investigate data issues and drive resolution
• Develop Tableau and or Power BI dashboards for operational reporting
• Create alerts to notify on call teams on operational issues
• Assist QA teams in data testing reports and automating testing of reports and applications
• Collaborate with peers in HR, Marketing, Finance and Data Platform to provide solutions to the customer's problems while working closely with QA and Reporting.
• Reproducing internal customer data issues, including orchestrating meetings to resolve issues

Your Qualifications

• Bachelor’s degree or foreign equivalent in Computer Science or related field and minimum of 2 years of experience in job offered or a related position
• Experience writing complex SQL Statements to perform data investigations is required
• Experience with Data Engineering tools like SSIS, Snaplogic, etc., is a plus.
• Experience with reporting tools such as Tableau or Power BI, is a plus
• Knowledge of a scripting language such as PowerShell or Python, is a plus
• Programming and debugging skills are an advantage
• A passion for working with customers and a strong ability and desire to handle technical issues with varying levels of complexity
• Ability to work independently, learn quickly and be proactive
• Excellent English verbal and written communication skills
• Ability to work off hours on occasion