Data Analyst II

Comerica Bank; Town of Texas, San Francisco (WI, CA); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading company in the banking sector is seeking a Data Analyst II to join their Enterprise Data & Analytics team. This role involves providing analytical support, delivering data pipelines, and ensuring data quality. The ideal candidate will have extensive experience in data structures, reporting, and visualization tools. The position requires strong communication skills and the ability to lead projects effectively. Join us to help drive data-driven decisions and strategies within the organization.

Benefits

Health Insurance

Retirement Plan

Paid Time Off

Qualifications

• Minimum 4 years of technology experience.
• At least 3 years leading large, complex projects.

Responsibilities

• Deliver complex ad hoc reports and dashboards based on business requirements.
• Maintain data and visualization capabilities to ensure quality.
• Provide business intelligence advice and insights to support decision-making.

Skills

Data Structures

Statistical Analysis

Data Cleansing Techniques

SQL

Education

Bachelor's Degree

Tools

Power BI

Tableau

Microsoft Office

Collibra

Informatica

Snowflake

Python

R

Job description

Data Analyst II

The Data Analyst II will serve as a member of an Enterprise Data & Analytics team, providing visualization, analytical, and architecture support for complex data systems and documenting data requirements. This role involves delivering data pipelines, reports, dashboards, and insights from multiple data sources, ensuring high-quality data and supporting data preparation for analytics. The Data Analyst II also supports manual and automated data quality processes and recommends methodologies to improve data quality and analytical processes. Additionally, they serve as a source for business and data requirements for strategic data initiatives.

Position Responsibilities:

Delivery Excellence

• Assist in leading a collaborative product planning process aligned with company and technology strategies.
• Work with Data Product Management, Data Governance, and Information Architects to develop structured plans for product releases.
• Decompose the Product Vision and Roadmap into themes captured in the Data Product Backlog.

Reporting

• Deliver complex ad hoc reports and dashboards based on business requirements.
• Oversee junior team members in delivering customized reports and dashboards.
• Maintain data and visualization capabilities to ensure quality and support reuse.
• Oversee reporting activities, providing insights to decision-makers.
• Perform routine quality checks on data assets and address data quality issues.
• Support enterprise data strategy by delivering requirements for report automation, SLAs, and data quality thresholds.

Data Wrangling and Modeling

• Manipulate, map, and integrate data from various sources to support data value delivery.
• Conduct ad hoc data quality checks and support issue remediation.
• Provide requirements for data design supporting strategic assets.
• Ensure data integration conforms to enterprise and domain data models.

Insight Delivery

• Provide business intelligence advice and insights to support decision-making.
• Create ad hoc data pipelines for complex analysis.
• Supervise junior team members in delivering data visualization and reporting.

Communication

• Maintain communication with stakeholders to ensure visibility into product status and direction.

Position Qualifications:

• Bachelor's Degree in relevant fields or equivalent experience.
• Minimum 4 years of technology experience.
• At least 3 years of leading large, complex projects.
• Experience influencing organizational strategy.
• 2 years in data structures, modeling, and visualization tools (Power BI, Tableau).
• Proficiency with Microsoft Office tools.
• Experience in banking or related industries.

Preferred Qualifications:

• Proficiency in data profiling, statistical analysis, and data cleansing techniques.
• Strong SQL skills.
• Experience with statistical techniques and data quality issue resolution.
• Knowledge of Collibra, Informatica, Snowflake, and programming languages like Python or R.

Work Category: Category C. Hours: 8:00am - 5:00pm, Monday - Friday. Salary: To Be Determined Based on Experience.

About Comerica

We invest in our employees through comprehensive benefits, including health, retirement, paid time off, and more. Comerica is an Equal Opportunity Employer and values diversity in the workplace.