• Design, build, and maintain ETL and reverse-ETL pipelines connecting our MarTech and healthcare data stack — CRM, marketing automation, event management, content platforms, and third-party healthcare data — into the cloud data warehouse. • Own the cloud data warehouse and its transformation layer — staging, business logic, and mart tables — keeping data clean, documented, and performant for analytics and data science. • Integrate specialty healthcare datasets — pharmaceutical claims and HCP intelligence — with our first-party engagement data, building the joins and transformations that make them actionable for commercial measurement and clinical personalization. • Define and enforce engineering best practices — code standards, testing, documentation, schema governance, and data dictionary — so analytics and data science can move fast without breaking things. • Monitor, troubleshoot, and optimize pipeline performance, resolving data quality and availability issues before they block analytics. • Stay current with the modern data stack and introduce new tools — connectors, transformation frameworks, orchestration, or ML compute — as we scale. • Partner with analytics, data science, product, and commercial teams to turn business requirements into reliable, scalable solutions — making data accessible, never the bottleneck.

Role Description The organization is seeking a pragmatic developer who understands that the landscape of software engineering is shifting. The purpose of this role is to balance leveraging AI for rapid, intuitive "Vibe Coding" with the technical discipline of "Spec-Driven Development" to build superior products. This individual must know how to utilize LLMs for creative exploration while pinning down maintainability through strict technical specifications. - Hybrid Development: Transition effectively between rapid AI-assisted iteration and disciplined, manual engineering throughout the feature lifecycle. - Tooling Integration: Utilize Amazon Kiro as a primary driver within the AWS environment while remaining proficient in the broader ecosystem, including Cursor and GitHub Copilot. - System Architecture: Design and maintain modular, readable structures that AI agents work within to ensure clarity for human colleagues. - Prompt & Spec Engineering: Author high-quality technical prompts and formal specifications to minimize hallucination and maximize logic accuracy. - Code Quality Control: Act as the final auditor for all AI-assisted contributions to ensure they meet internal standards and security protocols. - Testing & Documentation: Employ Test-Driven Development (TDD) and write clear technical documentation to serve as the source of truth for AI tools. - Perform other duties and responsibilities as required, assigned, or requested. Consensus reserves the right to add or change duties at any time. Qualifications - 7+ years of professional full-stack development experience. - Experience with Java, Python, Node.JS, and JavaScript. - Experience building and shipping products using AI-assisted engineering disciplines or "vibe-to-spec" workflows. - Pragmatic Engineering: The ability to prioritize stability and performance over speed, while still utilizing AI to accelerate the development lifecycle. - AI-Native Tooling Mastery: Advanced proficiency with Amazon Kiro, Cursor, and GitHub Copilot, coupled with an understanding of the broader AI-agent ecosystem. - Full-Stack Architecture: Strong grasp of CS fundamentals, including system design, API architecture, and database management (SQL/NoSQL). - Analytical Thinking: A deep-seated need to understand the "why" behind generated code; ability to debug and optimize complex logic manually. - Testing & Documentation: Mastery of Test-Driven Development (TDD) and the ability to write precise technical documentation that guides AI tools. - AWS Proficiency: General comfort navigating AWS services and managing cloud deployment pipelines. Requirements - Location requirements: Fully remote within the U.S. (Los Angeles or Las Vegas preferred.) - Travel requirements: Up to 10% travel. - Physical requirements: Must be able to sit for long periods, as well as handle long periods of screen time. - Technology requirements: Reliable, high speed internet. - Eligible for sponsorship: No Benefits - The salary range for this role is $140,000 - $197,500 USD annually. - The total compensation package for this position is negotiable and may also include annual performance bonus, ESPP, enhanced time off packages and benefits. - This job doesn't have an expiration date and will remain open until a qualified candidate is hired.

Role Description The Data Engineer plays a pivotal role within the Delivery capabilities delivering high-quality solutions using Microsoft Fabric, Databricks and Azure-native technologies. The role may involve running projects independently or leading workstreams within larger and more complex engagements under the direction of a Principal Consultant. The Data Engineer is the primary point of contact for customers during delivery and is expected to combine strong technical capability with excellent consultancy, communication and leadership skills. You will be responsible for shaping solutions, guiding delivery teams, and ensuring projects are delivered to time, cost and quality expectations, while supporting the development of junior consultants. Key Responsibilities - Lead the end-to-end delivery of data engineering projects, either independently or as part of larger multi-disciplinary programmes. - Act as the primary service delivery contact for customers, building trusted relationships and providing clear technical leadership. - Demonstrate deep technical expertise in data engineering, understanding how solutions fit within wider customer architectures and business requirements. - Work with customers to identify, challenge and prioritise business and technical requirements, including running design and discovery workshops. - Translate functional and non-functional requirements into robust, scalable data platform architectures and technical designs. - Design and implement data engineering solutions using Microsoft Fabric and Databricks, following best-practice approaches. - Produce clear technical documentation and communicate designs using appropriate visualisations (e.g. architecture diagrams, data flows). - Accurately estimate delivery effort, contributing to proposals and addressing variances between pre-sales estimates and detailed requirements. - Convert estimates into delivery plans and manage these throughout the project lifecycle, working with Project Management and Scheduling as required. - Provide hands-on technical delivery alongside other consultants when appropriate. - Take overall responsibility for solution and delivery quality, including code reviews, testing strategies and customer acceptance. - Identify, manage and mitigate delivery risks and issues early, drawing on experience to pre-empt likely challenges. - Ensure appropriate deployment, handover and transition into support or managed services. - Mentor and support junior consultants, contributing to capability development within the Data Engineering team. - Contribute to intellectual property, reusable assets, marketing content, case studies and blogs. Qualifications - Strong experience designing and delivering modern data engineering solutions on Azure. - Hands-on expertise with Microsoft Fabric, including Lakehouse, Data Engineering and orchestration capabilities. - Strong experience with Databricks, including Spark-based data processing and optimisation. - Solid understanding of data modelling, data integration patterns, and ELT/ETL pipelines. - Experience working with Azure data services such as Azure Data Lake, Azure SQL and related platform components. - Knowledge of DevOps and deployment practices for data platforms (e.g. CI/CD, version control, automated testing). Requirements - Proven experience delivering projects within agreed time, cost and quality constraints. - Strong ability to communicate complex technical concepts clearly to both technical and non-technical stakeholders. - Experience leading delivery in both waterfall and agile environments and adapting approach to suit the customer and engagement. - Commercial awareness and consultative mindset, with the ability to identify additional opportunities and add value for customers. Personal Attributes - Confident, proactive problem-solver who remains calm and reassuring in customer-facing situations. - Strong organisational and time management skills, with the ability to manage multiple priorities simultaneously. - A proven self-starter, comfortable working independently while contributing positively to team delivery. - Commitment to continuous professional development and maintaining up-to-date technical and consultancy skills. - Willingness to mentor others and contribute to a collaborative, knowledge-sharing culture. Company Description Simpson Associates transforms raw data into actionable insights that drive positive change. Our Microsoft data expertise, our specialist sector knowledge, plus our innovative and trusted advice and guidance are just some of the reasons clients choose to work with us. Our mission is to help purpose-led organisations from within the public and private sectors to harness data as a lever for change and enable them to realise business value more quickly. We provide the full range of services to support organisations on their data transformation journey. We are a Microsoft Solutions Partner, holding Specialisations in AI Platform on Microsoft Azure, Analytics on Microsoft Azure, Data Warehouse Migration to Microsoft Azure and Migrate Enterprise Applications to Microsoft Azure, as well as holding Solutions Partner designations in Data & AI (Azure); Digital & App Innovation (Azure); Infrastructure (Azure) and Security. But it's not just about the badges. We are proud to be recognised as the winner of the 2024 Microsoft Community Response Partner of the Year award, reflecting our dedication to using technology for positive change. We are also a Databricks partner, and an IBM Gold Partner, specialising in Cognos Analytics and Planning Analytics. With offices in York and Sheffield, and a team based throughout the UK – we champion creativity, innovation and collaboration in the workplace.

• Creating and supporting batch, incremental, and real-time ETL pipelines • Standardizing ingestion, validation, and cleaning processes across clients • Automating data validation to increase data quality • Managing and evolving schemas in all parts of our pipeline • Monitoring, tuning, and optimizing Spark jobs • Becoming a domain-expert in connected vehicle data