SOM, one of the most influential design firms in the world, is seeking innovative, creative, independent, and critical thinkers who aspire to the highest standards of excellence. Join our collaborative design practice as a Finance Analytics Engineer for the opportunity to build a strong and thriving career.

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.

An emerging role within SOM, the Finance Analytics Engineer will work closely with the Global Analytics leader and CFO to carry out a thorough data analytics strategy strategy - incorporating data engineering, data manipulation, standardization and process creation, documentation. This person will have an opportunity to influence design and implementation of a financial data warehouse and a highly visible data reporting strategy.

The primary responsibility for this role will be to implement and oversee a data analytics and reporting strategy as it pertains to financial and business reporting. This includes implementing best practices, training analysts, and ensuring a high-level of data quality and control.

The ideal candidate will have significant experience (5+ years) with business intelligence, data warehouse technologies, and web service APIs. This is a hands-on role that requires both analytical and technical skills. The ideal candidate is a strong technologist able to conceive and implement full-scale projects with large impacts start to finish.

Position Responsibilities

• Leading a data analytics strategy - including implementing best practice process and procedures, leading a financial data warehousing project, collaborating with the Office of Technology on the analytics pipeline as it relates to financial data, and maximizing our usage of third-party tools, such as visualization software.

• Creating analytical models and in-depth analyses rooted in a strategic data approach and visualization and reporting best practices.

• Implementing automation and utilizing streamlined reporting where to improve functionality and efficiency of all team members.

• Identifying opportunities for improvement - through process/procedure, strategic use of data, upgraded systems development, improved reporting or otherwise - and create project plans that will address these issues.

• Developing error and qa/qc reporting as necessary to ensure data quality throughout all of the financial and business reporting.

• Working with multiple end-user groups, such as finance, accounting, leadership or marketing, to develop reporting and analysis programs.

• Synthesizing business needs and creating business process maps used to build analysis and data models.

• Fostering the development of a data culture - helping internal teams and clients make user­-driven, evidence-based decisions around finance, business strategy, marketing, and workforce.

Minimum Qualifications

• Experienced in working on/with projects/products that utilize big data and advanced analytics technologies. Be comfortable and knowledgeable of a wide range of data warehouse technologies, including MySQL.

• Demonstrated ability to solve large and complex application problems independently. 

• Experienced in project management and proven capability to design and implement complex projects.

• Expert SQL ability and proficiency with 1+ programming language (R or Python preferred)

• Experience using data exploration and visualization tools (ex. Tableau, PowerBI, Cognos, R, Excel).

• Strong knowledge of financial terminology, business model and trends around a professional service business. 

• 5 years of work experience working with ERP, Deltek Vision preferred. Experience with Salesforce CRM, as well as marketing automation is a plus.

• Bachelor’s degree or equivalent work experience.

• Minimum 5 years of work experience working in data engineering, analytics or related field of practice.

• May require light travel (10%)

SOM offers opportunities to work on transformational projects, competitive salaries, health insurance, wellness, retirement and financial and other work/life plans.

At SOM, we welcome and encourage diversity in the workplace. We believe an inclusive environment benefits our employees, our firm, and our community, while also enriching and challenging our own thinking about design. We are proud to be an equal opportunity and affirmative action employer. Visit this page to learn more about SOM's employment policy and how to apply offline: www.som.com/employment_opportunities_and_policy

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.