Dingyi North America Seattle LLC


Business Intelligence Analyst


Full Time

Olympia, US

Posted a week ago

About the Job

Salary - $62700 - $62700/Year

We require the Business Intelligence Analyst to produce financial and market intelligence and generate various reports by utilizing business intelligence querying, analysis, and reporting skills and approaches in order to support both the cross-function analytical and research work and decision-making process. Specifically, we require the Business Intelligence Analyst to provide reporting and analytical support for furthering our parent company, Dingyi investment group’s footprint in the Northwest America region. This role needs to support cross-function efforts within the entire organization, including investment operations of the headquarters, through devising, expansion and enhancement of the BI toolkit to support and deepen analytical capabilities, and contributing to targeted initiatives through producing business intelligence concerning industry, market and financial realm to help the higher management gain more insights and make better and faster decisions.

· Utilize platforms like Bloomberg, PitchBook, and Crunchbase to gain access to data of investment targets and target industries, and utilize business intelligence tools including SQL and Oracle to crawl real time financial data.

· Import, validate, and organize asset level data/cash flows using Microsoft Excel, Power BI or Tableau.

· Clean and unify messy and complex raw data sets for easy access and analysis, and use summarization tools such as Pivot Table to automatically condense large datasets into a separate, concise table in order to deliver powerful business insights.

· Produce the business trend data through conducting horizontal analysis of the investment target and interpret the change in financial statements over two or more accounting periods based on the historical data, and prepare data dashboards for VP/executive review through visualizing e comparison using Microsoft BI.

· Design, maintain and update real-time data and dynamic dashboards, and using them to perform ad hoc summary analysis and create autonomous reports

· Provide insights on data trends and anomalies using Microsoft Power BI to support recommendations for equity investment.

· Use Oracle business intelligence to Improve data accuracy, gain better visibility into financial and operational information, share data and increase communication efficiency with respective departments in headquarters.

· Conduct competitive advantage analysis against other key market players, and critical regulatory influences on the target sector to identify the trends so that to provide support in evaluating risk and feasibility of an investment.

· Monitor the business trend data such as capital spending and visualize expense trends and individual expense components using Microsoft BI, and report to the company’s management regarding the area of expenses that could be reduced and increase efficiency of operating using business intelligence tools.

· Identify and analyze industry, geographic, technical trends for the current and potential investment opportunity.

· Provide ad-hoc support on advanced analytical requests and help educate stakeholders on data best practices.

Minimum job requirements

Bachelor’s degree in business management, economics or closely related field.

  • 2 years’ experience of doing financial analysis in equity investment in the field of real estate.
  • 2 years’ experience in using Excel (pivot tables, solver), Microsoft Power BI
  • 2 years’ work experience with business intelligence tools (Power BI, Tableau, SQL.)
  • 2 years’ experience in working with research platform (Pitchbook, Crunchbase, Bloomberg terminal, Costar) to crawl data from
  • 2 years’ experience in data modeling to support evaluating feasibility of investment and defining/measuring the success of those initiatives.

Job Type: Full-time

Pay: $62,700.00 per year


  • Paid time off


  • Monday to Friday

Ability to commute/relocate:

  • Olympia, WA 98501: Reliably commute or planning to relocate before starting work (Required)


  • SQL: 2 years (Preferred)

Work Location: One location

Posted a week ago

See More Relevant Jobs

Network engineer

Computer Science
Englewood, us
Posted this week

Sr. Software Developer (Virtual), Security Products

Computer Science
Remote, US
Posted this week

Principal Software Engineer - BackEnd (US Remote)

Computer Science
Seattle, US
Posted this week

Landing Jobs in the US for International Students just got super easy

Learn how to network, prepare visa interviews and sure shot strategies to kickstart your career in the USA.

Know More