Senior Data Analyst


Irvine, CA

Industry: Financial Services


Not Specified years

Posted 295 days ago

  by    Nick Punjerle

This job is no longer available.


Position Title: Senior Data Analyst w/BSA Skills

Location : Irvine, CA

Position Comments:

We currently have a position within our group, Data Analyst with BSA skills and this is a long.. very long term role (may go on for years.. indefinitely). This individual will query data and will need strong SQL (advanced) and the following requirements:

  • Savvy with data
  • Present data to business
  • Make recommendations
  • Make sure the data is complete
  • Explain why the data needs to be modified, etc.
  • Strong Excel skills
  • Excellent communication skills
  • Background in MDM projects is a plus

Job Description:

Data Profile ?Investigate possible sources data within the enterprise where relevant data are present. Deep understanding of data sources and data models; understanding how data supports the enterprise as well as value of its future potential and apply this understanding to make recommendations. In support of data-related projects perform qualitative research by interview/group discussion with biz stakeholders, current State analysis, reporting (ad-hoc and regular) and future state/what if analysis. 


Data Quality ?Ad-hoc and regular, proactive and reactive analysis; work with Stakeholders and SMEs to develop and track Data Quality and Integrity measures using various reporting tools and dashboards; review, report and resolve Data Quality issues. Start with messy data points (unstructured and structured) and use the math/statistics and programming skills to clean, massage and organize the data  


Business Analysis ? Collaborate with business stakeholders to capture user and project requirements, document data flows, create clear and concise output and/or reports, functional testing  


Business Systems Analysis ? Translate business requirements to technical specifications; collaborate with IT to develop technical solutions; document solutions; solution testing; identify and document technical defects and drive resolution; assess and troubleshoot data issues and drive resolution


Presentation Ability: Create presentations, excel reports, word documents etc. to clearly convey the finding to business and technical stakeholders


MDM ? Understanding and application of MDM concepts; use MDM tools to identify, report and monitor data flow, processes and quality; utilize MDM functionality to improve processes and quality


Core Skills

?        Strong logical analysis capability of business problems

?        Strong communication and presentation skills (written and verbal)

?        Advanced SQL querying ability

?        Advanced Spreadsheet usage (Excel chart, pivot tables, macros)

?        Background in MDM projects

$110K - $120K