Client Data Analyst Job Listing at City National Bank in Newark, DE (Job ID 84627)

Description

If you are hired to this position, you will be employed by Magnit Global. You will not be employed by City National Bank.

The Opportunity

Construct, design, write and document complex programs using Business Intelligence Tools (e.g. Business Objects, SAS, SQL, Crystal Reports) to gather statistical data, ensuring that the most efficient procedures are used to access, investigate, and analyze data.

The Responsibilities

Reporting:

• Collaborate with stakeholders to understand business requirements for reporting needs
• Design and format reports to meet business needs and standards
• Validate report data to ensure accuracy and consistency
• Ensure compliance with regulatory requirements and company policies
• Maintain documentation and ensure all reporting processes are organized and well-documented
• Create and maintain documentation of configurations, processes and procedures within the reporting function
• Establish automation and efficiencies around data and reporting functions
• Leverage expert Business Intelligence (BI) platform skills on one or more platforms to incorporate advanced calculations, develop more advanced data flows and assemble complex consolidated dashboards/reports for presentations.
• Apply standards, templates and themes to create uniform sets of visuals for a given audience. Use knowledge of the principles of visual perception to provide refinement to dashboards/reports, providing rich information in a dynamic and understandable way.
• Create templates for data dashboards/reports for use by data visualization team to support consistency and clarity across data visualizations.
• Implement identified best practices in navigating and publishing BI reports, providing access, managing permissions, and monitoring visualization usage by data users.
• Use knowledge of programming languages to work with data teams to query, structure and model data, as needed, for use in dashboards/reports.
• Use expert knowledge of business and technical metadata, data quality, and issue remediation to create accurate data models within BI tool(s).
• Drive business insights through the development of descriptive, diagnostic, and predictive reporting by selecting appropriate advanced visuals that identify trends and outliers.
• Mentor less experienced team members in the use of dashboard/report templates, data visualization best practices and facilitate learning opportunities.
• Work with business partners to conduct dashboard/report testing and recommend refinements.

Data Analyst:

• Construct, design, write and document complex programs using Business Intelligence Tools (e.g. Business Objects, SAS, SQL, Crystal Reports) to gather statistical data, ensuring that the most efficient procedures are used to access, investigate, and analyze data.
• Develop, analyze, report and interpret complex data for ongoing activities/projects. Ensure that all data is accurate and available to meet establish deadlines.
• Migrate data from various sources to new systems or platforms.
• Work closely with cross-functional teams to ensure the successful transfer of data while maintaining data integrity and security.
• Analyze existing data sources and develop migration strategies.
• Design and implement data migration processes, including data extraction, transformation, and loading (ETL).
• Develop scripts and programs using SQL to automate data migration tasks.
• Working knowledge of databases (Microsoft SQL, Oracle, DB2), programming (XML, JavaScript, or ETL frameworks).
• Collaborate with stakeholders to define data mapping rules and ensure accurate data transfer.
• Perform data quality checks and resolve any issues or discrepancies.
• Monitor data migration progress and provide regular updates to project teams.
• Ensure compliance with data protection regulations and security protocols.
• Perform mass data imports/exports using the API or various import tools.
• Technical experience regarding data models (logical and physical) database design development, data mining and segmentation techniques.

The Qualifications

• Experience with Business Intelligence (BI) platforms such as Tableau, Power BI, or similar tools.
• Experience in data analysis, migration, and reporting, with hands-on knowledge of SQL, ETL frameworks, and programming languages (e.g., JavaScript, XML).
• Familiar with effective approaches and practical experience in data migration, data quality, master data management, and data security, including the use of relevant tools.
• Project management experience in cross-functional teams with the ability to manage competing priorities.
• Document migration processes, procedures, and outcomes

This is the pay range that Magnit reasonably expects to pay for this position: $66.66/hour - $71.42/hour

Benefits: Medical, Dental, Vision, 401K