Jersey City, NJ, United States
January 1, 2023
Apply NowJob description
Fulltime | Direct hire
Location: Jersey City, NJ. (3 days onsite & 2 days remote).
Job Description
Define, implement, and optimize Data layer for Power BI Reports; Build visualizations and dashboards on top of the created data layer.
Design and develop interactive visualizations, reports and dashboards using Power BI desktop connecting to data warehouse.
Performance tuning of Power BI reports, by properly configuring the dataset modes - import mode/direct query etc.
Knowledge of Configuring DB connections on Power BI Servers in Azure.
Setup and manage deployment pipelines for Power BI reports to automate the release life cycle.
Desired Experience
7+ years of experience in developing advanced reports and dashboards.
5+ years of strong hands-on Power BI experience in creating interactive reports against large datasets.
Should be well versed with drill down and drill through techniques.
Ability to understand complex data schemas and create optimized BI data models for reporting needs is a must.
Hands-on experience in architecting Power BI embedding portal is required (authentication/authorization/performance tuning etc.).
Able to implement row level security (RLS) on data and understand application security layer models in Power BI.
Deep understanding of dimensional modeling, enterprise data warehouse and Azure Data Lake.
Practical experience in understanding the capabilities and limitations of Direct Query vs Import Mode.
Experience in data extraction, data modelling, data warehousing and performance optimization.
Experience in managing Azure Power BI dedicated capacity and good understanding of management APIs required.
Writing efficient and performant DAX queries is required.
Experience working with Snowflake data warehouse is a plus.
Minimum Qualification
Bachelor's Degree in Computer Science or related discipline.
Demonstrated ability to work as an effective team member.
Strong work ethic and motivation to constantly improve the product.
Clear and effective communication and writing skills.
Analytical, detail-oriented, and problem-solving aptitude.
Knowledge of finance/equity and financial data is a plus.
Location: Jersey City, NJ. (3 days onsite & 2 days remote).
Job Description
Define, implement, and optimize Data layer for Power BI Reports; Build visualizations and dashboards on top of the created data layer.
Design and develop interactive visualizations, reports and dashboards using Power BI desktop connecting to data warehouse.
Performance tuning of Power BI reports, by properly configuring the dataset modes - import mode/direct query etc.
Knowledge of Configuring DB connections on Power BI Servers in Azure.
Setup and manage deployment pipelines for Power BI reports to automate the release life cycle.
Desired Experience
7+ years of experience in developing advanced reports and dashboards.
5+ years of strong hands-on Power BI experience in creating interactive reports against large datasets.
Should be well versed with drill down and drill through techniques.
Ability to understand complex data schemas and create optimized BI data models for reporting needs is a must.
Hands-on experience in architecting Power BI embedding portal is required (authentication/authorization/performance tuning etc.).
Able to implement row level security (RLS) on data and understand application security layer models in Power BI.
Deep understanding of dimensional modeling, enterprise data warehouse and Azure Data Lake.
Practical experience in understanding the capabilities and limitations of Direct Query vs Import Mode.
Experience in data extraction, data modelling, data warehousing and performance optimization.
Experience in managing Azure Power BI dedicated capacity and good understanding of management APIs required.
Writing efficient and performant DAX queries is required.
Experience working with Snowflake data warehouse is a plus.
Minimum Qualification
Bachelor's Degree in Computer Science or related discipline.
Demonstrated ability to work as an effective team member.
Strong work ethic and motivation to constantly improve the product.
Clear and effective communication and writing skills.
Analytical, detail-oriented, and problem-solving aptitude.
Knowledge of finance/equity and financial data is a plus.
