About

• A flexible work-from-home policy
• 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!

• Expert level professional role, considered subject matter expert with in-depth knowledge/expertise in Financial Services
• Advanced analytical and problem solving skills
• Fluent in SQL and Python
• Works autonomously on a range of tasks
• 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 cloud 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

• Bachelor's Degree in a relevant field or 2-5 years of experience in a similar role
• Expert level familiarity with Collibra
• Expert in complex SQL syntax
• Understanding of Azure cloud platform
• 1-3 years of experience with Collibra
• Fluent in Python
• Domain expertise in Financial Services working with Banks and/or Credit Unions focused on Credit Card portfolios and specifically Retail Card Services 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 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
• 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, time line 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 member of a team and independently
• 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 

• 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