> Markdown version of [/jobs/ext/683995-data-analyst](https://www.wearedevelopers.com/jobs/ext/683995-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Analyst

- **Company:** THE CITY NATIONAL BANK
- **Location:** Newark, NJ, United States (Remote available)
- **Experience:** Expert
- **Salary:** $101,231.0 - $172,355.0
- **Contract:** Permanent contract
- **Skills:** Sql Data Warehouse, Microsoft Excel, Business Analytics Applications, Data Control, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Design, Database Development, Python (Programming Language), Meta-Data Management, NumPy, Microsoft PowerPoint, Query Optimization, SQL Stored Procedures, SQL Databases, Tableau (Software), Data Processing, Snowflake, Git, Fastapi, Pandas, Software Version Control, Data Pipelines, Alteryx
- **Published:** June 28, 2026
- **Apply:** https://www.dice.com/job-detail/3b69a13a-2958-489e-b121-f97523e4112a

## About the Role

* Expert-level SQL development and database design
 * Advanced Python proficiency (pandas, NumPy, data processing libraries)
 * Advanced Tableau skills (calculated fields, parameters, LOD expressions)
 * Strong experience with MS Excel, PowerPoint, and version control systems (Git)
 * Working knowledge of bank processes, controls, and regulatory requirements
 * Ability to understand business context and translate it into technical solutions
 * Experience building automated data transformation workflows and metadata management
 * Excellent communication skills and ability to collaborate across technical and business teams
 * Experience in formal risk controls environments with scheduled deliverables
 * Preferred: regulatory reporting experience and Alteryx knowledge
 * Minimum 5 years of experience with SQL and advanced query optimization
 * Minimum 5 years of professional Python development experience
 * Minimum 5 years of experience with Tableau (dashboard design, reporting, visualization)
 * Minimum 3 years of experience in banking/operations
 * Proficiency with Snowflake or similar cloud data warehouse platforms, * Bachelor's Degree or equivalent
 * Minimum 5 year's experience in analytics and reporting, using data to derive business insights
 * Minimum 5 year's relevant experience in financial services.

## Description

* Develop and optimize SQL queries and stored procedures to extract, transform, and load data from various sources into Snowflake and other data warehouses
 * Build Python applications and scripts for automated data collection, validation, and quality checks at scale
 * Design and implement interactive Tableau dashboards and visualizations to communicate complex data insights to stakeholders
 * Engineer data pipelines and ETL processes that improve reporting timeliness and accuracy
 * Lead data quality improvement initiatives using Python-based testing and validation frameworks
 * Architect scalable data solutions aligned with governance frameworks and regulatory standards
 * Document technical requirements, validate solutions, and establish data controls and validation checks
 * Collaborate with technical and non-technical teams to translate business requirements into robust code and processes
 * Mentor development teams and foster best practices in analytics development and continuous improvement


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript)
- [Vectorize all the things! Using linear algebra and NumPy to make your Python code lightning fast.](https://www.wearedevelopers.com/videos/562-vectorize-all-the-things-using-linear-algebra-and-numpy-to-make-your-python-code-lightning-fast)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [Getting to Know Your Legacy (System) with AI-Driven Software Archeology](https://www.wearedevelopers.com/videos/1437-getting-to-know-your-legacy-system-with-ai-driven-software-archeology)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)