What are the responsibilities and job description for the SQL and Power BI Analyst position at Smitty's Supply?
Smitty's Supply, Inc. is seeking a skilled and experienced Power BI and SQL practitioner to deliver business intelligence services. It will encompass developing, updating, and presenting Power BI and SQL reports, participating in BI dashboard development, managing BI tools, strategically displaying insights and results via visualization tools, and contributing to organizational growth.
Roles and responsibilities :
- Convert business requirements into technical specificities
- Design, develop, and deploy BI solutions such as reporting tools
- Build analysis services reporting models via SQL scripting and designing queries
- Think analytically to convert data into actionable form and present the same to associated team members.
- Conduct unit testing and troubleshooting
- Maintain and support platforms for data analytics
- Enhance and optimize existing BI systems
- Establish row-level data security while comprehending Power BI's application security layer models.
- Integrate and alter the data while connecting and updating it from different SQL sources.
- Develop dynamic and attracting dashboards and reports using Power BI
- Create charts and data documentation comprising a description of parameters, techniques, relationships, and models
- Spot key performance indicators with apt objectives
- Design multi-dimensional data models
- Run DAX queries and functions in Power BI
Required Specifications and Skills :
