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 Englands 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 weve created at Arkatechture, and we have no intention of slowing down. We offer a competitive benefits package that includes:

* Open-concept offices in Portland, ME & a flexible work-from-home policy

* An easy-going dress code

* 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 ten paid holidays

* An annual bonus based on company performance

* Employee Stock Appreciation Rights (SAR) Program

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 Senior Data Analyst position to support BI and Data warehousing initiatives.

As a Senior Data Analyst, responsibilities include data analysis and mining, data profiling and data mapping. Data Analysis requires proficiency in interpreting data, trends, patterns in complex data sets, technical expertise with data models, databases and reporting packages like Tableau or Business Objects. The ability to interpret and use artifacts like business requirement documents, system requirements documents, 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.

***How to Apply*** Please send a cover letter and resume with your application. **You must submit all requested documents to be considered for the position.**

Location Portland, ME, USA Department Delivery Employment Type Full Time ** Key Responsibilities**

* Requirement gathering for Data pipeline development

* 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

* 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 5-8 years of experience in a similar role

* Expert in complex SQL syntax

* 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, SQLServer, Oracle, Aurora, PostgreSQL, Redshift, MySQL, Teradata, Vertica, etc

* A strong understanding of Agile software development life cycle and methodology

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

***Preferred Experience***

* Understanding of cloud platforms such as AWS

** About Arkatechture**

**At Arkatechture, we love data we play with it and learn from it every day, and we want you to love your data, too.**

Department Delivery Employment Type Full Time Location Portland, ME, USA