As our first Data engineer, you will be the go-to person to build out data pipelines (automated and manual), as well as processes for migrating customers from their existing CRMs (cloud and on-prem) to our newly developed CRM. Additionally, you will work directly with the CTO and Data Analyst on improving internal data engineering and analytics engineering processes.

What You'll Get to Do:

• Utilize a robust understanding of database structures and knowledge of a variety of different data platforms (APIs, data exports, Postgres, Snowflake) to build robust, sustainable, and scalable data pipelines.
• Design and build, maintain and document the data integrations
• Communicate the process cross-functionally within the team
• Investigate and understand clients’ data needs and how it maps to our systems.
• Work with clients (external, non-technical) to transition data from their CRM/system to Roofr CRM, ensuring quality and consistency is maintained post migration
• Work with engineering to build staging/sandbox environments for customer facing validation/demonstration
• Provide active support and improvement ideas to our existing integration processes, striving to constantly improve our tools, internal workflow, and team practices
• Build systems and datasets using software engineering best practices, data management fundamentals, data storage principles, recent advances in distributed systems, and operational and engineering excellence best practices
• Analyze systems, define transformation requirements, design suitable data models and document the design/specifications
• Demonstrate passion for quality and productivity by using efficient development techniques, standards and guidelines
• Drive the design, to build, execute, and maintain automated tests and/or manage deep data profiling runs to ensure data products and pipelines meet expectations
• Effectively communicate through technical documentation, commented code, and interactions with stakeholders and adjacent teams

What You'll Bring to the Role:

• At least 5 years of Data Engineering experience
• Experience working with non-technical stakeholders and clients
• Great communication and time-management skills
• Strong analytical and problem-solving skills
• Desire to always learn new skills and develop existing ones
• Interest in automating processes
• Experience with tools like: Dagster/Airflow/Jenkins, DBT, Stitch/Signer/Fivetran
• Experience in Data Warehousing (Redshift, snowflake, etc)
• Experience in SQL across relational and dimensional databases
• Industry experience is beneficial