data analyst Murrieta, CA
Job description
At Cumming Group, you will work on some of the world's most exciting projects in a dynamic environment where your success is measured by the impact you make. We are one of the fastest-growing project and cost management consultancies in the United States, as reflected in our top 20 ranking in ENR. With over 50 offices globally, an extremely diverse project portfolio, and double-digit year-over-year revenue growth, the opportunities to make your mark are limitless!
We are seeking a skilled and detail-oriented Data Analyst with a strong focus on financial data analysis to join our team. They will use their skills in procuring and cleaning data, and providing insights primarily, but not limited to data from our ERP system. As needed, these queries will lend themselves to self-service Power BI reports. The Data Analyst reports to the Director of Data Architecture and is part of the company’s IT Applications/Data team which focus on supporting strategic business initiatives using custom built solutions.
- Identify and gather relevant financial data from various sources such as SQL Server, Excel documents, CSV files
- Ensure data accuracy and integrity through data cleaning, validation, and preprocessing techniques
- Identify data quality issues and collaborate with the ERP administrator to get them resolved
- Assist with the production of custom reports in SSRS for integration to the ERP system
- Collaborate with data team members on creating data pipelines and Power BI reports
- Utilize data visualization techniques to present findings and communicate complex concepts to stakeholders effectively
- Prepare and deliver clear and concise reports, dashboards, and presentations summarizing financial analysis findings
- Provide ongoing monitoring and updates on financial KPI’s and metrics.
- Bachelor of Science degree in computer science, business, or related technical fields.
- Strong understanding of SQL and experience writing complex queries.
- Experience writing Python a plus.
- Working experience on SQL Server database development.
- Experience using visualization tools such as Tableau and Power BI.
- Proficient using Microsoft Excel (pivot tables and charts).
- Experience working with ERP systems such as Deltek Vision/Vantagepoint.
- Detail oriented, analytical, and inquisitive.
- Ability to work independently and with others.
- Ability to work well under pressure.
Cumming provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
