Data & Analytics Specialist

Vollzeit
Chicago, IL, USA
vor 2 Wochen

We are trusted investment banking advisors to business owners and senior executives of leading private equity firms and public and privately held companies around the world. Our services include mergers and acquisitions advisory, private funds and capital markets advisory, and valuation and fairness opinions. As one tightly integrated team of more than 1,000 professionals across 15 countries, we offer an unmatched perspective on the global private capital markets, backed by superb execution and a deep commitment to client success. With extensive industry knowledge and relationships, timely market intelligence and strategic insights, we forge deep, productive client relationships that endure for decades. Learn more at www.lincolninternational.com.

At Lincoln International, we know that the success of our global organization is a direct outcome of the strength of our people. We encourage diversity of thought and create talent density by attracting, retaining and engaging high performers from all demographics, backgrounds and perspectives. We value diversity, equity and inclusion as a catalyst to foster innovation and creative problem solving, access the best candidates and adapt to a highly dynamic, competitive environment. We know that employing a diverse team and valuing the unique perspectives of our people allows us to better understand and serve the needs of our clients.

Lincoln International is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We encourage you to read more about our commitment to diversity and Environmental, Social & Governance (ESG) efforts.

Lincoln International follows a hybrid work structure with an emphasis on in office collaboration.Our employees work in our Chicago office Monday through Thursday each week, with the option to work remotely or from the office on Fridays. Our office is located at 110 N Wacker Drive, just blocks from Union Station & Ogilvie Transportation Center.

Duties & Responsibilities:

The Data & Analytics Specialist position at Lincoln provides an excellent opportunity to work in a demanding, yet supportive, team-oriented environment. The Data & Analytics Specialist should have relevant professional experience, be entrepreneurial, poised and able to deal with many different people both inside as well as outside the firm.  Strong communication skills are critical to success in this role.  Lincoln fosters a cohesive and supportive work environment and encourages teamwork.

Based in Chicago, Illinois, the Data & Analytics Specialist will serve as a key member of Lincoln’s Business Enablement team, with the primary role of supporting initiatives related to Lincolns proprietary Private Market Database. The Data & Analytics Specialist will gain a general understanding of Lincoln’s Valuations and Opinions business and of Lincoln’s client base, and a deep understanding of private equity and private credit markets. 

Regular working hours are 8:30 am to 5:00 pm with a 30-minute lunch break. Willingness and ability to work overtime is necessary.

The primary duties are to:

  • Develop and validate internal reporting and data & analytics tools using Power BI and SQL
  • Develop and validate client facing reporting tools using Power BI and SQL
  • Enhance and update existing reporting and data & analytics tools
  • Provide user support for Power BI reporting tools
  • Work directly with Lincoln bankers and clients to understand context and gather requirements
  • Participate in data validation and quality assurance testing as well as data health analysis
  • Participate in database enhancement and data cleaning initiatives
  • Participate in the development of quarterly perspectives about the private credit and equity markets based on analysis of this data
  • Work cross-functionally with other teams within Lincoln to perform business analysis and develop data strategy
  • Assist in execution of strategic technology implementations

Qualifications:

Interested candidates should meet the following requirements:

Professional and Cultural Characteristics:

  • Authentic individual with high integrity, whose personal and professional values are consistent with Lincoln’s Culture Statement (Excellence, Entrepreneurship, Integration, Collaboration, Integrity)
  • Assertive, articulate and self-motivated, can manage multiple tasks and deadlines in a fast-paced environment
  • Strong collaborator who enjoys working in an entrepreneurial environment
  • Driven and ambitious professional who gains satisfaction from achieving personal and team goals
  • Willingness to learn new concepts and technology to enhance and collaborate with teams
  • Ability to interface effectively with all levels of management and banking staff as it relates to reporting and analytics

Other Qualifications:

  • Bachelor’s degree in Management Information Systems, Business Analytics, Finance, Accounting, Computer Science, or related
  • 1 – 2 years of professional experience in a comparable, finance-focused analytical role
  • 1 – 2 years’ experience developing reports in Power BI with large, complex, and/or fragmented datasets
  • Proficiency with SQL
  • Advanced Microsoft Excel capabilities performing data cleansing, manipulation, and analysis
  • Understanding of financial concepts and terminology
  • Excellent written and verbal communication skills
    • Client/Customer facing experience a plus
  • Experience architecting/developing relational databases a plus

Additional Information:

Lincoln International is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status.

#LI-HYBRID#LI-CHI

Click here to view Lincoln International's Candidate Privacy Notice.