[Remote] Data Analyst
Note: The job is a remote job and is open to candidates in USA. The Providencia Group is dedicated to addressing global challenges through transformative solutions. They are seeking a Data Analyst to create insightful reports, perform comprehensive data analysis, and enhance data management processes using Microsoft Dataverse and other platforms.
Responsibilities
- Lead the design, development, and maintenance of complex Power BI reports and dashboards that provide actionable insights to various stakeholders
- Architect scalable data models and optimized queries for large datasets, including data from Microsoft Dataverse
- Collaborate with cross-functional team to integrate Power BI with other business systems
- Create and optimize data models in Power BI, including the design of data relationships, calculated columns, and measures to support effective data analysis
- Ensure data governance, security, and compliance within Power BI and Microsoft Dataverse limitations
- Leverage and implement new data visualizations through alternative technologies & techniques
- Create reliable and transparent data pipelines to power analytics
- Maintain and optimize data source connections, leveraging the data flow and/or data gateways
- Utilize SQL, Python, or R programming to extract and manipulate data from relational databases
- Employ R or Python to extract information from APIs and integrate it into the data ecosystem
- Collaborate closely to promote data consistency and integrity
- Assist with triage of data requests and fulfill requests in a timely manner with minimal guidance once fully onboarded
- Assist with the refinement of key performance indicators and support the implementation of consistent data definitions
- Ensure business intelligence products reflect TPG brand identity and provide rich insights
- 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
- Provide peer review and guidance to other analytics staff, fostering a collaborative knowledge-sharing environment
- Work closely with business analysts, data engineers, and other stakeholders to understand reporting requirements and ensure that reporting solutions meet business needs
- Provide training and support to end-users on Power BI tools and functionalities. Troubleshoot and resolve issues related to report generation and data accuracy
- Document report development processes, data models, and best practices to ensure consistency and facilitate knowledge sharing within the team
Skills
- Bachelor's degree in Computer Science, Data Science, Mathematics, Information Systems, Business Analytics, or a related field
- 5+ years experience working Power BI, including expertise in DAX, Power Query, and custom visuals
- Excellent knowledge of data cleaning and validation principals and techniques
- Experience developing data collection and reporting systems
- Data software and statistical programming experience, including: expertise in Power BI Desktop, Power BI Service, R, Python, DAX, and Power Query
- Experience in Microsoft Dataverse, including data integration, data management, and configuration
- Experience with other data visualization tools (e.g., Power BI, Tableau) is a plus
- Knowledge of SQL and experience with other databases or data warehouses
- Understanding of data modeling concepts and best practices
- Experience with DAX (Data Analysis Expressions) and Power Query M language
- Excellent analytical and problem-solving skills with a keen attention to detail
- Strong verbal and written communication skills, with the ability to convey complex data concepts to non-technical stakeholders
- Ability to work collaboratively within a team environment and manage multiple priorities effectively
- Be able to handle a fast-paced environment
- Must possess strong computer skills in MS Office, including Excel, Word, & Teams
- Ability to type 45 wpm
- Complete a rigorous culture and competency testing process
- Complete a Drug Test
- Must be at least 21 years of age
- A valid US Driver's license
- Have the ability to obtain a Public Trust Clearance
- Must be a U.S Citizen
- Residency requirement - 3 cumulative years in the last 5 years
- Must be able to lift and carry IT equipment weighing 50 pounds
- Must have mobility to attend meeting with other managers and employees
- Must be able to write, type and use a telephone system 100% of the time
- Sitting for prolonged and extended periods of time
Company Overview