Power BI with SQL Senior Developer

Artech
Newark, NJ, United States
15 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$104,000 - $114,400
Working hours
Regular working hours

Tech stack

Adaptable Database Systems Application Programming Interfaces (APIs) Data Analysis Unit Testing Business Intelligence Development Cloud Computing Databases Information Engineering Data Governance Data Integration Data Transformation Data Warehousing
+8 more
Database Schema Query Optimization Power BI SQL Stored Procedures SQL Databases Sql Optimization Powerquery Star Schema

Job description

We are seeking an experienced Power BI Developer / BI Consultant with strong expertise in Client Power BI, Client Fabric, SQL, Data Modeling, and Business Intelligence solutions. The ideal candidate will work closely with business stakeholders to gather requirements, design scalable BI solutions, develop insightful dashboards, and guide teams in implementing best practices for reporting, analytics, and data governance.

The role requires hands-on experience with Client Fabric, Power BI development, data integration, and cloud-based analytics platforms. The consultant will also mentor existing BI developers, oversee solution delivery, and help establish a modern BI architecture., * Collaborate with business stakeholders to gather, analyze, and document reporting and analytics requirements.

  • Design, develop, and maintain interactive Power BI dashboards, reports, and scorecards.
  • Build and optimize semantic models, datasets, and Power BI workspaces.
  • Develop advanced calculations using DAX and perform data transformations using Power Query (M).
  • Create and maintain SQL views, stored procedures, and database objects.
  • Design scalable data models utilizing star schema, fact tables, and dimension tables.
  • Leverage Client Fabric capabilities for data engineering, data warehousing, and business intelligence solutions.
  • Integrate data from APIs, cloud platforms, databases, and third-party systems.
  • Optimize report performance, scalability, security, and user experience.
  • Implement row-level security (RLS), workspace governance, and data access controls.
  • Perform unit testing and validation to ensure data accuracy and report integrity.
  • Guide and mentor BI developers, review deliverables, and ensure adherence to best practices.
  • Troubleshoot production reporting issues and provide technical solutions.
  • Participate in BI architecture planning and roadmap execution.
  • Stay updated with emerging Client Fabric and Power BI capabilities., * Power BI Service
  • Power BI Dataflows
  • Paginated Reports
  • Power BI Administration

Data Modeling & Analytics

  • DAX (Data Analysis Expressions)
  • Power Query (M)
  • Data Modeling
  • Star Schema Architecture
  • Fact & Dimension Modeling
  • KPI Development
  • Dashboard Design

Database & SQL

  • Advanced SQL
  • Stored Procedures
  • Views
  • Functions
  • Query Optimization
  • Data Warehousing Concepts

Requirements

Power BI, SQL (Structured Query Language), Power BI, SQL (Structured Query Language), Consulting, Business Intelligence, Reporting Dashboards, Data Modeling, Best Practices, Business Solutions

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…