Senior Data Analyst Delivery Portland, ME, USA full_time

3 weeks ago

Portland, United States Arkatechture Full time

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

  • Senior Project Manager Delivery Portland, ME, USA

    3 weeks ago

    Portland, United States Arkatechture Full time

    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...

  • Senior Software Engineer Delivery Portland, ME, USA

    3 weeks ago

    Portland, United States Arkatechture Full time

    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...

  • Shipping Receiving

    4 weeks ago

    Portland, United States LUCAS TREE SERVICE INC Full time

    **Shipping Receiving / Portland, ME** Fleet & Logistics Portland, Maine Minimum Experience **Entry-level** Compensation **$15-$18/hour** Lucas Tree Experts is in search of a Warehouse Specialist to join the team in Portland, ME. Individual will verify and maintain records on incoming and outgoing shipments. Prepare items for shipment. Duties include...

  • CRNA job in: Portland, ME

    3 days ago

    Portland, United States Archway Physician Recruitment LLC Full time

    CRNA opening in Portland, ME Seeking a full-time CRNA to join its professional and supportive anesthesia practice in Portland, Maine. Full-time The right candidate will join a collaborative and congenial team of CRNAs and anesthesiologists who provide pediatric and adult anesthesia across multiple surgical specialties including obstetrics. Bright new...

  • CRNA job in: Portland, ME

    13 hours ago

    Portland, United States Archway Physician Recruitment LLC Full time

    CRNA opening in Portland, ME Seeking a full-time CRNA to join its professional and supportive anesthesia practice in Portland, Maine. Full-time The right candidate will join a collaborative and congenial team of CRNAs and anesthesiologists who provide pediatric and adult anesthesia across multiple surgical specialties including obstetrics. Bright new...

  • Paper Products Marketing USA President

    4 days ago

    Portland, United States Paper Products Marketing (USA) Inc. Full time

    About us…Paper Products Marketing (PPM) is a supplier and distributor of various papers and paper products to more than 70 countries. We operate six offices, across Asia and the US to service the requirements of our partner paper mills and our customers around the world. Headquartered in Melbourne Australia, we are a fully owned subsidiary of Opal Group...

  • Events & Experience Specialist (Portland Me)

    5 days ago

    Portland, United States Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...

  • Discover Portland: Travel Operating Room Registered Nurse

    4 weeks ago

    Portland, United States Soliant Full time

    Minimum 1+ years nursing experience required.Discover Portland: Travel Operating Room Registered Nurse - Portland, ME "Life is either a daring adventure or nothing at all." - Helen Keller Are you a skilled and compassionate Operating Room Registered Nurse ready to embark on a new adventure? Soliant Health is seeking a Travel OR RN to join our team for an...

  • Geriatrics opening: Portland, ME

    1 week ago

    Portland, United States Archway Physician Recruitment LLC Full time

    Geriatric Medicine opening in Portland, ME Seeking an organized and compassionate Physician to join its growing Geriatric Care practice three days per week. Full-time Care for patients in nursing homes and long-term care facilities throughout Southern Maine. This is a unique and attractive opportunity to join a team of dedicated geriatricians who meet,...

  • Geriatrics job in: Portland, ME

    13 hours ago

    Portland, United States Archway Physician Recruitment LLC Full time

    Geriatric Medicine opening in Portland, ME Seeking an organized and compassionate Physician to join its growing Geriatric Care practice three days per week. Full-time Care for patients in nursing homes and long-term care facilities throughout Southern Maine. This is a unique and attractive opportunity to join a team of dedicated geriatricians who meet,...

  • Breast Surgery opening: Portland, ME

    1 week ago

    Portland, United States Archway Physician Recruitment LLC Full time

    Breast Care Surgery Opening in Portland, ME Seeking a highly skilled and compassionate Breast Care Surgeon to join our team of healthcare professionals. The ideal candidate will be board-certified in surgery and have completed a fellowship in breast or surgical oncology. Non-fellowship trained welcome to apply. You will be responsible for providing...

  • Class C/DEF Driver

    2 weeks ago

    South Portland, United States Diesel Direct Inc Full time

    Job descriptionDiesel Direct is seeking a qualified full-time DEF Driver in our Portland, ME area. Diesel Direct is a premier one-stop fuel distributor with a focus on safety and customer service. Driver duties would include operating and loading Diesel Direct fuel delivery making local DEF deliveries. The candidate must be able to drive multiple vehicles...

  • Class C/DEF Driver

    5 days ago

    South Portland, United States Diesel Direct Inc Full time

    Job descriptionDiesel Direct is seeking a qualified full-time DEF Driver in our Portland, ME area. Diesel Direct is a premier one-stop fuel distributor with a focus on safety and customer service. Driver duties would include operating and loading Diesel Direct fuel delivery making local DEF deliveries. The candidate must be able to drive multiple vehicles...

  • Custodian - Portland, ME

    3 weeks ago

    Portland, United States Spare Time Entertainment Full time

    ** Custodian - Portland, ME** **Job Category****:** Facilities **Requisition Number****:** CUSTO001560 Showing 1 location **Job Details** **Description** * Complete all items on the cleaning checklist to prepare the facility for guests. * Ensure the building is secure. * Sweep and mop floors strip/wax/buff floors where applicable. * Vacuum and shampoo...

  • Class C/DEF Driver

    3 weeks ago

    South Portland, United States Diesel Direct Inc Full time

    Job DescriptionJob DescriptionJob descriptionDiesel Direct is seeking a qualified full-time DEF Driver in our Portland, ME area. Diesel Direct is a premier one-stop fuel distributor with a focus on safety and customer service. Driver duties would include operating and loading Diesel Direct fuel delivery making local DEF deliveries. The candidate must be able...

  • General Dermatologist

    2 weeks ago

    Portland, United States Optima Dermatology - Physician and Provider Openings Full time

    Multi-site Dermatology and Medical Aesthetics Group Seeks General Dermatologist in Scarborough, ME Optima Dermatology is recruiting a Board Certified / Board Eligible Dermatologist for our Scarborough, ME (greater Portland region) location due to increased patient demand. This position provides a great opportunity for continued growth alongside some of the...

  • Netsuite Analyst

    1 week ago

    Portland, United States Portland Leather Full time

    Portland Leather Goods is seeking a NetSuite Analyst with expertise in supply, manufacturing and ecommerce business functions and integrations. The NetSuite Analyst role will provide internal support for Portland Leather Goods NetSuite ERP users across ecommerce order integration, purchasing, warehouse operations and inventory management. This role will be...

  • Class C/DEF Driver

    7 days ago

    South Portland, ME, United States Diesel Direct Inc Full time

    Job description Diesel Direct is seeking a qualified full-time DEF Driver in our Portland, ME area. Diesel Direct is a premier one-stop fuel distributor with a focus on safety and customer service. Driver duties would include operating and loading Diesel Direct fuel delivery making local DEF deliveries. The candidate must be able to drive multiple vehicles...

  • Internal Medicine opening: Portland, ME

    1 week ago

    Portland, United States Archway Physician Recruitment LLC Full time

    Internal Medicine opening in Portland, ME Full-time 4-day work week BC/BE Internal Medicine Each clinic has lab, imaging, behavioral health, and clinical pharmacists on site to support you as a provider. Hospital employed, with easy access to multiple specialties Collegial and collaborative team with a high level of experience and professionalism Non-profit...

  • Senior Policy Development Manager

    5 days ago

    Portland, United States Port of Portland Full time

    The Position The Port of Portland is Hiring for a. Senior Policy Development Manager! The Port of Portland is seeking a dynamic, self-starter and experienced Senior Policy Development Manager professional to join its Government Affairs Team. In thi Policy, Manager, Development, Senior, Evaluation, Government, Technology