Technical Lead, Data Analytics

Stack

Responsibilities

• ▹Serve as the senior technical resource for the 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
• ▹Identify opportunities for automation and continuous improvement across support processes
• ▹Lead root cause analysis meetings to address recurring thematic issues
• ▹Help customers maximize the value of the Arkatechture analytics platform through technical guidance
• ▹Partner with Customer Success to improve satisfaction, retention and platform adoption
• ▹Offer technical expertise in customer meetings, hold office hours, expand Knowledge Base articles and Learning Management System training
• ▹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

Requirements

• ▹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
• ▹Strong understanding of data modeling, ELT processes and modern analytics architecture
• ▹Exceptional analytical and troubleshooting skills
• ▹Outstanding communication skills and 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

Nice to have

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

Soft skills

What we offer

• ▹Flexible remote work with optional access to the 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 the technical direction

About the company

Since 2012, Arkatechture has partnered with financial institutions across the US to solve complex data challenges through modern analytics, cloud technologies and AI-powered solutions. Its mission rests on three pillars: do something meaningful, with a great team, earning what you deserve.