71 applicants

Company

Original Job Post

Arkatechture · 3 days ago

Business Data Analyst - Financial Services

Portland, ME

Full-time

Onsite

Mid Level

2+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AnalyticsBanking

Growth Opportunities

Insider Connection @Arkatechture

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Expert level professional role, considered subject matter expert with in-depth knowledge/expertise in Financial Services with experience in AML preferred

Advanced analytical and problem-solving skills

Fluent in one or two programming languages

Works autonomously on a range of tasks and may be relied upon to coach/educate others

May lead end-to-end processes or functional programs

In-depth experience working with very large datasets and familiarity with big data technologies

Supports business teams in the use and understanding of the data and reporting solutions

Develops data road map/information management strategies and corresponding technical solutions on integrating, transforming, and/or managing data

Drives data-centric solution development focusing on complex data integration

Solicits, analyzes, and understands data requirements (i.e., using market research, requirements gathering, feature planning, user experience / design considerations, etc.) to enable development of information management solutions

Managing client interactions and growing client relationship during projects

Develop Source to Target Mappings

Data Profiling, analyzing source system data and metadata and collect requirements for data ingestion into a data warehouse

Developing and deconstructing complex SQL, Common Table Expressions, Stored Procedures, and Views for Business Conformance layers

Data Cleansing, Data Quality assessments and developing data quality rules

Implementing data warehouses, data collection systems, data analytics and other strategies that optimize business intelligence and analytical efficiency and quality

Building reference data for hierarchies, lookups and grouping purposes

Acquiring data from primary or secondary data sources and developing and maintaining Data Dictionaries, Critical Data Identification and Classification, Data Lineage, and Data Quality rules

Identify, analyze, and interpret trends or patterns in complex data sets

Filter and "clean" data by reviewing reports and key performance indicators to locate and correct code problems

Testing using SQL and providing development sign off

Mentoring & review SQL code and deliverables of junior & mid-level Data Analysts

Locate and define new process improvement opportunities

Documentation of processes and workflows

Additional responsibilities as assigned

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLFinancial servicesCredit unionsCredit lifecycleAMLSnowflakeSQL ServerDatabricksOraclePostgreSQLMySQLAgileData managementSales supportData analysisAnalytical toolsData lakesData warehousingProblem-solvingAnalytical thinkingCommunicationCollaborationRelationship buildingIndependenceJudgmentOrganizationDeadline managementConfidentialitySubject Matter ExpertCommercial Lending

Required

Bachelor's Degree in a relevant field or 2-5 years of experience in a similar role

Expert in complex SQL syntax

Domain expertise in Financial Services working with Banks and/or Credit Unions, preferably focused on full credit lifecycle for Commercial and/or Consumer lending and/or AML

Enthusiastic, learner and driven with a positive attitude

Strong critical and analytical thinking and problem-solving skills

Experience working on multiple databases such as Snowflake, SQL Server, Databricks, Oracle, PostgreSQL, MySQL, etc

A strong understanding of Agile software development life cycle and methodology

Experience working on Data Management projects for Data Lakes/Data Warehousing

Experience driving and growing client interaction as part of sales support and project delivery

Analytical and problem-solving skills are required to interpret data and draw conclusions

Skill in using analytical software tools, data analysis methods and reporting techniques

Ability to communicate effectively in both oral and written form

Ability to work collaboratively and build relationships

Ability to work successfully as a member of a team and independently

Ability to exercise sound judgment in making decisions