Senior Power BI Developer & Data Modeler

Pivotal Solutions; Boston (MA); On-site; USD 90,000 - 130,000; Full time

Job summary

Pivotal Solutions in Boston, MA is seeking a BI Analyst to design, build, and optimize large-scale data models, reports and dashboards using the Microsoft BI Platform (Azure Synapse, Power BI). You will work closely with internal teams to translate requirements into data solutions and deliver performant BI products.

You will develop dynamic measures in DAX, ensure data security with Row-Level Security, and partner with BI architects on new tool proofs of concept.

Qualifications

• Bachelor’s degree in Computer Science, MIS, Information Technology or related fields with 5+ years of experience in BI analysis and development.
• Experience with Power BI development and DAX for cloud data platforms (Synapse, AWS).
• Strong data warehousing and modeling concepts; knowledge of BI Development Lifecycle.
• Excellent communication skills; ability to work with stakeholders.
• Knowledge of Power BI security features: Row-Level Security and publishing/export restrictions.
• Ability to work in a global environment and relate to all levels.
• Intermediate T-SQL skills.

Responsibilities

• Analyze, design, develop, implement, test, document, and operate large-scale, high-volume BI solutions for analytics using Microsoft BI Platform (Azure Synapse, Power BI).
• Gather requirements and translate business needs into data models and BI solutions.
• Develop and maintain relationships through effective and timely communication with stakeholders and peers.
• Performance tuning of BI solutions.
• Collaborate with BI architects on proofs of concepts and prototypes of new tools and technologies.

Skills

Power BI development

DAX

T-SQL

Communication skills

BI analysis

Stakeholder communication

Education

Bachelor’s degree in Computer Science, MIS, Information Technology or related fields

Tools

Azure Synapse

AWS

Job description

Pivotal Solutions in Boston, MA is seeking a BI Analyst to design, build, and optimize large-scale data models, reports and dashboards using the Microsoft BI Platform (Azure Synapse, Power BI). You will work closely with internal teams to translate requirements into data solutions and deliver performant BI products.

You will develop dynamic measures in DAX, ensure data security with Row-Level Security, and partner with BI architects on new tool proofs of concept.