What are the responsibilities and job description for the Business Intelligence Consultant position at Kaav Inc?
Job Title: Senior Power BI Developer (Banking Background) Databricks
Location: (Iselin, NJ) / NYC – 3 days/week onsite
Duration: 12 Months
Note: Inperson interview reqd
Job Description:
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.
Must-Have Skills:
Data modelling 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.
Qualifications:
Minimum of 7 years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.
At least 3 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.