Technical Data Analyst

Arkatechture; Portland (ME); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading company in data infrastructure and analytics is seeking a Technical Data Analyst. This remote position focuses on supporting the BI & Analytics platform, requiring strong problem-solving skills and expertise in Python and SQL. The ideal candidate will collaborate with clients and team members, ensuring effective communication and delivering high-quality solutions. Join a passionate team dedicated to harnessing data effectively while enjoying a flexible work environment and competitive benefits.

Benefits

Flexible work-from-home policy

Training & certificate reimbursement

401K Retirement planning with company matching

Generous paid time off and eleven paid holidays

4 day work-week after 3 years of service

Qualifications

• 5-8 years of experience in a similar role.
• Experience in Data Warehousing and BI projects.

Responsibilities

• Troubleshoot incidents and problem tickets.
• Gather requirements for Data pipeline integration.
• Develop, review, and test code.

Skills

Python

SQL

Communication

Problem Solving

Education

Bachelor's Degree

Tools

Tableau

PowerBI

AWS

Jira

Confluence

Bitbucket

Job description

Join to apply for the Technical Data Analyst role at Arkatechture

Get AI-powered advice on this job and more exclusive features.

Description

Department: Arkalytics - Product

Location: Remote

Compensation: $70,000 - $90,000 / year

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 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
• 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!

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 Technical Data Analyst position. As a Technical Data Analyst, you will be responsible for ongoing support of our BI & Analytics platform, Arkalytics. This role is crucial within our Product team, focusing on building scalable solutions within the platform. The ideal candidate is a strong problem solver, capable of troubleshooting independently, and a team player eager to grow into a subject matter expert. You will interface with clients occasionally, requiring excellent communication and analytical skills with high attention to detail.

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

• Complete accountability of all assigned tickets to meet sprint goals and team deliverables.
• Troubleshoot incidents and problem tickets to identify root causes and develop resolutions following all change management procedures.
• Gather requirements for Data pipeline integration (ELT) development.
• Gather requirements for Data mapping (business logic).
• Develop, review, and test code (SQL, Python, BI tools like Tableau and PowerBI).
• Maintain active communication with the internal Arkatechture team and occasionally clients.
• Identify process improvements within the Product team.
• Escalate risks and issues promptly.
• Test using SQL and provide documented sign-off.
• Document processes and workflows.
• Facilitate requirements sessions, user training, and client meetings.
• Report work status to team leaders and participate in daily standups.
• Additional responsibilities as assigned.

Skills, Knowledge, and Expertise

Requirements

• Bachelor's Degree or 5-8 years of experience in a similar role
• Expertise in Python and SQL
• Strong experience with databases such as Snowflake, Databricks, SQL Server, Oracle, etc.
• Experience with visualization tools like Tableau or PowerBI.
• Experience in Data Warehousing and BI projects.
• Experience with AWS.
• Strong critical thinking and problem-solving skills.
• Enthusiastic, eager to learn, with a positive attitude.
• Excellent written and verbal communication skills, with client interaction experience.
• Desire to understand the product deeply and become a subject matter expert.
• Experience with Jira, Confluence, Bitbucket.
• Understanding of Agile development methodologies.
• Proven ability to drive projects by translating business requirements into development tasks.

Preferred Experience

• Experience working on a Product team.
• Experience with financial institutions such as credit unions or banks.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Data Infrastructure and Analytics