Senior Power BI Engineer

MCS is a nationwide property services provider working across Commercial Properties, Single-Family Rentals, and the Property Preservation industry. For over 35 years, we have been committed to responsive care, industry-leading service standards, leveraging technology, and end-to-end transparency to transform homes and businesses. Together, we can brighten and revitalize neighborhoods across the nation.

Design, develop, and maintain business intelligence solutions using Microsoft Power BI. Build data visualization, report development, and ETL (Extract, Transform, Load) processes.

3 people for the moment: 1 Senior QA/AQA + 2 PowerBI engineers (1 Senior 1 Jun-Mid-Senior) directly working with the US team

• Interview process that respects people and their time
• Professional and open IT community
• Internal meet-ups and resources for knowledge sharing
• Time for recovery and relaxation
• Bright online and offline events
• Opportunity to become part of our internal volunteer community

Data Visualization and Reporting:
- Develop and design interactive dashboards, reports, and visualizations using Power BI.
- Create intuitive and user-friendly data visualizations that meet business requirements.
ETL and Data Modeling:
- Design and implement ETL processes to transform raw data into structured, usable formats.
- Develop robust data models (star schema, snowflake schema) to optimize performance and scalability.
- Write DAX (Data Analysis Expressions) for advanced calculations, KPIs, and custom measures.
Data Sources Integration:
- Connect and integrate data from various sources, including SQL Server, Azure SQL, Excel, REST APIs, and other databases.
- Ensure data accuracy, integrity, and consistency by cleaning and preprocessing raw data.
Performance Optimization:
- Optimize Power BI reports for performance, scalability, and user experience.
- Monitor report usage and troubleshoot issues related to data accuracy or performance bottlenecks.
Collaboration with Stakeholders:
- Work closely with business analysts, data engineers, and end-users to understand requirements and deliver actionable insights.
- Provide training and support to users on how to interpret and use Power BI reports effectively.
Automation and Best Practices:
- Automate data refresh processes using Power BI Premium or Azure Data Factory.
- Implement best practices for maintaining and updating reports, including version control and documentation.
Continuous Improvement:
- Stay up-to-date with the latest features, updates, and trends in Power BI and business intelligence.
- Identify opportunities to improve existing reports and introduce new analytical capabilities.

Education:

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field.
• Advanced degrees or certifications (e.g., Power BI Desktop Specialist) are a plus.

Experience:

• Minimum of 5 years of experience working with Power BI (desktop and service) in a professional setting.
• Experience designing and implementing ETL processes and data models.
• Familiarity with SQL and database management (e.g., T-SQL, stored procedures).

Technical Skills:

• Proficiency in Power BI, including report creation, data modeling, DAX, and visualizations.
• Experience with ETL processes and data integration (e.g., Power Query, Azure Data Factory).
• Knowledge of SQL Server, Azure SQL, or other relational databases.
• Familiarity with REST APIs and web services for data integration.
• Experience with version control systems (e.g., Git) and CI/CD pipelines.

Soft Skills:

• Strong analytical and problem-solving skills.
• Excellent communication skills to translate technical concepts into actionable insights for non-technical stakeholders.
• Attention to detail and the ability to work independently or as part of a team.

Preferred Qualifications:

• Experience with Azure services (e.g., Azure SQL, Data Factory, Synapse Analytics).
• Familiarity with data governance and compliance frameworks.
• Experience with advanced analytics, such as predictive modeling or machine learning in Power BI.
• Certifications: Microsoft Certified: Power BI Desktop Specialist, Data Analyst Associate, or similar.