Power BI Engineer

<p><b>TITLE: Power BI Engineer</b></p><p><b>LOCATION: Remote</b></p><p><b>TRAVEL: Minimal/As needed</b></p><p></p><p><b><u>About Us</u></b></p><p>The Providencia Group is led by a purpose: to address global challenges and make an impact that matters through delivering transformative solutions.  This purpose defines who we are and extends to relationships with our clients, our people, and our communities. We combine purpose, innovation, and experience to deliver impactful results.</p><p></p><p><b><u>A</u></b><b><u>bout The Team</u></b></p><p>We are problem solvers working with leading agencies and organizations to help them address many of today’s most complex challenges. Our world-class team of technologists, program managers, and subject matter experts is uniquely qualified to address ever-evolving, large-scale challenges. In an imperfect world, The Providencia Group puts capability and purpose into action.</p><p></p><p><b><u>What you’ll be part of – TPG Culture</u></b></p><p>At TPG, we expect incredible tangible results. TPG professionals play a unique role in delivering these results.  We reach across disciplines and borders to serve our global organization.  We provide a roadmap for focusing on people, our work, and continuous improvement.  We see people as people, take care of each other, commit to the mission, move quickly and bravely, get better every day, and seek truth.  We are the backbone of TPG. </p><p></p><p><b><u>About the Role </u></b></p><p>We are seeking a Power BI Engineer with experience in Microsoft Dataverse and other platforms to join our team. The ideal candidate will be creating insightful reports, performing comprehensive data analysis, and leveraging Dataverse and other platforms to streamline and enhance our data management processes.</p><p></p><p><b><u>What You’ll Do</u></b></p><p>The role requires a detail-oriented individual with strong analytical skills, proficiency in Power BI, Tableau, etc. and an understanding of Dataverse integration and functionalities.</p><p></p><p><b><u>Responsibilities include, but are not limited to:</u></b></p><p></p><p><b><u>Data Visualization, Power BI and Microsoft Dataverse</u></b></p><ul><li>Lead the design, development, and maintenance of complex Power BI reports and dashboards that provide actionable insights to various stakeholders.</li><li>Architect scalable data models and optimized queries for large datasets, including data from Microsoft Dataverse.</li><li>Collaborate with cross-functional team to integrate Power BI with other business systems.</li><li>Create and optimize data models in Power BI, including the design of data relationships, calculated columns, and measures to support effective data analysis.</li><li>Ensure data governance, security, and compliance within Power BI and Microsoft Dataverse limitations.</li><li>Leverage and implement new data visualizations through alternative technologies & techniques.</li></ul><p></p><p><b><u>Data Engineering</u></b></p><ul><li>Create reliable and transparent data pipelines to power analytics.</li><li>Maintain and optimize data source connections, leveraging the data flow and/or data gateways.</li><li>Utilize SQL, Python, or R programming to extract and manipulate data from relational databases.</li><li>Employ R or Python to extract information from APIs and integrate it into the data ecosystem.</li><li>Collaborate closely to promote data consistency and integrity.</li></ul><p><b><u>Business Intelligence</u></b></p><ul><li>Assist with triage of data requests and fulfill requests in a timely manner with minimal guidance once fully onboarded.</li><li>Assist with the refinement of key performance indicators and support the implementation of consistent data definitions.</li><li>Ensure business intelligence products reflect TPG brand identity and provide rich insights.</li><li>Develop ad hoc and ongoing reports and dashboards using Power BI, Python, R, or other tools as appropriate, demonstrating a high level of autonomy and advanced statistical skills.</li><li>Provide peer review and guidance to other analytics staff, fostering a collaborative knowledge-sharing environment.</li></ul><p></p><p><b><u>Continuous Quality Improvement</u></b></p><ul><li>Work closely with business analysts, data engineers, and other stakeholders to understand reporting requirements and ensure that reporting solutions meet business needs.</li><li>Provide training and support to end-users on Power BI tools and functionalities. Troubleshoot and resolve issues related to report generation and data accuracy.</li><li>Document report development processes, data models, and best practices to ensure consistency and facilitate knowledge sharing within the team.</li></ul><p></p><p><b><u>Minimum Qualifications & Skills</u></b></p><ul><li>Bachelor’s degree in Computer Science, Data Science, Mathematics, Information Systems, Business Analytics, or a related field.</li><li>5+ years experience working Power BI, including expertise in DAX, Power Query, and custom visuals.</li><li>Excellent knowledge of data cleaning and validation principals and techniques</li><li>Experience developing data collection and reporting systems</li><li>Data software and statistical programming experience, including: expertise in Power BI Desktop, Power BI Service, R, Python, DAX, and Power Query.</li><li>Experience in Microsoft Dataverse, including data integration, data management, and configuration.</li><li>Experience with other data visualization tools (e.g., Power BI, Tableau) is a plus.</li><li>Knowledge of SQL and experience with other databases or data warehouses.</li><li>Understanding of data modeling concepts and best practices.</li><li>Experience with DAX (Data Analysis Expressions) and Power Query M language.</li><li>Excellent analytical and problem-solving skills with a keen attention to detail.</li><li>Strong verbal and written communication skills, with the ability to convey complex data concepts to non-technical stakeholders.</li><li>Ability to work collaboratively within a team environment and manage multiple priorities effectively.</li><li>Be able to handle a fast-paced environment</li><li>Must possess strong computer skills in MS Office, including Excel, Word, & Teams</li><li>Ability to type 45 wpm</li></ul><p></p><p><b><u>Work Environment</u></b></p><p>This is a remote opportunity where occasional travel could be required.  Since this is a remote role, must have a dedicated workspace conducive to full videoconferencing (camera and audio) for facilitating webinars and online discussions.</p><p><br><b><u>Work Schedule</u></b></p><p>This is a full-time position, but hours could vary depending on needs. May include travel, evenings, and weekends to meet different time zones and projects.</p><p></p><p><b><u>Condition of employment:</u> </b></p><ul><li>Complete a rigorous culture and competency testing process </li><li>Complete a Drug Test</li><li>Must be at least 21 years of age</li><li>A valid US Driver’s license</li><li>Have the ability to obtain a Public Trust Clearance</li></ul><p></p><p><b><u>Security Clearance Requirements: </u></b></p><ul><li>Applicants selected will be subject to a government background investigation and may need to meet eligibility requirements for access to classified information.</li><li>Must be a U.S Citizen</li><li>Residency requirement - 3 cumulative years in the last 5 years.</li></ul><p></p><p><b><u>Physical Demands</u></b></p><ul><li>Must be able to lift and carry IT equipment weighing 50 pounds</li><li><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Standing/Walking/Mobility: </span> Must have mobility to attend meeting with other managers and employees.</li><li><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Climbing/Stooping/Kneeling:</span> 10% of the time.</li><li><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Lifting/Pulling/Pushing:</span> 10% of the time.</li><li><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">Fingering/Grasping/Feeling: </span> Must be able to write, type and use a telephone system 100% of the time.</li><li>Sitting:  Sitting for prolonged and extended periods of time.</li></ul><p></p><p></p><p></p><p></p><p></p><h3><span><span>For more information about the company please visit our website at <a href="https://www.theprovidenciagroup.com" target="_blank" rel="noopener noreferrer"><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">https://www.theprovidenciagroup.com</span></a></span></span></h3><p></p><h3>Providencia is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, disability or any other federal, state or local protected class.</h3><p></p><h3><span>TPG complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities.</span></h3><p><span> </span></p><h3><span>If you require accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquires to<span> </span><a href="mailto:HRsupport@theprovidenciagroup.com" target="_blank" rel="noopener noreferrer"><span style="overflow-wrap: break-word; display: inline; text-decoration: inherit; hyphens: auto;">HRsupport@theprovidenciagroup.com</span></a><span> </span></span></h3><p></p><p></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...