Enterprise Data Analyst

The Enterprise Data Analyst will own the responsibility to develop, maintain, evolve, and execute a selection of reports on behalf of stakeholders in any business line across the enterprise in alignment with the technologies, best practices, and strategic direction of the Enterprise Analytics team and the Data Management Office.

Essential Job Functions:

• Own the end-to-end report execution process for the Bank's diversity & inclusion data reporting requirements to the Federal Housing Finance Agency for Procurement and Capital Markets.
• Create innovative data solutions for the team's customers, including polished data presentations, visualizations, and reports.
• Analyze legacy data solutions (e.g. Excel workbooks, Access databases) and create replacement solutions that leverage the Enterprise Analytics technology stack.
• Create and maintain documentation as required (e.g. data lineage, metadata, data dictionary, information supply chain).

Other Duties:

• Provide training on supported capabilities.
• Collaborate with other Data Management Office staff as needed to advance the maturity of the bank's overall data management.
• Remove and avoid building roadblocks to delivering business value in a timely manner.

Interpersonal skills:

• Excellent interpersonal skills and the ability to successfully interact with a variety of stakeholders.
• Ability to proactively solve problems and seek to own the resolution of issues throughout their lifecycle.
• Proven ability to manage tasks and deliverables to a successful conclusion in a timely manner
• A patient & adaptable approach to training colleagues of varying experience levels.
• Confidence in raising opportunities for improvement to management for action.
• Takes critical feedback in stride and adjusts approaches accordingly.
• Acts as a point of help and excellent customer service.

Technical skills:

• Demonstrated expertise with writing SQL queries for data analysis purposes.
• Expertise in using Excel for analysis and reporting, including formulas, Pivot tables, and charts
• Experience with visualization and reporting tools (e.g., Qlik Sense, Tableau, Crystal Reports, SAP WebIntelligence (WebI)).
• Experience with developing analyses and data preparation routines via Python is not required but is a plus

Non-technical skills:

• Strong analytical skills with the ability to collect, organize, analyze, and distill succinct insights from significant amounts of raw data.
• High attention to detail and self-driven pursuit of accuracy.
• Ability to clearly capture customer requests in writing, develop distinct user stories, and craft thorough and clear documentation of developed solutions.

Required Experience

• 2-3 years' experience as a data analyst
• 1-2 years in a variety of report development and/or dashboard creation roles
• Experience in a customer-facing capacity (internal or external)

Education

• Bachelor's degree or equivalent years of experience. Professional experience will be considered in lieu of education.

Salary Range: $115,000 - $125,000

Skills: