Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Annual bonus target of 10%, subject to terms and conditions of plan
- Remote work in the United States
Company Overview
Company H1B Sponsorship