[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.ResponsibilitiesLead the design, development, and maintenance of complex Power BI reports and dashboards that provide actionable insights to various stakeholdersArchitect scalable data models and optimized queries for large datasets, including data from Microsoft DataverseCollaborate with cross-functional team to integrate Power BI with other business systemsCreate and optimize data models in Power BI, including the design of data relationships, calculated columns, and measures to support effective data analysisEnsure data governance, security, and compliance within Power BI and Microsoft Dataverse limitationsLeverage and implement new data visualizations through alternative technologies & techniquesCreate reliable and transparent data pipelines to power analyticsMaintain and optimize data source connections, leveraging the data flow and/or data gatewaysUtilize SQL, Python, or R programming to extract and manipulate data from relational databasesEmploy R or Python to extract information from APIs and integrate it into the data ecosystemCollaborate closely to promote data consistency and integrityAssist with triage of data requests and fulfill requests in a timely manner with minimal guidance once fully onboardedAssist with the refinement of key performance indicators and support the implementation of consistent data definitionsEnsure business intelligence products reflect TPG brand identity and provide rich insightsDevelop 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 skillsProvide peer review and guidance to other analytics staff, fostering a collaborative knowledge-sharing environmentWork closely with business analysts, data engineers, and other stakeholders to understand reporting requirements and ensure that reporting solutions meet business needsProvide training and support to end-users on Power BI tools and functionalities. Troubleshoot and resolve issues related to report generation and data accuracyDocument report development processes, data models, and best practices to ensure consistency and facilitate knowledge sharing within the teamSkillsBachelor's degree in Computer Science, Data Science, Mathematics, Information Systems, Business Analytics, or a related field5+ years experience working Power BI, including expertise in DAX, Power Query, and custom visualsExcellent knowledge of data cleaning and validation principals and techniquesExperience developing data collection and reporting systemsData software and statistical programming experience, including: expertise in Power BI Desktop, Power BI Service, R, Python, DAX, and Power QueryExperience in Microsoft Dataverse, including data integration, data management, and configurationExperience with other data visualization tools (e.g., Power BI, Tableau) is a plusKnowledge of SQL and experience with other databases or data warehousesUnderstanding of data modeling concepts and best practicesExperience with DAX (Data Analysis Expressions) and Power Query M languageExcellent analytical and problem-solving skills with a keen attention to detailStrong verbal and written communication skills, with the ability to convey complex data concepts to non-technical stakeholdersAbility to work collaboratively within a team environment and manage multiple priorities effectivelyBe able to handle a fast-paced environmentMust possess strong computer skills in MS Office, including Excel, Word, & TeamsAbility to type 45 wpmComplete a rigorous culture and competency testing processComplete a Drug TestMust be at least 21 years of ageA valid US Driver's licenseHave the ability to obtain a Public Trust ClearanceMust be a U.S CitizenResidency requirement - 3 cumulative years in the last 5 yearsMust be able to lift and carry IT equipment weighing 50 poundsMust have mobility to attend meeting with other managers and employeesMust be able to write, type and use a telephone system 100% of the timeSitting for prolonged and extended periods of timeCompany OverviewThe Providencia Group provides human services, program management, training/technical assistance, and application development services. It was founded in 2021, and is headquartered in Ashburn, Virginia, USA, with a workforce of 201-500 employees. Its website is https://theprovidenciagroup.com.