What are the responsibilities and job description for the Jr. Data and Cost Analyst position at Brio Solutions LLC?
Are you a data analyst who also has an interest in project controls (cost)?
We are seeking a talented individual to join our team and work onsite at a major transportation client. The qualified candidate will be required to work in a team environment and under a general level of guidance and direction. Will be required to assist and provide direct support to the project teams.
- Work with stakeholders to automate manual reporting and create interactive business intelligence tools and dashboards.
- Utilize your expertise in Power BI, leveraging DAX to design, develop, and maintain interactive dashboards, reports, and visualizations that provide valuable insights to the project teams.
- Develops reporting in Excel using advanced features such as pivot tables, formulas, graphs, and macros as needed.
- Familiar with mySQL or Oracle database and can run SQL to query records.
- Status/Cost Tracking and Analysis ‐ Assists with data collection and implementation of accounting methods, budget tracking, earned value analysis, status reports, and cost projections based on Project Manager or Senior Project Control Specialist direction.
- Assist Senior Project Control Specialist in updating monthly cost data into cost management system.
- Collaborate with management and operational teams to understand business requirements and provide data-driven insights and recommendations.
- Design and create visualizations and dashboards to help communicate findings and results effectively to stakeholders.
Required Skills:
- Bachelor’s degree (or higher) in Business, Engineering, Accounting, Project Management, or related field.
- Minimum 2 years of professional experience in USA in data analytics or project controls.
- 1 year of hands-on experience with data visualization platforms (Power BI or Tableau)
- Working knowledge of at least one of the following coding languages: C , VB, Python, SQL, HTML
- Must be proficient in Microsoft Excel, Word, and PowerPoint
- Excellent problem-solving abilities and keen attention to detail.
- Ability to build efficient working relationships with project teams and department staff.
- Excellent written and verbal communication skills.
- Superior organizational and planning skills.
Desired Skills:
- 1 year of SQL experience
- Experience analyzing data and developing reports and dashboards using Power BI data visualization.
- 1 year of experience with Python for data analytics (pandas, sklearn, matplotlib, seaborn, plot.ly)
- Experience with Cost Engineering software tools.
- Strong SQL skills for querying and manipulating data.
- Knowledge of Oracle Business intelligence (BI).
- Knowledge of Oracle Primavera Unifier
Job Type: Part-time with an opportunity to convert to Full-time
This is a hybrid position.
Job Type: Part-time
Pay: $35.00 - $40.00 per hour
Benefits:
- Flexible schedule
- Paid time off
Schedule:
- 4 hour shift
Application Question(s):
- Do you have at least 1 year of experience working as a professional either as a data analyst or project controls in USA?
Education:
- Bachelor's (Required)
Experience:
- Power BI: 1 year (Required)
- MySQL: 1 year (Preferred)
- project controls: 2 years (Preferred)
- Data analysis skills: 2 years (Required)
- Business intelligence: 2 years (Preferred)
- Project management: 1 year (Preferred)
Work Location: Hybrid remote in Los Angeles, CA 90012
Salary : $35 - $40