Senior IT Analyst
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior IT Analyst in Rosemead, CA, on a long-term contract at $60.00 - $65.00 per hour. Requires 5-7 years of experience, SQL and Power BI expertise, and strong analytical skills. On-site work is mandatory.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
520
🗓️ - Date discovered
May 21, 2025
🕒 - Project duration
Unknown
🏝️ - Location type
On-site
📄 - Contract type
Unknown
🔒 - Security clearance
Unknown
📍 - Location detailed
Rosemead, CA
🧠 - Skills detailed
#Data Analysis #Microsoft Power BI #SQL Queries #Datasets #Tableau #Project Management #Data Integration #"ETL (Extract #Transform #Load)" #Databases #Data Manipulation #Qlik #DAX #SQL (Structured Query Language) #Data Extraction #Data Modeling #BI (Business Intelligence) #Visualization #Data Accuracy #Data Mining #Data Integrity
Role description
Position Project Analyst IV
Location Rosemead, CA
Duration Long Term Contract
Job duties may include: Apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments; meet with decision makers, systems owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues...Education/Experience: Bachelor Degree in applicable profession, business, or technical discipline or an equivalent combination of education, training, and experience. Possesses five to seven years of experience. .
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.
Required Skills/Attributes
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.
Domain Knowledge:
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
Job Type: Contract
Pay: $60.00 - $65.00 per hour
Expected hours: 40 per week
Schedule:
8 hour shift
Experience:
Analysis skills: 9 years (Required)
SQL: 10 years (Required)
Power BI: 4 years (Required)
Dashboard development: 5 years (Required)
Data Extraction: 5 years (Required)
Data mining: 5 years (Required)
ETL: 5 years (Required)
Tableau: 5 years (Required)
Work Location: On the road
Position Project Analyst IV
Location Rosemead, CA
Duration Long Term Contract
Job duties may include: Apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments; meet with decision makers, systems owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues...Education/Experience: Bachelor Degree in applicable profession, business, or technical discipline or an equivalent combination of education, training, and experience. Possesses five to seven years of experience. .
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.
Required Skills/Attributes
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.
Domain Knowledge:
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
Job Type: Contract
Pay: $60.00 - $65.00 per hour
Expected hours: 40 per week
Schedule:
8 hour shift
Experience:
Analysis skills: 9 years (Required)
SQL: 10 years (Required)
Power BI: 4 years (Required)
Dashboard development: 5 years (Required)
Data Extraction: 5 years (Required)
Data mining: 5 years (Required)
ETL: 5 years (Required)
Tableau: 5 years (Required)
Work Location: On the road
