What are the responsibilities and job description for the Power BI Consultant position at Kaizen Technologies?
Title: Power BI Developer
Location: Iselin NJ (Need Onsite day 1, Hybrid 3 days from office).
Duration: Contract
Only local candidates and independent candidates are required
Recent Capital market / Financial Services / Banking experience is MUST
This position is for a Power BI Developer with a robust background in SQL and data warehousing for enterprise-level systems. The ideal candidate must possess strong Power BI skills, particularly in developing dashboards and canned reports. The role involves designing and developing reports, dashboards, and ad-hoc queries. The candidate should be comfortable collaborating with business users and exhibit business analyst expertise.
Responsibilities:
Design and develop reports, dashboards, and ad-hoc queries.
Collaborate with business users to understand and meet their requirements.
Utilize data modeling techniques using Power Query/Power Pivot.
Develop and optimize DAX queries.
Use Power BI Report Builder and/or create Paginated Reports.
Manage and query SQL Server or any other relational databases.
Requirements:
Minimum of 10 years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.
At least 5 years of experience in relational and multi-dimensional (OLAP) data modeling.
Proficiency in SQL, including relational and dimensional database structures and query optimization.
Strong knowledge of Fixed Income, Equity, and Derivative businesses.
Ability to analyze user requirements, make recommendations, and implement solutions.
Self-driven with the ability to troubleshoot and provide quick resolutions to issues.
Experience with full project management and development life cycle.
Strong oral and written communication skills.
Strong presentation and interpersonal skills.
Ability to prioritize and manage tasks in a high-pressure environment.
Data modeling using Power Query/Power Pivot.
Proficiency in DAX.
Experience with Power BI Report Builder and/or Paginated Reports.
Strong SQL skills, particularly with SQL Server or similar relational databases.
Nice-to-Have Skills:
Working knowledge of Data Flows.
Experience with PBRS (Power BI Report Server).
Familiarity with Power On.
Experience with Snowflake data warehouse.