_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% remotely!)
Open-concept offices 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 and a 4 day work-week at 3 years of service!

All employees share our core values: put the team first, practice humility, take pride in everything we do, stay curious, care for our community & environment, take work seriously; ourselves not so much.

_The Position
_Arkatechture is seeking candidates for a Program Lead Business Data Analyst position to support Business Intelligence and Data warehousing initiatives focused on our Financial Services clients. This position requires specialization in Credit Card portfolios with specific experience in Retail Card Services on TSYS.

As a Program Lead Business Data Analyst, responsibilities include data analysis, data profiling, data mapping, developing SQL views, and driving progress on projects to meet client objectives. This role requires proficiency in interpreting data, trends, and 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 role is 80% program management and leadership and 20% hands-on data analysis and development. 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.

_How to Apply
_Please send a cover letter and resume with your application. You must submit both documents to be considered for the position.

Key Responsibilities

_Program Management
_

Lead, manage, and execute multiple data analytics programs, ensuring alignment with business goals and timelines.
Provide technical mentorship and guidance to business data analysts, facilitating skill development and knowledge transfer.
Act as a liaison between business stakeholders and technical teams, translating business needs into actionable data strategies.
Collaborate with project managers and account executives to grow client relationships and drive strategic initiatives.
Define and enforce best practices in data governance, data quality, and documentation.
Oversee end-to-end data pipeline development and business intelligence solutions, ensuring efficiency and scalability.
Conduct risk management and proactively identify potential project challenges, developing mitigation strategies.
Drive continuous process improvement, leveraging Agile methodologies to optimize workflows and increase efficiency.
Provide ongoing status reporting to key stakeholders, including project sponsors, program managers, and senior leadership.
Develop project roadmaps, monitor progress, and ensure deliverables meet business and regulatory requirements.
Facilitate cross-functional team collaboration, working closely with data engineers, business analysts, and data scientists to implement robust data solutions.
Advocate for data-driven decision-making, ensuring data analytics initiatives are aligned with overall business strategy.

_Data Analysis & Development
_

Expert level professional role, considered subject matter expert with in-depth knowledge/expertise in Financial Services with experience in Credit Card on TSYS required and Retail Card Services or First Data preferred
Advanced analytical and problem-solving skills
Fluent in SQL and SAS
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
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
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 focused on Credit Card portfolios on TSYS
Enthusiastic, learner and driven with a positive attitude
Strong critical and analytical thinking and problem solving skills
Experience working on multiple databases such as SQL Server, 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
Review, analyze and evaluate detailed business and functional requirements, documentation, process flows and data models to contribute to the development of project plans including project charter, project deliverables, cost/benefits analysis, timeline estimates, scope and control.
Develop use cases, defining and documenting user procedures and workflows, and how each class of user interacts with east system function
Assist in the development of conversion and implementation strategies
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 player/coach
Ability to exercise sound judgment in making decisions
Ability to analyze, organize and prioritize work while meeting multiple deadlines
Ability to handle confidential information with discretion

_Preferred Experience
_

5+ years as a Subject Matter Expert in Financial Services, especially Credit Card on TSYS specifically
Proactively identifies and tracks project risk and develops mitigation plans to manage risk (i.e., risk related to technology, change management, procurement, business process management, requirements management)
Provides on-going communication to key stakeholders, including the Project Sponsor, Business Project Owner, Program Manager and Portfolio Manager to ensure they are aware of significant changes to the project status in a timely manner
Develops, monitors and tracks project plans throughout project lifecycle
Monitors and controls the work related to each deliverable
Familiarity with Backbase, Databricks, PySpark, Azure, dbt, Snowflake, AWS