Provides hands-on technical leadership for data analytics support across enterprise customers. Responsibilities include resolving complex SQL, cloud platform, ELT, data pipeline, data warehouse, and BI issues; optimizing analytics solutions; conducting root cause analysis; reviewing SQL and BI changes; mentoring analysts; automating support processes; and advising customers on Tableau, Power BI, and modern analytics architecture.
Technical Lead | SQL | Snowflake | Tableau | AWS
Build the Future of Data SolutionsAt 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 OpportunityAs 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
- 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.
- 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, ELTprocesses, 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
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.
If you're excited about building innovative data solutions, solving complex technical challenges, and helping shape a growing technical team, we'd love to hear from you.
To help us get to know you, please include your resume and answer the following question in the cover letter section of the application:
Describe the most technically challenging SQL or cloud database problem you've solved. What was the issue, how did you approach it, and what was the outcome? (250 words or less.)
Don't meet every qualification listed above? We still encourage you to apply. Research consistently shows that talented candidates, particularly women and underrepresented groups, often hesitate to apply unless they meet every requirement. If this role excites you, we'd love to hear from you.
About
At Arkatechture, we love data — we play with it and learn from it every day, and we want you to love your data, too. We are a data consultation and services company specializing in data quality, visualization, and management, as well as customized enterprise-level solutions. We work with companies big and small to help solve their data challenges and reveal how they can leverage their data in brand new ways. Need to collect, clean, or visualize your data? We can help.
Similar Jobs
Energy • Appliances • Industrial • Manufacturing
Lead design, development, and migration of enterprise SAP BW solutions to SAP Datasphere; architect hybrid data flows with Microsoft Fabric and Azure Synapse; integrate BW with Salesforce and SQL Server; embed AI (Copilot, Azure OpenAI) into analytics; manage deliverables, mentor offshore teams, enforce standards, and ensure data integrity and performance for reporting and analytics.
Top Skills:
AbapAdsosAi BuilderAnalysis For OfficeAzure Data FactoryAzure Openai ServiceAzure Synapse AnalyticsCompositeprovidersDtpsInfoprovidersMicrosoft Copilot (Copilot For Power Bi)Microsoft FabricMicrosoft PurviewOpen Ods ViewsPower BIProcess ChainsQuery DesignerS/4HanaSalesforceSap BwSap Bw/4HanaSap DatasphereSap EccSQL ServerTransformations
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Leads business development and strategic growth for the Adaptive Communications and Sensing product line. Develops market opportunities, customer relationships, competitive pursuits, partnerships, investment priorities, and go-to-market strategies across domestic and international defense markets. Engages DoD, Army Aviation, industry, and research stakeholders; guides capture campaigns, customer requirements, business cases, and technology development plans. Requires expertise in tactical communications, defense acquisition, C4ISR, COMSEC, and military sales.
Top Skills:
Airborne Tactical RadiosBlosC4IsrComsecDirect Commercial Sales (Dcs)Foreign Military Sales (Fms)MuosU/Vhf
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Administer and configure enterprise business applications supporting Legal Operations, Global Trade, Ethics, and Security. Manage workflows, integrations, access controls, certificates, monitoring, releases, upgrades, incident resolution, and change governance. Translate business requirements into secure configurations, maintain operational reliability and compliance, document runbooks, and train stakeholders. The role supports Appian, Power Automate, ServiceNow, CLM, ERP, and export management integrations in a remote environment.
Top Skills:
Active DirectoryAgile ScrumAppianClm SystemsCmmcDnsErp SystemsExport Management SystemsMicrosoft Power AutomateNist 800-171PkiSdlcServicenow
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
