The Role
Design, develop, test, and operate large-scale BI solutions (reports, dashboards, data models) using Power BI and Azure Synapse. Gather requirements, translate business needs into data models, tune performance, collaborate with BI architects on POCs, and maintain stakeholder communication.
Summary Generated by Built In
Requirements
- Analyze, design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports, dashboards and other BI solutions for analytics based on business requirements and technical specifications using the Microsoft BI Platform (Azure Synapse, Power BI)
- Work closely with internal teams, gathering requirements and translating those business needs into data models and BI solutions
- Develop and maintain relationships through effective and timely communication with stakeholders and peers
- Performance tuning of solutions
- Work with the BI architects on Proofs of concepts and prototypes of new tools, features and technologies
- Bachelor’s degree in Computer Science, MIS, Information Technology or related fields with 5+ years of experience in BI analysis and development
- Demonstrated hands-on experience with Power BI development and experience building dynamic measures using DAX with cloud database systems (Synapse, AWS etc.)
- Good understanding of data warehousing & modeling concept and strong understanding of Business Intelligence Development Lifecycle
- Excellent communication skills
- Strong understanding of Power BI application security layer models: Row-Level Security, Restricting Sharing and Publishing, Restricting Export and Printing
- Results driven mindset and ability to communicate and develop strong working relationships with people at all levels in a global environment
- Intermediate T-SQL Skills
Skills Required
- Bachelor's degree in Computer Science, MIS, Information Technology or related field
- 5+ years of experience in BI analysis and development
- Hands-on Power BI development experience
- Experience building dynamic measures using DAX
- Experience with cloud database systems (Azure Synapse, AWS)
- Good understanding of data warehousing and data modeling concepts
- Strong understanding of Business Intelligence Development Lifecycle
- Strong understanding of Power BI application security models (Row-Level Security, restricting sharing/publishing/export/printing)
- Intermediate T-SQL skills
- Excellent communication skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Pivotal Solutions is a national staffing and consulting firm founded in 2002 that specializes in matching job seekers and companies for roles in IT & Technology and Accounting & Finance. They offer a variety of staffing solutions, including Direct Hire and Contract-to-Hire placements, serving a diverse client base that ranges from innovative startups to Fortune 500 companies across the United States.
.png)
