Technical Lead, Data Analytics

Software Directory; Portland (ME); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Flexible remote work

Optional Portland office

Professional development reimbursement

Competitive benefits

Job summary

Arkatechture is seeking an experienced Technical Lead, Data Analytics to serve as the senior technical expert for a portfolio of enterprise customers. This hands-on role focuses on solving complex SQL and cloud data platform problems, mentoring analysts, and driving technical excellence across the organization.

You will partner with customers and the Customer Success team to improve satisfaction, adoption, and outcomes, while collaborating with Engineering, Product, and Support teams to deliver

Qualifications

• 6+ years of SQL experience in production environments.
• Deep expertise with relational databases and cloud data platforms (Snowflake, Databricks, SQL Server, Oracle, Redshift, Synapse, BigQuery, or similar).
• Strong experience designing, troubleshooting, and optimizing data warehouses and analytics solutions.
• Experience with Tableau and Power BI.
• Excellent communication and customer-facing mentoring abilities.

Responsibilities

• Serve as the senior technical resource for BI and Data Analytics Support team.
• Lead investigations and resolution of complex customer data issues.
• Perform root cause analysis and design scalable, long-term solutions.
• Review SQL and BI object changes and promote development best practices.
• Mentor analysts and elevate team capabilities.
• Identify automation opportunities and process improvements.
• Lead root-cause analysis meetings as needed.

Skills

SQL in production

Snowflake

Databricks

Tableau

Power BI

AWS

Data modeling

Mentoring teammates

Agile / Jira

Tools

Jira

Confluence

Bitbucket

Job description

Technical Lead | SQL | Snowflake | Tableau | AWSBuild the Future of Data Solutions

At Arkatechture, we believe data should empower better decisions. Since 2012, we've partnered with financial institutions across the country to solve complex data challenges through modern analytics, cloud technologies, and AI-powered solutions.

Our mission is built on three simple pillars:

• Do something meaningful
• With a great team
• Earning what you deserve

We're looking for an experienced technical leader who is passionate about solving complex data problems, mentoring others, and helping customers unlock the full potential of their data. If you enjoy writing SQL one minute, architecting a cloud data solution the next, and coaching teammates along the way, we'd love to meet you.

The Opportunity

As the Technical Lead, Data Analytics, you'll serve as the senior technical expert for a portfolio of enterprise customers while helping shape the future of our Support Services team. This is a hands‑on technical leadership role, not a people manager who occasionally reviews code. You'll spend much of your time solving challenging SQL and cloud data platform problems, partnering directly with customers, mentoring analysts, and driving technical excellence across the organization. While this role is expected to grow into formal people leadership, your technical expertise, problem‑solving ability, and customer partnership skills are what will make you successful from day one.

Key Responsibilities

Technical Leadership

• Serve as the senior technical resource for our Business Intelligence and Data Analytics Support team.
• Lead the investigation and resolution of complex customer issues involving data, analytics, and cloud platforms.
• Perform root cause analysis and implement scalable, long‑term solutions—not just quick fixes.
• Review SQL and BI object changes while promoting development best practices.
• Mentor and coach analysts, helping elevate the technical capabilities of the entire team.
• Identify opportunities for automation and continuous improvement across support processes.
• Lead root‑cause analysis meetings as necessary to dig into any thematic issues that crop up and how we can mitigate them.

Customer Partnership

• Help customers maximize the value of Arkatechture's analytics platform through technical guidance and best practices.
• Partner closely with Customer Success to improve customer satisfaction, retention, and platform adoption.
• Support customer meetings by offering technical expertise, hold office hours, expand upon Knowledge Base articles and Learning Management System training for customers.
• Communicate complex technical concepts clearly to both technical and non‑technical audiences.

Data & Analytics Expertise

• Design, develop, troubleshoot, and optimize complex SQL solutions.
• Troubleshoot ELT processes, data pipelines, and BI reporting environments.
• Monitor and resolve issues with Tableau and Power BI dashboards and scheduled refreshes.
• Collaborate across Engineering, Customer Success, and Product teams to deliver scalable customer solutions.

Skills, Knowledge and Expertise

We're looking for someone who enjoys solving difficult technical problems and helping others do the same.

• 6+ years of experience working with SQL in production environments
• Deep expertise with relational databases and cloud data platforms (Snowflake, Databricks, SQL Server, Oracle, Redshift, Synapse, BigQuery, or similar)
• Strong experience designing, troubleshooting, and optimizing data warehouses and analytics solutions
• Experience with Tableau and Power BI
• A strong understanding of data modeling, ELT processes, and modern analytics architecture
• Exceptional analytical and troubleshooting skills
• Outstanding communication skills and the ability to build trusted customer relationships
• Experience mentoring teammates or serving as a technical leader
• Experience with Agile development practices and tools such as Jira, Confluence, and Bitbucket

Experience with any of the following is a plus:

• Professional Python experience
• Experience supporting cloud infrastructure, preferably AWS
• Financial services, banking, or credit union technology
• Customer-facing consulting or technical support leadership
• Modern data engineering and cloud architecture
• Data governance or data quality initiatives
• AI or machine learning technologies

Why You'll Love Working Here

At Arkatechture, you'll work alongside curious, collaborative people who genuinely enjoy solving hard problems together.

We offer:

• Flexible remote work with optional access to our Portland, Maine office
• Four-day work week after three years of service
• Competitive salary and comprehensive benefits
• Medical, disability, life insurance, and optional dental and vision coverage
• 401(k) with company match
• Generous paid time off and paid holidays
• Professional development and certification reimbursement
• Opportunities to influence our technical direction while continuing to grow your own expertise

Our Culture

We're proud of the culture we've built. We hire people who are humble, curious, collaborative, and driven by continuous improvement.

Our values guide everything we do:

• Put the team first.
• Practice humility.
• Take pride in your work.
• Stay curious.
• Care for your community and the environment.
• Take the work seriously, but not yourself.