APR Consulting
Power BI and SQL Developer
APR Consulting - Rosemead, California, United States, 91770
Work at APR Consulting
Overview
- View job
Overview
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:
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
Seniority level
Seniority level
Entry level Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Staffing and Recruiting Referrals increase your chances of interviewing at APR Consulting by 2x Sign in to set job alerts for Business Intelligence Developer roles.
Senior Information Systems Analyst - Business Intelligence Specialization
Los Angeles, CA $149,760 - $216,320 1 month ago Enterprise Analytics Manager (Principal Business Intelligence Analyst Tableau)
Rosemead, CA $90,000.00 - $126,500.00 3 weeks ago Business Data Analyst - Ambulatory Admin - Full Time 8 Hour Days (Exempt) (Non-Union)
Business Data Analyst - MSO Clinical Ops - Full Time 8 Hour Days (Exempt) (Non-Union)
Analyst, Business Data - IS Clinical Research - Full Time 8 Hour Days (Exempt) (Non-Union)
Los Angeles, CA $91,728.00 - $146,764.80 2 weeks ago Supply Chain Master Data Analyst - Manufacturing, Omniseal Solution
Contract Data Management Analyst 3/4 (AHT) - R10198567
Chief of Staff to the President Xsolla
Los Angeles, CA $104,832.00 - $142,272.00 1 month ago Los Angeles, CA $111,000.00 - $196,000.00 2 weeks ago Healthcare Business Intelligence Developer
Principal Business Intelligence Engineer
Los Angeles, CA $134,784.00 - $194,688.00 1 month ago Los Angeles, CA $120,000.00 - $145,000.00 2 weeks ago Los Angeles Metropolitan Area 2 weeks ago Santa Monica, CA $120,000 - $145,000 15 hours ago Senior Business Intelligence Developer - IS Dept Apps and Ent Rptg - Full Time 8 Hour Days (Exempt) (Non-Union)
Senior Business Intelligence Developer IS Dept Apps and Ent Rptg - Full Time 8 Hour Days (Exempt) (Non-Union)
Senior Business Intelligence Developer - IS Clinical Research - Full Time 8 Hour Days (Exempt) (Non-Union)
Business Intelligence Engineer, Supply Chain Innovation
Sr. Business Intelligence Engineer (must be local to LA/OC)
Irwindale, CA $120,000 - $130,000 1 day ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
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:
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
Seniority level
Seniority level
Entry level Employment type
Employment type
Contract Job function
Job function
Information Technology Industries
Staffing and Recruiting Referrals increase your chances of interviewing at APR Consulting by 2x Sign in to set job alerts for Business Intelligence Developer roles.
Senior Information Systems Analyst - Business Intelligence Specialization
Los Angeles, CA $149,760 - $216,320 1 month ago Enterprise Analytics Manager (Principal Business Intelligence Analyst Tableau)
Rosemead, CA $90,000.00 - $126,500.00 3 weeks ago Business Data Analyst - Ambulatory Admin - Full Time 8 Hour Days (Exempt) (Non-Union)
Business Data Analyst - MSO Clinical Ops - Full Time 8 Hour Days (Exempt) (Non-Union)
Analyst, Business Data - IS Clinical Research - Full Time 8 Hour Days (Exempt) (Non-Union)
Los Angeles, CA $91,728.00 - $146,764.80 2 weeks ago Supply Chain Master Data Analyst - Manufacturing, Omniseal Solution
Contract Data Management Analyst 3/4 (AHT) - R10198567
Chief of Staff to the President Xsolla
Los Angeles, CA $104,832.00 - $142,272.00 1 month ago Los Angeles, CA $111,000.00 - $196,000.00 2 weeks ago Healthcare Business Intelligence Developer
Principal Business Intelligence Engineer
Los Angeles, CA $134,784.00 - $194,688.00 1 month ago Los Angeles, CA $120,000.00 - $145,000.00 2 weeks ago Los Angeles Metropolitan Area 2 weeks ago Santa Monica, CA $120,000 - $145,000 15 hours ago Senior Business Intelligence Developer - IS Dept Apps and Ent Rptg - Full Time 8 Hour Days (Exempt) (Non-Union)
Senior Business Intelligence Developer IS Dept Apps and Ent Rptg - Full Time 8 Hour Days (Exempt) (Non-Union)
Senior Business Intelligence Developer - IS Clinical Research - Full Time 8 Hour Days (Exempt) (Non-Union)
Business Intelligence Engineer, Supply Chain Innovation
Sr. Business Intelligence Engineer (must be local to LA/OC)
Irwindale, CA $120,000 - $130,000 1 day ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr