Manager, Business Intelligence & User Experience

3PILLAR GLOBAL Company At 3Pillar, the power of culture, teamwork, and open collaboration drive our commitment to building breakthrough software solutions that power digital businesses. Our passion for products has gained us recognition in some of software’s most innovative spaces, including a spot on the Inc. 5000 list ten times, an Institute of Excellence in Sales (IES) Premier Sales Employer winner, a three-time winner of the Washington Post Top Workplaces Award, and notable features in Forbes, Fortune, and the Washington Business Journal. 
We work with clients to build incredible innovative products as their development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Our key differentiator is our Product Mindset and Lightwave Methodology.  Our development teams focus on building for outcomes and all of our team members around the globe are trained on the Product Mindset’s core values – Minimize Time to Value, Solve for Need, and Excel at Change. Our teams apply this mindset to build digital products that are customer-facing and revenue-generating. Our business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through market launch and beyond. 

RESPONSIBILITIES

• Design and develop KPI dashboards and other data visualizations/reporting in PowerBI for the business to help inform decision making at the highest levels of the organization while maintaining documentation.
• Continuously monitor and maintain the quality of underlying report data. Develop and execute test cases (data validation rules) for data validation during user and system integration testing.
• Design visually appealing dashboards using appropriate color theory, typography, and layout principles.
• Create guidelines to produce a consistent, standardized, and efficient end user experience.
• Collaborate with key business leaders to understand business needs and requirements, and assess client needs using a structured requirements process to identify priorities and provide options.
• Work closely with the Data Team to ensure tight alignment of dashboards with the Data Warehouse.

REQUIREMENTS

• Minimum 5+ years of proven experience in Business Intelligence and Data visualization using BI tools such as PowerBIStrong understanding of data visualization best practices and the ability to design intuitive and insightful dashboards and reports by synthesizing large amounts of detailed information.
• Expertise in data modeling, including creating and managing complex data models, understanding relationships, hierarchies, and data integrity.Advanced SQL skills and experience in writing complex SQL queries.
• Proficiency in Power Query for data transformation and cleansing, and DAX (Data Analysis Expressions) for creating calculated columns, measures, and custom tables.
• Knowledge of integrating various data sources such as SQL databases, Excel, APIs, Cloud Services (Azure, AWS), and On-Premises data gateways.
• Proficient in requirement analysis, business process modeling, and documentation techniques (e.g., use cases / user stories, data flow diagrams, data mapping, data interrogation, etc.)Proven experience with various project delivery methodologies and ability to work in an agile development environment.
• Excellent problem-solving, analytical and communication skills


• Good to Have:
• Experience with data extraction, transformation, and loading (ETL) processes.
• Experience working with Azure Platform, preferably using Azure Data Services like Azure Data Lake Gen2, Azure Data Factory, Azure SQL Database, Azure Databricks.
• Experience with data engineering tools and technologies like Python, Spark.
• Knowledge of Data Lake and Data Warehouse concepts.
• Familiarity with machine learning technologies.

BENEFITS

• At 3Pillar Global, we are the power behind the brands you know. We are hiring new team members to assist us in continuing our growth trajectory as a fast growing global team of thousands of professionals. New Leaders will live our shared values of Intrinsic Dignity, Open Collaboration, Outsized Impact, and Continuous Improvement everyday to harness The Power of Team and deliver exceptional products and services for our clients. 
• We support the comprehensive wellbeing of our team members, through:
• Career growth and development.
• Physical and mental wellbeing: as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging unlimited PTO to take some needed time off, we want