Job Description

<div>
 <strong>
  About The Company
  <br/>
  <br/>
 </strong>
 Our client is a leading private equity firm with over $85 billion in AUM. With more than 250 companies, their portfolio is extremely diverse, and have offices located in the US and internationally. They are looking to hire a Data Analyst/Developer to join their headquarters in NYC.
 <br/>
 <br/>
 <strong>
  Responsibilities
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Work on several data warehousing, integration, reporting, and reference data projects
  </li>
  <li>
   Maintain and support ongoing enhancements to existing data pipeline/warehouse/tabular model and associated PowerBI reports
  </li>
  <li>
   Work with the architects and developers providing strong data analysis to determine business objectives
  </li>
  <li>
   Ensure data governance and data integrity through setting up workflows and pipelines
  </li>
  <li>
   Basic data modelling and table design, importing, cleansing, transforming, and validating of data through manual and batch processes
  </li>
  <li>
   Support existing data pulls and integrations from SharePoint, iLevel and other Cloud-based systems using .Net APIs
  </li>
  <li>
   Build new aggregations of diverse data sources into a single repository
  </li>
  <li>
   Data manipulation and cleansing of large excel spreadsheets
  </li>
  <li>
   SQL querying and pivot table/chart creation in excel against the data source
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Requirements
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   3+ years&rsquo; experience in a Data Analyst/Developer focused role
  </li>
  <li>
   Strong SQL skills
  </li>
  <li>
   Strong data modeling and database design skills
  </li>
  <li>
   Strong Excel skills including report generation and VBA coding in Excel
  </li>
  <li>
   Experience working in an Agile environment, bi-weekly sprint schedule preferred
  </li>
  <li>
   Basic knowledge of Visual Studio and .Net/C# coding, able to create a simple application
  </li>
  <li>
   Understand data management, data structures and self-service reporting
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Pluses
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Experience working with PowerBI
  </li>
  <li>
   Understanding of OLAP and MDX querying
  </li>
  <li>
   Experience working with ETL tools such as SSIS
  </li>
  <li>
   Reference data project experience
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Salary Range
  <br/>
  <br/>
 </strong>
 $120,000 &ndash; $160,000
 <br/>
 <br/>
</div>