Business Data Analyst - Financial Services
Portland, ME, USA
Arkatechture
Arkatechture is a data & analytics consulting firm in Portland, ME that provides the expertise, tools, and training needed for true business intelligence.Department: Professional Services
Employment Type: Full Time
Location: Portland, ME, USA
Description
Why Work Here?At Arkatechture, we have a simple shared mission: to build a sustainable organization built upon three pillars: Do something meaningful, With a great team, Earning what you deserve.We started in 2012 with a passion for data, business, and getting things done. We are a team of data lovers and technical experts who use our skills to help businesses big and small harness, utilize, and optimize their data. As New England’s Data Resource, we are a small company constantly evolving to keep up with changing landscapes in the data world.
We are proud of the community and culture that we’ve created at Arkatechture, and we have no intention of slowing down. We offer a competitive benefits package that includes:
- A flexible work-from-home policy (Work 100% Remote!)
- Open-concept office in Portland, ME with an easy-going dress code, and fresh pots and pops all day (that’s coffee and popcorn!)
- Training & certificate reimbursement
- A competitive benefits package that includes medical, disability, life insurance and optional dental/vision
- 401K Retirement planning with company matching
- Generous paid time off and eleven paid holidays
- Employee recognition through milestone awards including annual PTO increases, as well as a 4 day work-week at 3 years of service!
As a Business Data Analyst, responsibilities include data analysis, data profiling, data mapping, and developing SQL views. This role requires proficiency in interpreting data, trends, patterns in complex data sets, technical expertise with data models, databases and reporting tools like Tableau or PowerBI. The ability to interpret and use artifacts like business requirement documents, system requirements documents, critical data element identification and classification, requirement traceability matrix, workflows, data mapping, etc. is required. The ideal candidate will be able to work efficiently with the business and the technology teams collaborating with the project/program managers. This position has the opportunity to be 100% remote if desired.
Key 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
Skills, Knowledge and Expertise
Minimum Qualifications- 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 judgement in making decisions
- Ability to analyze, organize and prioritize work while meeting multiple deadlines
- Ability to handle confidential information with discretion
- 2+ years as a Subject Matter Expert in Financial Services, especially Commercial and/or Consumer lending and/or AML
- Understanding of cloud platforms such as AWS, Azure, GCP
- Experience developing and implementing dbt models
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile AWS Azure Big Data Business Intelligence Classification Data analysis Data Analytics Databricks Data management Data quality Data warehouse Data Warehousing dbt GCP Market research MySQL Oracle PostgreSQL Power BI Research SDLC Snowflake SQL Tableau Testing
Perks/benefits: Career development Flex hours Flex vacation Health care Insurance
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs