As a Lead Data Engineer at Delta Defense, you will work with a great tech stack, playing a pivotal role in providing hands-on technical leadership to the Analytics Engineering Team. Your expertise will transform raw data from diverse sources into robust, business-focused technology solutions that will empower the organization by enabling the reporting of KPIs, metrics, and insights. A key requirement for this role is deep data and analytics engineering expertise building Enterprise Data Warehouse solutions which will be essential in driving our data transformation processes. We're looking for candidates who are relentlessly resourceful, able to tackle complex requests swiftly, and committed to maintaining the highest standard of quality. This position is based at our corporate headquarters in West Bend, Wisconsin. Essential Duties and Responsibilities: * Lead the design and development of dbt data pipelines that transform complex and disparate data sources to support an Enterprise Data Warehouse built on Data Vault and Dimensional data architectures. * Ensure data quality by designing strategies and implementing frameworks that support automated data testing and observability to proactively identify and resolve data issues. * Champion analytics engineering design patterns and coding standards to ensure robust, reliable and scalable data pipelines. * Establish analytics engineering best practices around CI/CD, unit testing, performance testing and optimization. * Partner with Data Architect to ensure data transformations align with the Enterprise Data Warehouse models to support analytics and reporting requirements. * Serve as data model subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately. * Create comprehensive standardized technical documentation to support the understanding and maintenance of data pipelines and establish adoption across the team. * Adhere to PII, security and risk policies established by the organization to protect sensitive data. * Provide technical guidance and mentorship to help develop and upskill Analytics Engineers along with fostering a collaborative and supportive environment * Collaborate with business stakeholders and Data Architect to define data requirements and translate into technical source to target mapping and data pipeline design documents. Required Skills/Experience: * Bachelor's degree in IT or related field; Computer Science, Information Management, Data Science/Analytics, or equivalent relevant experience. * Experience developing data pipelines for Enterprise Data Warehouses is required. * Proficiency in dbt preferred. * 6+ years of SQL experience including complex data transformations. * Strong understanding of ETL/ELT methodologies. * Experience with Python and shell scripting is a plus. * Strong engineering background with a variety of programming languages and technologies. * Experience developing CI/CD pipelines with Git. * Tableau or equivalent experience is a plus. * The ability to communicate ideas, information, and viewpoints clearly, both verbally and in writing. * Experience with Dimensional Data modeling (star schemas) is preferred. * Technical leadership or mentorship experience is preferred. * Demonstrates the Core Values of Delta Defense, LLC. Benefits information can be reviewed at: https://www.deltadefense.com/careers Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. PM19