Senior Technical Consultant - Data Engineering with DBT

Perficient is a global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose.We currently have a career opportunity for a Senior Technical Consultant - Data Engineering with DBT to join our Data & Analytics Team in Irvine, CA.The Senior Technical Consultant 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.Job Overview:As a Senior 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.Perficient is the global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose.Strong SQL skills with ability to write and optimize analytical queriesPython proficiency for building data ingestion pipelines and scriptingBachelor's degree in Computer Science, Engineering, or a related technical field, or equivalent practical experienceExperience with dbt or willingness to learn quickly (we use dbt extensively)Familiarity with data warehousing concepts on Snowflake, BigQuery, or similar comfort with Git-based development workflowsExperience with dbt in a production environmentFamiliarity with dimensional modeling (fact and dimension tables)Experience with layered data architectures (staging, intermediate, mart patterns)Exposure to workflow orchestration tools (Dagster, Airflow, Prefect)Understanding of data quality testing approachesDemonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution.Familiarity with AI-enhanced platforms is a plus.A solid understanding of AI capabilities and limitations including ethical considerations is expected.Nice to shave skills:3 - 5 years in analytics engineering or data engineeringPerficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.​ Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.​ Applications will be accepted until the position is filled or the posting is removed.​ 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 regarding each candidate. A reasonable estimate of the current salary range for this position is $64,974 to $149,880,.Please note that the salary range posted reflects the base salary only and does not include benefits or any potential variable compensation programs. Information regarding the benefits available for this position are in our benefits overview.Design and develop dbt models following the medallion architecture (bronze > silver > gold layers).Build dimensional models, including fact and dimension tables, for analytics consumption.Implement and maintain data quality tests using dbt’s testing framework.Optimize SQL transformations within dbt for performance in Snowflake.Write and maintain schema documentation with model and column descriptions, and apply dbt best practices (refs, sources, macros, tags).Configure and maintain Dagster assets to orchestrate dbt model execution, including implementing schedules and sensors.Monitor pipeline health through the Dagster UI and resolve execution failures.Build and maintain bespoke Python-based ingestion pipelines for source systems without native connector support.Participate in code reviews for dbt models and Dagster configurations, and use tools like sqlfluff for code quality.Collaborate with analysts and data consumers, and document data models, transformation logic, and operational procedures.Full timePosting Date: 2026-02-26