Data Solutions Analyst

Description

• Collaborates - Building partnerships and working collaboratively with others to meet shared objectives.
• Develop requirements for integrations with external systems (e.g., Procore, SAP, contracting tools).
• Document data structures, logic, and workflows to ensure clarity and knowledge sharing across teams.
• Partner with internal stakeholders to gather requirements, understand workflows, and translate business needs into structured, reliable data solutions.
• Identify opportunities to streamline processes and automate workflows, balancing front-end usability with backend reliability.
• Collaborate with technical teammates to review code, troubleshoot issues, and improve data integrations as needed.
• Develop and refine Airtable automations and scripts to support business users' daily work.
• Write and maintain Python and SQL scripts to clean and , transform datasets into order to send marts-level data into a BI Tool.
• Design, build, and maintain Airtable bases and interfaces, ensuring they are scalable, intuitive, and optimized for cross-team use.
• Plans and Aligns - Planning and prioritizing work to meet commitments aligned with organizational goals.

Requirements

• Experience collaborating with data engineers or software developers to review and maintain code quality.
• 3+ years of experience in data structuring, solutions engineering, or related roles (e.g., data analyst, product developer).
• Experience with data transformation tools such as dbt or SQLMesh.
• Understanding of data architecture to support BI tools and analytics pipelines.
• Familiarity with workflow automation tools, APIs, and system integrations.
• Nimble Learning - Actively learning through experimentation when tackling new problems, using both success and failures as learning fodder
• Proven experience building and managing Airtable bases, including automations, table design, and scripting both within Airtable and via the Airtable API.
• Strong understanding of data structuring, modeling, and optimization principles.
• Proficiency in Python and SQL for building and maintaining data pipelines.
• Ability to approach data problems analytically, with a background in Math, Data Science, Economics, Computer Science, or related fields (CS degree not required).
• Manages Ambiguity - Operating effectively, even when things are not certain or the way forward is not clear.
• Interpersonal Savvy - Relating openly and comfortably with diverse groups of people.
• Excellent communication and problem-solving skills, with a balance of technical and user-facing capabilities.
• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Broader experience with database systems and integrations beyond Airtable.
• Demonstrated ability to translate complex data problems into practical solutions for non-technical users.

Benefits

• 5% employer match on your 401k retirement account
• 20 paid vacation days off, plus 7 sick days, 9 federal holidays and 3 personal floating holidays
• 16 volunteer hours plus two planned company-wide volunteer outings per year
• 12 weeks of 100% paid parental leave for both the primary and secondary caregiver within the first year of birth or adoption
• Wellness initiatives including a $1,000 stipend
• Medical, dental and vision coverage

Training + Development

Interview process

Visa Sponsorship

Security clearance