BI/Data Engineer

We are seeking a Data Visualization Analyst 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.

What You’ll Do

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.

Responsibilities include, but are not limited to:

Data Visualization, Power BI and Microsoft Dataverse

1. Lead the design, development, and maintenance of complex Power BI reports and dashboards that provide actionable insights to various stakeholders.
2. Architect scalable data models and optimized queries for large datasets, including data from Microsoft Dataverse.
3. Collaborate with cross-functional team to integrate Power BI with other business systems.
4. Create and optimize data models in Power BI, including the design of data relationships, calculated columns, and measures to support effective data analysis.
5. Ensure data governance, security, and compliance within Power BI and Microsoft Dataverse limitations.
6. Leverage and implement new data visualizations through alternative technologies & techniques.

Data Engineering

1. Create reliable and transparent data pipelines to power analytics.
2. Maintain and optimize data source connections, leveraging the data flow and/or data gateways.
3. Utilize SQL, Python, or R programming to extract and manipulate data from relational databases.
4. Employ R or Python to extract information from APIs and integrate it into the data ecosystem.
5. Collaborate closely to promote data consistency and integrity.

Business Intelligence

1. Assist with triage of data requests and fulfill requests in a timely manner with minimal guidance once fully onboarded.
2. Assist with the refinement of key performance indicators and support the implementation of consistent data definitions.
3. Ensure business intelligence products reflect TPG brand identity and provide rich insights.
4. 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.
5. Provide peer review and guidance to other analytics staff, fostering a collaborative knowledge-sharing environment.

Continuous Quality Improvement

1. Work closely with business analysts, data engineers, and other stakeholders to understand reporting requirements and ensure that reporting solutions meet business needs.
2. Provide training and support to end-users on Power BI tools and functionalities. Troubleshoot and resolve issues related to report generation and data accuracy.
3. Document report development processes, data models, and best practices to ensure consistency and facilitate knowledge sharing within the team.

Minimum Qualifications & Skills

1. Bachelor’s degree in Computer Science, Data Science, Mathematics, Information Systems, Business Analytics, or a related field.
2. 5+ years experience working Power BI, including expertise in DAX, Power Query, and custom visuals.
3. Excellent knowledge of data cleaning and validation principles and techniques.
4. Experience developing data collection and reporting systems.
5. Data software and statistical programming experience, including: expertise in Power BI Desktop, Power BI Service, R, Python, DAX, and Power Query.
6. Experience in Microsoft Dataverse, including data integration, data management, and configuration.
7. Experience with other data visualization tools (e.g., Power BI, Tableau) is a plus.
8. Knowledge of SQL and experience with other databases or data warehouses.
9. Understanding of data modeling concepts and best practices.
10. Experience with DAX (Data Analysis Expressions) and Power Query M language.
11. Excellent analytical and problem-solving skills with a keen attention to detail.
12. Strong verbal and written communication skills, with the ability to convey complex data concepts to non-technical stakeholders.
13. Ability to work collaboratively within a team environment and manage multiple priorities effectively.
14. Be able to handle a fast-paced environment.
15. Must possess strong computer skills in MS Office, including Excel, Word, & Teams.
16. Ability to type 45 wpm.

Work Environment:

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.