Business Analyst at Skidmore, Owings & Merrill LLP in New York, New York

Job Description:

At SOM, we are a collective committed to shaping a better future for our clients, communities and planet. We aspire to create the most sustainable, impactful work through creative, interdisciplinary teams with all the resources and diversity of a global firm.  We value those who are passionate about excellence, innovation, integrity, inclusivity, and collaboration.  Together we can achieve great things.

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.

Are you ready to join a team of creative professionals working on transformational projects around the world? Take advantage of this exciting opportunity to build a better future with SOM. 

Our Benefits:
 

Health and Wellness: Medical, dental, vision, disability, and life & accident insurance.

Savings: 401K matching, pre-tax spending accounts, and employee discount programs.

Work/Life Balance: Hybrid/Flexible schedules, paid family leave, paid vacation, backup child and elder care, and an employee assistance program.

Professional Development: Reimbursement for professional licenses, associated renewals, and exam fees as well as specialized in-house career development. 

Compensation for this role is based upon experience, qualifications, location, and education and typically ranges from $100,000 to $115,000.

Our Culture:

Our creative, interdisciplinary teams work like small, dynamic studios, with all the resources and diversity of a global firm. Here, you’ll collaborate with industry experts on some of the most exciting and transformative architecture, engineering, and planning projects in the world.

We believe an inclusive environment improves our teams, our firm, and our communities and are passionate about Diversity, Equity, and Inclusion. Our DEI Action Plan was created to bring meaningful change to our profession, starting with our own culture and practices. 

We are proud to be an equal opportunity and affirmative action employer. (Visit this page) to learn more about SOM's employment policy as well as additional information such as a privacy notice for California residents and how to apply offline.

For more about SOM: www.som.com

Portfolios must be submitted for all design positions (Architecture, Interiors, Planning, etc). Applications without work samples will not be reviewed.  Portfolios should be one PDF attachment, 10-20 pages, maximum 5 MB. Submit portfolios as part of your application in the section where the application asks you for your Resume or CV.