Skidmore, Owings & Merrill - Known for creating some of the world’s most technically and environmentally-advanced designs, we are leveraging our collective expertise to build a better future for people, cities, and the planet.

Under the leadership of Carrie Byles, Laura Ettelman, and Xuan Fu, we became a carbon neutral business in 2022 and were named an #Equality100 company by the Human Rights Campaign Foundation's Corporate Equality Index as well as a Woman-forward Workplace finalist by Crain's New York Business in 2023.

Success at SOM Means

• Ideas: We believe in a meritocracy of ideas. We look to everyone to actively contribute to the discourse in the firm.
• Knowledge: We believe that expertise is the result of lifelong learning. We are not expected to know everything, but rather to passionately pursue answers, develop new skills and deepen our knowledge.
• Product: We strive for excellence in the concept, quality, and delivery of our work.
• Individual: We value individuals who bring the highest standards of professionalism and personal integrity in the way they work. Each person can develop and contribute their wealth of attributes, skills and knowledge to support the overall health of the firm.
• Team: We value the power of interdisciplinary integration. A positive team culture in which everyone collaborates openly towards common goals is essential.
• Firm: We have a history of making transformative contributions to the profession and our communities. We are constantly innovating and attempting to bring new approaches, solutions and processes to our work.

Position Responsibilities

• Fulfill a range of duties such as supporting the analytics team on projects with Tableau, SQL and R; interrogating data sets and creating strategic recommendations to develop the firms reporting.
• Ability to handle ad-hoc research and reporting requests, including in depth analysis and problem solving.
• Proficient in creating, updating and running SQL queries.
• Creating dashboards and applying data visualization techniques via Tableau.
• Collaborate with multiple end-user groups to lead cross-functional projects, such as finance, accounting, marketing and business operations, to develop reporting and analysis programs.
• Design, develop and deliver accurate, fast and interactive reporting to key business stakeholders.
• Create and standardize the report request process - tracking requests and working with firmwide leadership on prioritization, approvals and rollouts.
• Ensure data quality, including developing error and qa/qc reporting as necessary.
• Build, develop and maintain data models to optimize system processes. Synthesize business needs and create business process maps used to build analysis and data models.
• Implement automation and utilize streamlined reporting where possible to improve functionality, accuracy and efficiency of all team members.
• Enhancing the data and analytics offering, exploring new techniques and working with tools such as Python and R.

Minimum Qualifications

• Strong data analysis skills.
• A proven ability of analyzing data and using it to create a business advantage.
• Ability to work independently, willingness to take initiative and demonstrated time management in delivering results is a must.
• 3+ years of professional work experience in a business, operational, financial and marketing environment.
• Advanced Tableau proficiency; certification preferred.
• Advanced SQL ability and proficiency with minimum 2+ years utilizing a programming language (R or Python preferred).
• Experience with Salesforce preferred.
• Experience with Deltek Vision or a ERP system a plus.
• Experience with data modeling to design and develop reporting data marts and semantic models with tools such as Tableau, Microsoft SQL Server, Power BI, Excel, R and Google Suite.
• Bachelor’s degree or equivalent work experience.