Partner directly with clients to understand their business needs, data challenges, and desired outcomes
Design, build, and maintain production‑grade data models that support client‑specific reporting, analytics, and operational workflows
Develop and maintain dbt models, tests, documentation, and transformation logic as part of broader client solutions
Develop, review and test code (SQL, Python, BI tool like Tableau and PowerBI)
Collaborate with data engineers to ensure upstream data is structured and optimized for downstream use
Translate client requirements into scalable, well‑documented semantic layers
Implement data quality checks, testing frameworks, and governance standards across client projects
Participate in client sessions, including solution design conversations
Contribute to internal best practices, reusable patterns, and accelerators for future client engagements
Report work status to team leaders and participate actively in daily standups
Additional responsibilities as assigned

Requirements

3+ years in analytics engineering, data engineering, BI development, or a similar role
Strong SQL skills and experience building complex, maintainable transformation logic
Hands‑on experience with dbt (core or Cloud) in a production environment
Experience with modern cloud data warehouses (Snowflake, BigQuery, Redshift, etc.)
Familiarity with data modeling concepts
Experience working directly with clients or stakeholders to gather requirements and deliver solutions
Strong communication skills and the ability to translate technical concepts into business language
Experience with Git‑based workflows and collaborative development practices
Understanding of software engineering best practices (testing, CI/CD, code review)
Preferred Experience
Experience with Banking Data and Subject Areas
Experience with Python for data workflows or automation
Experience with BI tools (Looker, Tableau, Power BI, Sigma, etc.)
Experience in consulting or professional services environments

Benefits

A flexible remote work policy with optional access to our Portland, Maine office
A 4-day workweek after 3 years of service
Generous paid time off, including 11 holidays
Medical, disability, life insurance, and optional dental/vision
401(k) retirement plan with company match
Training & certification reimbursement
Milestone recognition programs, annual PTO increases, and more

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythondbtdata modelingdata transformationdata quality checkstesting frameworksCI/CDGitBI development

Soft Skills

communicationclient engagementcollaborationproblem-solvingrequirements gatheringsolution designdocumentationteamworkadaptabilityleadership