Data Architect

DELTA DEFENSE LLC • West Bend, WI • 1d ago

JOB REQUIREMENTS: This position is based at our corporate headquarters in West Bend, Wisconsin and allows for a hybrid work schedule with a minimum of 3 days per week in office. 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. Data Architect - why this role matters to you: Work for Delta Defense, the private company that provides Marketing, Operations and Customer Service for the U.S. Concealed Carry Association. The USCCA safeguards life, freedom, and finances for responsible American protectors. Learn more about the USCCA at https://www.usconcealedcarry.com/ Join us as a Data Architect on the Enterprise Data Warehouse Team, where you will play a hands-on role in shaping and building the new EDW 2.0 built on modern cloud-based data platforms dbt and Snowflake. Primary responsibilities include designing the Data Vault and Dimensional Data Warehouse data models along with developing the dbt data pipelines that transform raw data into enterprise grade data products, powering self-service Business Intelligence, Advanced Analytics and AI initiatives. As a qualified candidate, your key experiences include demonstrable hands-on Dimensional Data Modeling (Kimaball), Analytics / Data Engineering, advanced SQL skills and experience building and using dimensionally modeled Enterprise Data Warehouses. At Delta Defense, you\'ll find an environment that encourages growth, innovation, and the pursuit of excellence. Join us, and be part of a mission-driven community where your contributions have life saving impact and your development matters. Data Architect - Essential Duties and Responsibilities: Design EDW Data Vault and Dimensional Data Warehouse data models using SqlDBM. Collaborate with Advanced Analytics, IT and Business Teams to gather data requirements and translate them into conceptual, logical and physical data models. Engineer data pipelines to transform complex and disparate data sources that powers the EDW. Provide technical guidance and mentorship to help develop and upskill the EDW Team along with fostering a collaborative and supportive environment. Become a subject matter expert in multiple business processes and subject areas. ** OTHER EXPERIENCE AND QUALIFICATIONS: Data Architect - Required Skills/Experience: High school diploma or equivalent required. Bachelor\'s degree preferred in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent relevant experience. Dimensional Data Modeling (star schemas) experience required. 5+ years of experience in Data Engineering and/or Business Intelligence roles. Experience developing data pipelines / ETL jobs for Enterprise Data Warehouse. 5+ years of SQL experience including complex data transformations. 1+ years dbt experience preferred. Modern cloud database experience with platforms like Snowflake. Modern Business Intelligence experience with platforms like Tableau or Sigma. Demonstrates the Core Values of Delta Defense, LLC. *** APPLICATION INSTRUCTIONS: Apply Online: www.deltadefense.com Other: Apply at www.deltadefense.com

Similar Jobs

Assembly Technician

Columbus McKinnon Corporation • Hartland, WI • 6h ago

IT & Engineering

Job Summary/Overview This position will work within the belting cell. The primary focus of this position will be on assembling components for conveyors using a variety of hand tools. Work Schedule Moonday - Friday 6:00am...

6h ago

Go to Apply

Principal Data Scientist

DELTA DEFENSE LLC • West Bend, WI • 11h ago

IT & Engineering

JOB REQUIREMENTS: 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. Principal Data Scientist - why this role matters...

11h ago

Go to Apply

Technical Application Engineer

BORDER STATES INDUSTRIES INC • Pewaukee, WI • 1d ago

IT & Engineering

JOB REQUIREMENTS: Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you\'re empowered to make decisions, find solutions and receive rewards f...

1d ago

Go to Apply

Associate Engineer Electrical

COLUMBUS MCKINNON CORP • Menomonee Falls, WI • 2d ago

IT & Engineering

JOB REQUIREMENTS: Job Summary/Overview The Associate Engineer, Electrical (Aftermarket department) is a customer-focused technical expert responsible for ensuring peak performance and reliability of Magnetek products and...

2d ago

Go to Apply

FROEDTERT HEALTH GROUP • West Bend, WI • 4d ago

IT & Engineering

JOB REQUIREMENTS: Discover. Achieve. Succeed. #BeHere Location: US:WI:WEST BEND at our FROEDTERT WEST BEND HOSPITAL facility. This job is ON - SITE. This position is eligible for a \$10K sign-on bonus! FTE: 0.875 Standar...

4d ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.