Job Description

About our client

Our client is the leading insights company, using market-leading data to drive better marketing decisions for global companies. They are growing their engineering team and investing heavily in their SaaS platform.

About the role

This role is centered on designing, managing, and enhancing data models and dashboards in Microsoft Power BI, while also assisting with data integration and broader business intelligence initiatives.

Responsibilities

• Develop and architect efficient data models in Power BI aligned with Microsoft Data Lake schemas.
• Clean, transform, and model raw data using Power Query (M) and DAX formulas.
• Enhance dataset structure to ensure optimal performance and scalability.
• Design and deliver interactive, visually compelling Power BI dashboards and reports based on business needs.
• Leverage drill-through, slicers, bookmarks, and custom visuals to improve report usability.
• Define, build, and maintain KPIs, metrics, and performance scorecards.
• Integrate Power BI with diverse data sources such as SQL Server, Excel, APIs, Azure, and SharePoint.
• Work closely with data engineers to maintain dependable data pipelines and ETL processes.
• Implement Power BI Dataflows and integrate with platforms like Azure Data Factory when necessary.
• Monitor and fine-tune report load speeds and dataset refresh performance.
• Identify and resolve DAX optimization issues while minimizing memory usage.
• Follow best practices to ensure efficient and scalable report and dataset development.
• Collaborate with business analysts, product owners, and stakeholders to define reporting requirements.
• Translate business needs into clear technical requirements and documentation.
• Provide user training and create supporting documentation to promote self-service BI.
• Oversee Power BI workspaces, applications, and user access management.
• Apply row-level security (RLS) to safeguard and control data access.
• Partner with IT teams to ensure compliance with data governance standards.
• Troubleshoot and resolve issues related to existing reports and data models.
• Maintain report versioning and support structured change management processes.
• Track report adoption and incorporate stakeholder feedback for ongoing enhancements.

Required Qualifications

• Bachelors degree in Software Engineering or a related discipline, or at least 5 years of hands-on experience in Power BI and Power Apps development.
  
• Advanced proficiency in Python 3.x, including its standard libraries, object-oriented programming, and functional programming concepts.
• Solid expertise in system design, software architecture, and microservices-based applications.
• Strong experience working with RESTful APIs, JSON, and web-based integrations.
• Familiarity with containerization tools such as Docker, CI/CD workflows, and cloud environments including Azure, SharePoint, and Excel.
• Extensive experience with databases, including SQL, Microsoft Fabric (Data Lake), SQLAlchemy, and Django ORM.
• In-depth knowledge of HubSpot CRM, Monday.com, and/or the Deltek Vision ERP codebase.
• Strong grasp of unit testing principles and automated testing frameworks.
• Excellent verbal and written communication skills with strong interpersonal abilities.

Skills, Tools, & Technologies

• Proficient in Power BI across Desktop, Service, and Mobile platforms
• Skilled in DAX and Power Query (M) for data modeling and transformation
• Experience with SQL Server, Azure SQL, Excel, and SharePoint as data sources
• Familiar with Azure Data Lake, Azure Synapse, and Azure Data Factory
• Knowledge of Power Platform tools such as Power Automate and Power Apps (preferred)
• Experience using Git or other version control systems where applicable
• Strong analytical and problem-solving capabilities
• Ability to communicate effectively with both technical and non-technical stakeholders
• Keen attention to detail to ensure data accuracy and high-quality report design
• Effective time management skills with the ability to work independently and collaboratively