Rea is looking to leverage Power BI and Azure SQL to analyze data, build data sets, develop insightful reports, and create efficient workflows to contribute to data-driven decision-making and process optimization across the organization.
Requirements
- Proficiency in data analysis, visualization, and report creation using Power BI
- Strong understanding of data transformation, ETL processes, and data modeling concepts
- Familiarity with data governance principles and best practices for maintaining data accuracy and security
- Intermediate SQL knowledge
- Hands-on experience developing custom Power BI Dashboards, analyzing data within SQL databases, building company wide usable datasets
- Analyzing raw data and identifying useful metrics and new ways of looking at data to help drive the business
- Experience with Microsoft Power Platform tools (Power BI, Power Apps, Power Automate)
Responsibilities
- Utilize Power BI to gather and transform data from various sources (IE Excel, APIs, SQL), creating visually appealing and interactive dashboards to present key insights to stakeholders
- Design robust generalized SQL datasets through combining raw data for reports.
- Apply data cleansing and transformation techniques using Power Query to ensure data accuracy and consistency across different data sources
- Collaborate with data warehouse engineers to enhance data quality and resolve data integration issues
- Train end-users on using Power BI, Power Apps, and Power Automate effectively for their respective needs
- Ensure compliance with data governance policies and implement security measures to protect sensitive data within Power Platform solutions
- Stay up-to-date with Microsoft's updates and features related to Power Platform to maintain best practices
Other
- Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, or a related field
- Proven experience (5+ years) as a Data Analyst
- Excellent communication skills, both written and verbal, to convey technical concepts to non-technical stakeholders
- Travel to client locations as needed
- Ability to work in a collaborative team environment and deliver results on time
