Power BI Lead Developer
Role : Power BI Lead developer
Location : Iselin, NJ (3 days Hybrid)-Local preferred
Contract
Must Have : powerbi + SQL+ Python + Paginated reports
Job Description:
Requirements:
• Experience with Power BI development, visualizations and deployment (10+ years).
• Experience with the Microsoft BI stack, including TSQL, PowerBI, Power Query, DAX, M, MDX and, SSAS, SSRS, SSIS (10+ years).
• Experience with configuration / management of Microsoft Power BI Service Experience extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards and Apps to recommend and/or take action.
• Demonstrated SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting.
• Excellent written, verbal and presentation skills.
• AWS Cloud and/or Snowflake experience is a plus
• Understand glossaries and terminologies in end-to-end skills and financial industry
• Experience documenting business requirements, processes and workflows (5+ years)
• Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.
• Must be detail oriented, and able to work independently and self-prioritize tasks.
• Demonstrated experience in working with relational databases: SQL Server (8+ years).
• Bachelor's degree in Computer Science, Design, Statistics, or equivalent.
• Microsoft Power BI Certification is a plus
Responsibilities:
• Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questions
• Develop reports, thoughtful visualizations , dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques
• Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven story
• Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets
• MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
• Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback
• Power Query and coding fundamentals (ability to use M language to build loops, pull APIs, etc.)
• Assist with governance and deployment of Power BI , including administration, content distribution/sharing, training and support
• Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
• Champion the leading Power BI design methodology and best practices
• Extract data from various data sources ; perform exploratory data analysis, cleanse, reshape, and aggregate data
• Evangelize data analytics best practices among peers and stakeholders
• Proactively monitor and evaluate the impact of monthly Power BI releases.
• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities
Role : Power BI Lead developer
Location : Iselin, NJ (3 days Hybrid)-Local preferred
Contract
Must Have : powerbi + SQL+ Python + Paginated reports
Job Description:
Requirements:
• Experience with Power BI development, visualizations and deployment (10+ years).
• Experience with the Microsoft BI stack, including TSQL, PowerBI, Power Query, DAX, M, MDX and, SSAS, SSRS, SSIS (10+ years).
• Experience with configuration / management of Microsoft Power BI Service Experience extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards and Apps to recommend and/or take action.
• Demonstrated SQL development experience by writing queries and procedures and also using functions to create curated data for use in reporting.
• Excellent written, verbal and presentation skills.
• AWS Cloud and/or Snowflake experience is a plus
• Understand glossaries and terminologies in end-to-end skills and financial industry
• Experience documenting business requirements, processes and workflows (5+ years)
• Advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming is preferred.
• Must be detail oriented, and able to work independently and self-prioritize tasks.
• Demonstrated experience in working with relational databases: SQL Server (8+ years).
• Bachelor's degree in Computer Science, Design, Statistics, or equivalent.
• Microsoft Power BI Certification is a plus
Responsibilities:
• Participate in discussions with business partners to define key business questions, translate them into necessary requirements documentation and develop visual data-driven solutions which answer those questions
• Develop reports, thoughtful visualizations , dashboards and KPI scorecards using Microsoft's Power BI and Azure stack employing leading visualization techniques
• Perform UX design activities and Power BI navigation features (e.g. bookmarks, drill-throughs) to guide end-users through a data-driven story
• Develop calculations in SQL, DAX and Power BI measures which are accurate and performant on large datasets
• MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
• Work with our internal customers to manage User Acceptance Testing (UAT) processes and address their feedback
• Power Query and coding fundamentals (ability to use M language to build loops, pull APIs, etc.)
• Assist with governance and deployment of Power BI , including administration, content distribution/sharing, training and support
• Proficient Data Architecture and Modeling experience (Structuring Tables, Attributes, and Relationships [One-to-One, One-to-Many, Many-to-One, Many-to-Many])
• Champion the leading Power BI design methodology and best practices
• Extract data from various data sources ; perform exploratory data analysis, cleanse, reshape, and aggregate data
• Evangelize data analytics best practices among peers and stakeholders
• Proactively monitor and evaluate the impact of monthly Power BI releases.
• Conduct deep-dive data analysis for business insights and recommendations, including ad hoc analytics for executive-level requests and priorities
