PowerBI Data Developer

.NET, API, Ad hoc reporting, Agile, Analytics, Backup administration, Business analysis, Business intelligence, Cloud, DAX, Data QA, Data analysis, Data governance, C#, Data integration, Data management, Data manipulation, Data modeling, Database, Database design, ETL, Financial services, Implementation, Integration, MDX, Metrics, Microsoft Excel, Microsoft Power BI, Microsoft SQL Server, Microsoft SQL Server DBA, Microsoft SSAS, Microsoft SSIS, Microsoft SharePoint, Microsoft TFS, Microsoft Visual Studio, Modeling, Monitoring, OLAP, Perl, Pivot table, Python, Query optimization, RESTful, Recovery, Reporting, SQL, Scripting, Software development, UML, VBA, Warehouse, Windows PowerShell
Full Time
$90,000 - $130,000
Travel not required

Job Description

Our client, a prestigious and highly reputable Private Equity (PE) firm with over $60B in AUM, is seeking a Data Developer to work full-time in NYC! This would be fully onsite after Labor Day in September.

In this role, you will work on a number of data integration and reporting projects. Initially, you will take over the maintenance, support and ongoing enhancements to an existing data pipeline/warehouse/tabular model and associated PowerBI reports.

You will build new aggregations of diverse data sources into a single repository and the generation of reports and adhoc queries on that data. You will also support existing data pulls and integrations from SharePoint, iLevel and other Cloud-based systems using .Net and REST APIs.

Daily Activities Include:

  • Basic data modelling and table design, importing, cleansing, transforming and validating of data through manual and batch processes
  • Data manipulation and cleansing of large Excel spreadsheets
  • SQL querying and pivot table/chart creation in Excel against the data source
  • Hands-on manual data management tasks
  • Work closely with temporary resources doing data input to help improve efficiency and data quality and to streamline ingestion of the data
  • Subsequent projects will expand on all of these responsibilities, as well expanding into the areas of enterprise data modelling, data integration, business intelligence and analytics

Required Skills:

  • Strong SQL skills
  • Strong Excel skills including report generation and VBA coding in Excel
  • Strong data modelling and database design skills
  • SQL server administration experience. Understanding of managing Microsoft SQL Server users, permission, backups, recovery, monitoring
  • Experience with PowerBI, tabular models in SSAS and DAX
  • Understanding of OLAP design and reporting, MDX querying, and knowledge of MS SSAS
  • Knowledge of ETL tools and approaches, preferably SSIS
  • Visual Studio and .Net/C# Coding
  • Source-code Control (preferably TFS), including for database and reporting projects

Preferred Skills:

  • Knowledge of scripting languages such as perl, python, powershell
  • Understanding of database diagnostics, query optimization and tuning
  • Good Business Analysis skills
  • Financial Services experience
  • Experience with Data governance, implementation of data quality processes and metrics
  • UML Modelling

Ideal Experience:

  • 3 – 6 years experience
  • Experienced and comfortable working in a number of different development environments, including, but not limited to, Agile
Dice Id : 10513353
Position Id : 7088016
Originally Posted : 4 months ago
Have a Job? Post it

Similar Positions

Data Engineer - G
  • Next Step Systems
  • New York, NY, USA
Senior Business Intelligence Developer
  • Technology Resource Management
  • Parsippany-Troy Hills, NJ, USA
Java Developer
  • Dice US Sales Demo Account
  • New York, NY, USA
Java Developer (TEST - Do Not Apply)
  • Dice US Sales Demo Account
  • New York, NY, USA
test - do not apply
  • Dice US Sales Demo Account
  • Brooklyn, NY, USA
Data Engineer
  • GalaxE.Solutions
  • Secaucus, NJ, USA
Senior Data Engineer
  • Volvo Cars USA
  • Mahwah, NJ, USA
SQL Server Data Engineer
  • Judge Group, Inc.
  • Bridgewater Township, NJ, USA
Specialist, Financial Analyst, Project Manager, and Data Analyst
  • BNY Mellon Corporation
  • New York, NY, USA