• Write, debug, and optimize complex SQL queries to extract, aggregate, and analyze massive sets of automotive marketing and inventory data. • Investigate and resolve specific data logic issues assigned via HubSpot and Jira, such as tracking down historical CRM and data discrepancies. • Audit and standardize large external data sets to ensure data cleanliness before reporting. • Build, update, and maintain client-facing dashboards and reports within our BI environments, working strictly to the product vision outlined by the team lead. • Perform rigorous QA on data sets and reports to ensure flawless deliverables for our Customer Success (CS) team. • Collaborate with the US-based reporting team via daily stand-ups to clear the analytical backlog and fulfill ad-hoc data requests.

• Analyze cost trends, issues and opportunities for a global data center portfolio • Provide insights and/or recommendations based on analysis to facilitate internal initiatives • Identify ways to improve and streamline processes with the use of software tools and/or automation • Review contractor and subcontractor pricing against benchmarks • Develop and maintain project cashflow forecasts and accruals on a monthly basis • Analyze project budgets against program-wide benchmarks and ongoing cost trends • Support the client in compiling information required for capital planning requests

• Analyze cost trends, issues and opportunities for a global data center portfolio. • Projects are across various regions, in different construction stages and ranging from small colocation fit-out to large hyperscale lease. • You will likely perform a variety of analyses such as benchmarking, trend identification, growth forecasting to add value to problem-solving discussions. • Provide insights and/or recommendations based on analysis to facilitate internal initiatives. • Ability to present analysis findings in a clear concise and professional manner. • Identify ways to improve and streamline processes with the use of software tools and/or automation. • Review contractor and subcontractor pricing against benchmarks, including identifying and negotiating outliers. • Develop and maintain project cashflow forecasts and accruals on a monthly basis. • Analyze project budgets against program-wide benchmarks and ongoing cost trends. • If necessary, provide recommendations to the client on project funding needs based on those benchmarks and cost trends. • Support the client in compiling information required for capital planning requests (funding).

• Analyze cost trends, issues and opportunities for a global data center portfolio. • Provide insights and/or recommendations based on analysis to facilitate internal initiatives. • Ability to present analysis findings in a clear concise and professional manner. • Identify ways to improve and streamline processes with the use of software tools and/or automation. • Review contractor and subcontractor pricing against benchmarks, including identifying and negotiating outliers. • Develop and maintain project cashflow forecasts and accruals on a monthly basis.