Senior Snowflake Data Engineer DBT

We currently have a career opportunity for a Snowflake Engineer to join our Data & Analytics Team

The Snowflake Data Engineer will be responsible for designing, developing, and maintaining data pipelines and solutions to enable our client to harness the power of the data for further analytics. The engineer will work with modern data technologies, emphasizing Snowflake and dbt (Data Build Tool) to automate, build, test, and maintain the data infrastructure. Additionally, it is expected that people participate actively in all aspects of the data lifecycle and provide recommendations aligned with best practices within the process.

As a Technical Consultant, you will participate in all aspects of the software development lifecycle, which includes estimating, technical design, implementation, documentation, testing, deployment, and support of applications developed for our clients. As a member working in a team environment, you will work with solution architects and developers on the interpretation/translation of wireframes and creative designs into functional requirements, and subsequently into technical design.

Perficient is always looking for the best and brightest talent, and we need you! We’re a quickly growing, global digital consulting leader, and we’re transforming the world’s largest enterprises and biggest brands. You’ll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

• Design, develop and maintain ELT pipelines using Snowflake and DBT
• Build and optimize data models in Snowflake to support analytics and reporting
• Implement modular testable SQL transformations using DBT
• Integrate DBT workflows into CICD pipelines and manage infrastructure as code using Terraform
• Collaborate with data scientists analysts and business stakeholders to translate requirements into technical solutions
• Optimize Snowflake performance through clustering partitioning indexing and materialized views
• Automate data ingestion and transformation workflows using Airflow or similar orchestration tools
• Ensure data quality governance and security across pipelines
• Troubleshoot and resolve performance bottlenecks and data issues
• Maintain documentation for data architecture pipelines and operational procedures
• Develop and maintain effective working relationships with team members.
• Demonstrate the ability to adapt and work with team members of various experience levels.

• BS in Computer Science, Engineering, or related technical field.
• Passionate data engineer with 2- 6 years of experience, with a focus on Snowflake and DBT
• Solid SQL skills and understanding of database systems
• Experience with data integration, data processing, and data quality
• Experience with object storage, data lakes, and lake houses
• Experience with version control tools such as Git
• Team-oriented, interpersonal, highly motivated, passionate, and creative team-player with the ability to develop and maintain collaborative relationships with all levels within and external to the organization
• Familiarity with Azure Data Services, including Azure Data Factory, Azure Storage, and Azure Synapse, is a plus
• Familiarity with Databricks is a plus
• Knowledge of data processing technologies like Apache Spark and Kafka is a plus
• Cloud platform certifications are a plus
• Client-facing or consulting experience is highly preferred.
• Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.

The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials.

It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances…