Senior Data Engineer (AWS)

Auto Import

<p><strong><em><span data-contrast="auto">Capnexus</span></em></strong><span data-contrast="auto"> is a comprehensive services provider. Our team consists of outstanding professionals, highly experienced in designing, building, and supporting retail software. We see ourselves as a build-as-a-service provider who follows a repeatable business pattern that can be applied to a variety of platforms and verticals. Having a culture built on outcomes and delivery at the core of the business, Capnexus is providing its customers with a complete suite of services for software development, system analysis, integration, implementation, and support, as well as the option to engage a single team to perform all the services they require.</span><span data-ccp-props="{" 335559739":120}"=""> </span></p> <p><strong><span data-contrast="auto">Who You Are and What You'll Do:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <p><strong><em><span data-contrast="auto">Capnexus</span></em></strong><span data-contrast="auto"> is looking for a highly skilled </span><strong><span data-contrast="auto">Senior AWS Data Engineer</span></strong><span data-contrast="auto"> to lead data architecture, pipeline development, and ERP integration for a 12-week AI-powered modernization engagement in the construction industry. This role is focused on designing and implementing the data engineering backbone of an intelligent subcontractor pre-qualification platform, including CMIC ERP API integration, Amazon Textract data extraction pipelines, ETL development using AWS Glue, and data quality validation. This is an exciting opportunity to apply advanced cloud data engineering skills on a platform that leverages generative AI to automate and modernize enterprise workflows.</span><span data-ccp-props="{" 335559739":120}"=""> </span></p> <p><strong><span data-contrast="auto">Responsibilities:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Lead data architecture design, API assessment, and ETL requirements gathering during the Discovery & Design phase.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Develop and configure CMIC ERP API integration to establish reliable data exchange between the ERP system and the AWS platform.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Design and implement data pipelines using AWS Glue for ETL processing of subcontractor documents and ERP data.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Integrate Amazon Textract to extract structured data from insurance certificates, bonding letters, and financial documents.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="5" data-aria-level="1"><span data-contrast="auto">Build and maintain data models to support AI-powered validation, risk profiling, and executive reporting.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="6" data-aria-level="1"><span data-contrast="auto">Configure Amazon S3 data lake architecture to store and manage raw, processed, and curated data assets.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="7" data-aria-level="1"><span data-contrast="auto">Implement AWS Lambda and AWS Step Functions to orchestrate data workflows and automated processing pipelines.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="8" data-aria-level="1"><span data-contrast="auto">Develop and expose data through Amazon API Gateway to support application and dashboard consumption.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="9" data-aria-level="1"><span data-contrast="auto">Ensure data quality, validation, and integrity across all integration points and pipeline outputs.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="10" data-aria-level="1"><span data-contrast="auto">Conduct data integration testing and support user acceptance testing (UAT) for data-dependent features.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="11" data-aria-level="1"><span data-contrast="auto">Collaborate with Full Stack, AI/ML, and DevOps team members to ensure seamless end-to-end data flows.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="12" data-aria-level="1"><span data-contrast="auto">Contribute to knowledge transfer documentation, data pipeline runbooks, and operations guides.</span><span data-ccp-props="{}"> </span></li> </ul> <p><span data-ccp-props="{}"> </span></p> <p><strong><span data-contrast="auto">Qualifications:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="13" data-aria-level="1"><span data-contrast="auto">5+ years of data engineering experience, with at least 2+ years working in AWS cloud environments.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="14" data-aria-level="1"><span data-contrast="auto">Strong proficiency in SQL and experience with AWS database services including RDS, DynamoDB, and Aurora.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="15" data-aria-level="1"><span data-contrast="auto">Hands-on experience with AWS Glue for ETL development and data pipeline orchestration.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="16" data-aria-level="1"><span data-contrast="auto">Experience integrating with ERP systems or enterprise APIs, with ability to assess and document API capabilities.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="17" data-aria-level="1"><span data-contrast="auto">Working knowledge of Amazon Textract for automated document data extraction.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="18" data-aria-level="1"><span data-contrast="auto">Proficiency with Amazon S3 for data lake design, storage management, and lifecycle policies.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="19" data-aria-level="1"><span data-contrast="auto">Experience with AWS Lambda and AWS Step Functions for serverless data workflow orchestration.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="20" data-aria-level="1"><span data-contrast="auto">Solid understanding of data modeling, data quality validation, and integration testing practices.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="21" data-aria-level="1"><span data-contrast="auto">Familiarity with Amazon API Gateway for exposing data services to downstream consumers.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="22" data-aria-level="1"><span data-contrast="auto">Strong analytical, problem-solving, and communication skills with the ability to work in Agile/Scrum teams.</span><span data-ccp-props="{}"> </span></li> </ul> <p><span data-ccp-props="{}"> </span></p> <p><strong><span data-contrast="auto">Nice to Have:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="23" data-aria-level="1"><span data-contrast="auto">Experience with Amazon Bedrock or AI/ML-integrated data pipelines.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="24" data-aria-level="1"><span data-contrast="auto">Familiarity with CMIC ERP or similar construction industry enterprise resource planning systems.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="25" data-aria-level="1"><span data-contrast="auto">Experience with GraphQL APIs or AWS AppSync.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="26" data-aria-level="1"><span data-contrast="auto">Knowledge of TypeScript or Python for pipeline scripting and Lambda function development.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="27" data-aria-level="1"><span data-contrast="auto">AWS Certification (Data Analytics Specialty, Database Specialty, or Solutions Architect).</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="28" data-aria-level="1"><span data-contrast="auto">Background in construction, insurance, or financial services industries.</span><span data-ccp-props="{}"> </span></li> </ul> <p><span data-ccp-props="{}"> </span></p> <p><strong><span data-contrast="auto">"Our Culture":</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <p><span data-contrast="auto">At Capstone, the central principles that we all adhere to, and the glue that holds us together, are our keystones. Our four keystones are:</span><span data-ccp-props="{" 335559739":60}"=""> </span></p> <p><strong><span data-contrast="auto">"A Customer Obsessed, Delivery Focused, Culture"</span></strong><span data-ccp-props="{}"> </span></p> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">We’re driven to exceed our customers’ expectations by listening, leading, solving problems, and delivering what we promise</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">We aim to be the most dependable and trusted partner serving our customers. TRUST = CONSISTENCY x TIME</span><span data-ccp-props="{}"> </span></li> </ul> <p><strong><span data-contrast="auto">"A Culture of Learning and Sharing"</span></strong><span data-ccp-props="{}"> </span></p> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">We value “Lifetime Learners”; those who are hungry, competitive, curious, and self-motivated in their pursuit of knowledge.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Personal and professional growth depends on teamwork and continuous learning. By sharing knowledge, skills, ideas, and effort, we benefit our customers, ourselves, and our communities.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="5" data-aria-level="1"><span data-contrast="auto">We recognize that the thoughts, feelings, and backgrounds of others are as important as our own. Everyone has something to learn and everyone has something they can teach.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="6" data-aria-level="1"><span data-contrast="auto">Knowledge and ability are valued. Sharing knowledge and helping others learn new capabilities is valued exponentially.</span><span data-ccp-props="{}"> </span></li> </ul> <p><strong><span data-contrast="auto">"A Culture of Growth and Scalability"</span></strong><span data-ccp-props="{}"> </span></p> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="7" data-aria-level="1"><span data-contrast="auto">Growth comes from not establishing barriers in your role. “Cross functional skill sets are valued and help us deliver to our customers in a truly agile fashion. It comes with understanding that when asked to do something new, you will need support, have questions, and make some mistakes along the way.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="8" data-aria-level="1"><span data-contrast="auto">The most elegant solution is a simple solution. Simple doesn’t mean easy. It’s often more difficult to break a complex problem down into simple, scalable terms. We don’t appreciate, or value, over architected solutions or superfluous coding.</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="9" data-aria-level="1"><span data-contrast="auto">Time is one of our most precious commodities. Scalability implies being respectful of this and passionate about making the most efficient use of each and every one of our team members time.</span><span data-ccp-props="{}"> </span></li> </ul> <p><strong><span data-contrast="auto">"All Work is Strategic"</span></strong><span data-ccp-props="{}"> </span></p> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="10" data-aria-level="1"><span data-contrast="auto">No matter how small a project or assignment appears, every single engagement is an opportunity for us to prove ourselves, build trust, and develop relationships that last and grow</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="11" data-aria-level="1"><span data-contrast="auto">Every task, interaction, and commitment matters</span><span data-ccp-props="{}"> </span></li> </ul> <ul> <li data-leveltext="o" data-font="" data-listid="3" data-list-defn-props="{" 335552541":1,"335559685":1080,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"o","469777815":"hybridmultilevel"}"="" data-aria-posinset="12" data-aria-level="1"><span data-contrast="auto">Big or small, we execute our plans and strategies with focus, commitment, and passion</span><span data-ccp-props="{}"> </span></li> </ul> <p><span data-ccp-props="{}"> </span></p> <p><strong><span data-contrast="auto">We offer:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <p><span data-contrast="auto">Job Type: Full-time, 1099</span></p> <p><span data-contrast="auto">Duration: Short-term<br><br></span></p> <p><strong><span data-contrast="auto">Benefits:</span></strong><span data-ccp-props="{" 335559738":120,"335559739":60}"=""> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="2" data-list-defn-props="{" 335552541":1,"335559685":720,"335559991":360,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridmultilevel"}"="" data-aria-posinset="33" data-aria-level="1"><span data-contrast="auto">Remote work</span><span data-ccp-props="{}"> </span></li> </ul> <p><span data-ccp-props="{}"> </span></p> <p><strong><em><span data-contrast="auto">Capnexus</span></em></strong><span data-contrast="auto"> is an equal opportunity employer. We embrace and celebrate diversity and are committed to creating an inclusive and safe environment for all employees. Experience comes in many forms, and we’re dedicated to adding new perspectives to the team. We encourage you to apply even if your experience doesn’t perfectly align with what we have listed. We look forward to hearing from you.</span><span data-ccp-props="{" 335559739":120}"=""> </span></p> <p><strong><span data-contrast="auto">No Agencies Please!</span></strong><span data-ccp-props="{}"> </span></p>

Back to blog