What are the responsibilities and job description for the Power BI and SQL Developer position at APR Consulting?
An electric utility client is looking for a PowerBI and SQL Developer who will collaborate with SQL developers to extract and transform data suitable for analysis and design and develop Power BI dashboards and reports based on business requirements.
Location: Rosemead, CA 91770 (HYBRID)
Position: PowerBI and SQL Developer
Pay Rate: $83/hr. on W2
Duration: 8 months or longer
Schedule: M-F, 8:00 am – 5:00 pm, In office Monday and Tuesday.
***OPEN ALSO FOR REMOTE***
RESPONSIBILITIES:
Data Extraction & Transformation:
Location: Rosemead, CA 91770 (HYBRID)
Position: PowerBI and SQL Developer
Pay Rate: $83/hr. on W2
Duration: 8 months or longer
Schedule: M-F, 8:00 am – 5:00 pm, In office Monday and Tuesday.
***OPEN ALSO FOR REMOTE***
RESPONSIBILITIES:
Data Extraction & Transformation:
- Collaborate with SQL developers to extract and transform data suitable for analysis.
- Write SQL queries to gather necessary datasets from databases.
Dashboard Development:- Design and develop Power BI dashboards and reports based on business requirements.
- Ensure dashboards are visually appealing and user-friendly.
Data Modeling:- Create and manage data models in Power BI, ensuring accurate relationships between datasets.
Performance Optimization:- Optimize Power BI reports for performance, reducing loading times and enhancing user experience.
- Debug and resolve any issues that arise with the Power BI dashboards.
User Training & Support:- Provide support and training to end-users, helping them understand and interact with the dashboards effectively.
Maintenance & Updates:- Regularly update dashboards with new data, maintaining data integrity and relevance.
- Monitor dashboard performance and user feedback for continuous improvement.
Collaboration:- Work closely with stakeholders to gather requirements and iterate on dashboard designs.
- Participate in team meetings to discuss progress, challenges, and roadmap.
QUALIFICATIONS:- A Bachelor's degree is required.
- Being able to write SQL code expertly, then moving information to PowerBI.
- Manager will ask their Analytical skills, time management, project management, and what kind of tools they used for project management. SQL expertise and PowerBI are the main questions they will also ask on the interview
- Strong SQL background is the most important requirement.
- Open to do remote, but must be working in the US and can work PT hours.
SQL Expertise:- Strong understanding of SQL for data extraction, manipulation, and transformation.
- Ability to write and optimize complex SQL queries.
Power BI Expertise:- Proven experience in developing dashboards and reports in Power BI.
- Knowledge of Power Query and DAX (Data Analysis Expressions) for data manipulation.
Data Visualization Principles:- Understanding of data visualization best practices to create clear and impactful dashboards.
Analytical Skills:- Strong problem-solving skills with the ability to analyze data trends and provide insights.
Attention to Detail:- Meticulous in ensuring data accuracy and integrity throughout the dashboard development process.
Communication Skills:- Effective communication skills to liaise with technical and non-technical stakeholders.
User Experience (UX) Awareness:- Awareness of user experience design principles to enhance dashboard usability.
DESIRED SKILLS/ATTRIBUTES:
Experience with Other BI Tools:- Familiarity with other business intelligence tools (e.g., Tableau, Qlik) can be an asset.
Knowledge of ETL Processes:- Understanding of Extract, Transform, Load (ETL) processes and tools for data integration.
Project Management Skills:- Ability to manage projects, timelines, and prioritize tasks efficiently.
About our client:
Our client is one of the largest electric utilities and a longtime leader in renewable energy and energy efficiency in the United States providing electricity for much of Southern California.
About APR:
Since 1980 APR Consulting, Inc. has provided professional recruiting and contingent workforce solutions to a diverse mix of clients, industries, and skill sets nationwide.
We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Don't miss out on this amazing opportunity! If you feel your experience is the match for this position please apply today and join our team. We look forward to working with you!
#SLA
- Ability to manage projects, timelines, and prioritize tasks efficiently.
- Understanding of Extract, Transform, Load (ETL) processes and tools for data integration.
- Familiarity with other business intelligence tools (e.g., Tableau, Qlik) can be an asset.
- Awareness of user experience design principles to enhance dashboard usability.
- Effective communication skills to liaise with technical and non-technical stakeholders.
- Meticulous in ensuring data accuracy and integrity throughout the dashboard development process.
- Strong problem-solving skills with the ability to analyze data trends and provide insights.
- Understanding of data visualization best practices to create clear and impactful dashboards.
- Proven experience in developing dashboards and reports in Power BI.
- Strong understanding of SQL for data extraction, manipulation, and transformation.
- A Bachelor's degree is required.
- Work closely with stakeholders to gather requirements and iterate on dashboard designs.
- Regularly update dashboards with new data, maintaining data integrity and relevance.
- Provide support and training to end-users, helping them understand and interact with the dashboards effectively.
- Optimize Power BI reports for performance, reducing loading times and enhancing user experience.
- Create and manage data models in Power BI, ensuring accurate relationships between datasets.
- Design and develop Power BI dashboards and reports based on business requirements.
Salary : $83