Data Analyst Ii

Job Description
EKN Engineering is a fast-growing civil engineering and technology consulting company located in Irvine, CA. We are looking foraData Analyst II tojoin us on our quest to further invent and innovate.
As a Data Analyst II, you will liaise with both internal and external stakeholders to anticipate their needs and help foster a data-led culture. You should be able to work with both technical and non-technical teams to define and measure key business metrics and use them in insightful reports. The successful candidate will turn data into information, information into insight, and insight into business decisions.
Responsibilities

• Interpret data, analyze results, and identify opportunities for new reporting.
• Validate data by continually reviewing both reports and data sources for accuracy and consistency.
• Create and maintain reports and dashboards in Microsoft Excel and Power BI.
• Administer and improve the data management system, including deployment pipelines.
• Establish KPI's to measure the effectiveness of business decisions.
• Create presentations and reports based on recommendations and findings.
• Work with management to prioritize business and information needs.

Requirements

• 5-7 years of work experience as a Data Analyst.
• Proficiency with Microsoft Excel.
• Intermediate-level proficiency using SQL or similar query language.
• Exceptional problem-solving, technical, and analytical skills.
• Bachelors' degree in Data Analytics, Mathematics, Statistics, or related field.
• Experience with Microsoft Power BI or Tableau or similar data visualization software.
• Competence managing various aspects of a data pipeline, including data validation, data management, data analysis and data visualization.