Technical Data Analyst

Technical Data Analyst

Department: Arkalytics - Product

Employment Type: Full Time

Location: Remote

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

Description

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
• 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 PositionArkatechture is seeking candidates for a Technical Data Analyst position. As a Technical Data Analyst you will be responsible for the ongoing support for our BI & Analytics platform, Arkalytics. This position will play a crucial role on our Product  team in building scalable solutions within the Arkalytics platform. The ideal candidate for this position is a strong problem solver who can troubleshoot independently, but also a team player who can grow into a subject matter expert within the Product team.  This role will occasionally interface with clients and  requires a candidate with strong communication and analytical skills with a high level of 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 the root cause of the issues quickly and develop a resolution while following all change management procedures
• Requirement gathering for Data pipeline integration (ELT) development
• Requirement gathering for Data mapping (business logic)
• Develop, review and test code (SQL, Python, BI tool like Tableau and PowerBI)
• Maintain an active communication with the internal Arkatechture team and occasionally clients
• Work closely with the team to identify process improvements within the Product team
• Escalate risks and issues on time
• Testing using SQL and providing documented sign off
• Documentation of processes and workflows
• Facilitate requirements sessions, user training and other client meetings
• Report work status to team leaders and participate actively in daily standups
• Additional responsibilities as assigned

Skills, Knowledge and Expertise

Requirements 

• Bachelor's Degree in a relevant field or 5-8 years of experience in a similar role
• Expert in Python and SQL 
• Strong experience working in any one Database such as Snowflake, Databricks, SQLServer, Oracle etc
• Experience working with visualization tools such as Tableau or PowerBI
• Experience in Data Warehousing and BI projects
• Experience with AWS
• Strong critical and analytical thinking and problem solving skills
• Enthusiastic, learner and driven with a positive attitude
• A strong written and verbal communicator with experience interacting with internal teams and clients
• A desire to completely understand the product and become a subject matter expert as it is necessary in order to properly construct the platform
• Experience with Jira, Confluence, Bitbucket
• A strong understanding of Agile software development life cycle and methodologies
• Proven success driving projects by asking questions, understanding business requirements and translating them into tangible development tasks

Preferred Experience

• Experience working on a Product team
• Experience working with financial institutions such as Credit unions, Banks