Job Description
At MasTec Communications Group we build for the future. Yours and ours.
As a PowerBi Developer, you will develop new skills, work in a safety-minded environment, and join us in expanding technology for a better community. Join the MasTec family and help us provide the highest level of quality service to our customers and communities while maintaining our commitment to safety!
Responsibilities
As a PowerBi Developer, you are responsible for working with teams across the organization to map and analyze current processes, both in service delivery areas and in central services functions, and to identify and deliver business process improvements that streamline activity, are robust, and compliant, increase quality and efficiency and represent best practice. You believe in doing the job right. Being the best. And you’re up for the challenge.
Core Responsibilities
- Dashboard & Report Design: Design, build, and deploy interactive visual reports and KPI scorecards using Power BI Desktop.
- Data Modeling: Construct robust semantic models, establish data relationships, and apply data filters or row-level security (RLS).
- DAX & Optimization: Write and optimize complex DAX and tune report performance for large datasets.
- Stakeholder Collaboration: Partner with cross-functional business units to define reporting needs, gather business requirements, and drive BI adoption.
Qualifications
Required Technical Skills
- Minimum of 5 years experience with BI Platforms: Deep expertise in Microsoft Power BI (Service, Desktop, and Report Server).
- Languages: Advanced proficiency in SQL (T-SQL) and DAX
- Data Preparation: Strong capabilities with Power Query / M-code
- Ecosystem: Familiarity with Microsoft Azure (Synapse, Data Lake), Microsoft 365, and Power Automate
- Advanced DAX (Data Analysis Expressions): Writing complex calculations, time-intelligence functions, and performance-tuned measures.
- SQL Proficiency: Writing relational database queries, views, and stored procedures to fetch source data.
- Data Modeling: Designing efficient data structures using Star Schema principles, facts, and dimension tables.
- ETL & Data Integration: Extract, transform, and load (ETL) data from multiple sources (SQL databases, APIs, ERP/CRM platforms) using Power Query.
- Data Visualization & UI/UX: Selecting correct chart types, structuring layouts, and using color theory for scannable dashboards.
- Power BI Service Administration: Managing workspace permissions, data gateways, scheduled refreshes, and Row-Level Security (RLS).
Skills Required
- Minimum of 5 years experience with BI Platforms
- Deep expertise in Microsoft Power BI (Service, Desktop, and Report Server)
- Advanced proficiency in SQL (T-SQL) and DAX
- Strong capabilities with Power Query / M-code
- Familiarity with Microsoft Azure (Synapse, Data Lake), Microsoft 365, and Power Automate
- Writing relational database queries, views, and stored procedures to fetch source data
- Designing efficient data structures using Star Schema principles
- Extract, transform, and load (ETL) data from multiple sources using Power Query
- Selecting correct chart types and structuring layouts for dashboards
- Managing workspace permissions and data gateways in Power BI Service
What We Do
Sourcefit is a business process outsourcing (BPO) company that provides custom offshore staffing solutions and managed services to help clients build lasting value in their outsourced teams.
