Senior Consulting Data Engineer - Snowflake

CDW is hiring a Senior Consulting Data Engineer to deliver customer-focused data engineering solutions and support analytics delivery. The role designs, builds, validates, and documents data pipelines and models, while managing project delivery and collaborating with customers and cross-functional teams.

Responsibilities:

• Manage time and expense to meet or exceed expectations defined in the Statement of Work, proactively escalating potential budget issues as soon as they are known
• Collaborate with cross-functional teams to ingest, maintain, and deliver analytics data that supports reporting, ad-hoc analysis, and business decision-making
• Develop and maintain data ingestion and transformation processes using Snowflake, SQL, DBT, and related cloud data technologies
• Monitor data pipelines and automated jobs to ensure data is captured, processed, and delivered accurately and on time
• Perform validation and testing of data transformations to ensure high-quality, reliable data outputs
• Ensure data processes are efficient, repeatable, well documented, and aligned with required governance and data privacy expectations
• Work independently on multiple projects in diverse customer environments, ensure that appropriate management is apprised of project status, bring projects to completion and follow up with customers regarding results
• Troubleshoot, maintain, upgrade, and provide solutions to complex technology problems. Conduct analysis, problem solving, and planning
• Identify and communicate potential opportunities for cross-selling to the sales team
• Collaborate with team members in the development of best practices within team
• Demonstrable passion for technology while using problem solving capabilities to deliver solutions utilizing a top end engineering approach with an enthusiasm for learning
• Focused on delivering value to the business with relentless efforts to improve process
• Flexible in thinking; able to evolve a solution when additional information or ideas are presented making tactical vs. strategic tradeoffs where needed
• Implements, maintains, upgrades, and troubleshoots S&S solutions; transferring technical skills and knowledge to client through work logs
• Performs overall solution Quality Assurance (QA) tasks for all projects delivered against assigned project deliverables while ensuring they are in alignment with the project scope and SOW (Statement of Work)
• Provides implementation/migration planning to client, knowing and meeting client timetable, coordinating vendor installations, etc
• Facilitates communication between product team members

Requirements:

• Bachelor's degree and 5+ years' professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery OR 9+ years' professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery
• Strong experience with Snowflake, DBT, AWS, and SQL, including data transformation, cleansing, preparation, and performance-minded development
• Experience developing datasets that support ad-hoc analytical needs, reporting, and marketing or business stakeholder insight generation
• Experience working in highly regulated industries and complying with internal governance, data privacy, and data quality requirements
• Strong written and verbal communication skills with the ability to effectively interact with leadership stakeholders and clients
• Proven ability to maintain and create technical documentation for assigned project work
• Demonstrated attention to detail, especially client and project changes, with solid analytical skills to identify potential risks
• History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines
• Demonstrated experience applying lessons learned to unique problems
• History of reskilling on new technologies with understanding of difference with past technologies
• Preferred experience includes healthcare data, marketing data, and a bachelor's degree in IT, software engineering, data engineering, or a related field