Share Email Opening Title Data Engineer  About the Organization 2ND ADVENTURE GROUP (2AG) - Brownells, Crow Shooting Supply, AR15.com, Big Springs At 2nd Adventure Group, we Empower the Spirit of Independence and Adventure. Our passion is connecting gunsmiths, firearm enthusiasts, collectors, hunters, competitors, and protectors with products that outfit and enhance their spirit of independence and adventure. 2AG brands are aligned to empower people to be inspired, educated, and outfitted for a lifetime of enjoying outdoor experiences and adventures. We believe the spirit of independence and adventure is a mindset - in the office, on the range, in the field or with your family. It is the foundation - and reason - for everything we do. Our companies include: • BROWNELLS - the preeminent all-things-firearms company in the world. Founded in 1939 in Montezuma, IA, Brownells' storied history of connecting firearm and firearm accessory manufacturers with freedom-loving customers is unrivaled. • CROW SHOOTING SUPPLY - our national wholesale distributor of firearms, ammunition reloading components and shooting accessories. We proudly serve retail gun shops, major sporting goods stores, gun clubs, shooting ranges and government agencies. • AR15.COM - the world's largest online firearm community, proud to be the gathering place for firearm enthusiasts of all types. • BIG SPRINGS SHOOTING COMPLEX - our premier shooting/hunting facility for law enforcement agencies, shooting clubs/camps, youth groups, private citizens, and 2AG EMPLOYEES! OUR VALUES • R.I.C.H. (Respect, Integrity, Courage, Honesty) • Power of the Platform (collectively leveraging our unique brands) • Purpose Driven Performance • Relentless Creativity & Innovation WHY ADVENTURE WITH US Put simply, our adventure is fun! If working in a fast-paced, hobby-based business where growth and exploring new frontiers every day excites you, then WE WANT YOU!   Division Brownells   Full-Time/Part-Time Full-Time   Description Adventure Summary Adventure…it’s about following your passions and pushing beyond your comfort zone. Founded in 1939, Brownells has remained an industry leader passionate about adventure, focused on inspiring, educating, and outfitting people for a lifetime of enjoying outdoor experiences. Our Business Insights team is searching for an experienced Data Engineer who is passionate about turning ideas into action. As Data Engineer at Brownells, you will build and work on end-to-end data projects using a modern cloud tech/data stack. You will be responsible for creating the technology and data architecture that moves and translates data used to inform our most critical strategic and real-time decisions. You will also help translate business needs into requirements and identify efficiency opportunities. The primary BI tool is the Incorta cloud data platform, with connections to various SQL databases, M3DB, data lakes, and various 3rd-party APIs. We are looking for a self-starter who can identify, recommend, and implement best practices, who also enjoys working collaboratively with a growing team of data analysts and data scientists. The ideal candidate is someone motivated to learn/understand business stakeholder needs, who can translate those needs into technical deliverables, and can effectively communicate across tech and non-tech functional areas. Our new Data Engineer will have an incredible opportunity to impact the business as we endeavor to provide a world-class, personalized customer experience. You will also play an active role in our data governance and data warehousing strategy. If you are looking for your next great adventure and have a desire to join a growing Data/BI team, where you can leverage your experiences working with data applications and tools by creating, implementing, and maintaining ETL processes…APPLY NOW!   Benefits You Will Enjoy Competitive Salary Generous Paid Time Off Health, Dental, and Vision packages to fit your needs Additional voluntary supplemental insurance plans Fully-vested 401(k) company match Tuition Assistance Program Career Pathing Program Generous employee discount Full range access at our Big Springs Shooting Complex Opportunity to work alongside people who are passionate about adventure and the outdoors!   What You Will Do Main Duties & Responsibilities Designs and develops data pipeline (ELT/ETL) architecture to load data from a wide range of sources to the Incorta cloud platform Plans, analyzes, designs, codes, tests, implements, and maintains moderately complex data projects Assists team members with design and acts as a resource for particularly difficult design projects Responsible for translating operational requirements for moderately complex systems; recommends and may assist in leading definition of user stories and design workshops, data modeling and prototyping; develops documentation as required Performs and may lead the testing of complex systems to ensure system reliability prior to implementation; develops and advises on innovative or blended techniques to meet customer needs; recommends application development team standards for testing; recommends and may develop metrics to evaluate process and system performance improvements Understands data pipelines and modern ways of automating data pipeline using cloud-based implementation Tests and clearly documents the requirements to create technical and functions specs Identifies, designs, and implements internal process improvements such as automation of manual processes, optimizing data processing, etc. Maintains current knowledge of information systems and technologies; recommends changes to design, development, and implementation standards when appropriate; responsible for technical application development for all stages in the development lifecycle Plays active role in data governance and data warehousing   What You Will Need Education & Experience Minimum 3 years of relevant experience Ideally 2+ years of experience with data pipeline design and development Ideally 2+ years of experience with SQL Ideally 2+ years of experience with ETL tools and methods Bachelor’s degree in related field is preferred, however additional relevant experience may be substituted Experience and proficiency in using scripting/coding languages and/or ETL tools in data transformation or lift-and-shift activities Familiarity and experience with connecting to a wide range of data sources (Google Analytics, 3rd party APIs, SharePoint, Azure SQL Server, etc.) Experience in Unit Test, System Integration Test and User Acceptance testing Experience developing reusable code, transformations, and templates to offset redundant coding and reduced development time and improving loading performance both at mapping and at session level   Knowledge & Skills Ability to design and develop data loading processes to load data from a wide range of sources such as M3DB, Oracle, flat files, Web Services, and Google Cloud Expertise in developing and implementing business logic through SQL Preferred technical understanding of data capabilities of Incorta High level of responsiveness to tasks/deliverables, with an ability to explain findings and guide/teach others on the capabilities of Incorta An active learner who is passionate about data and new technologies, and is comfortable recommending new and improved ways of doing things   Physical Demands Sedentary work. Sedentary work involves lifting no more than 10 pounds at a time and occasionally lifting or carrying articles like docket files, ledgers, and small tools. Although a sedentary job is defined as one which involves sitting, a certain amount of walking and standing is often necessary in carrying out job duties. Jobs are sedentary if walking and standing are required occasionally, and other sedentary criteria are met. Physical Hazards – Health and Safety Concerns General office environments Ergonomics   Where You’ll Be Located This is a remote role, requiring onsite work in Grinnell, Iowa, approximately 2-4 times a year.   Live Your Adventure! Brownells is a subsidiary of 2nd Adventure Group. At 2nd Adventure Group, our mission is to provide a platform to connect people with their passions. Our brands are aligned to empower people to be inspired, educated, and outfitted for a lifetime of enjoying and sharing the spirit of adventure. Our sister companies include: Crow Shooting Supply, Sinclair International, AR15.com, and Big Springs Shooting Complex. DISCLAIMER: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. In addition, the employer may consider whether the individual applying for or holding the position is qualified. There are two steps involved in this determination. The first concerns whether the applicant or current employee satisfies the prerequisites for the position. The second step involves whether or not the person can perform the essential functions with or without reasonable accommodation.   EOE Statement Brownells, Inc. is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, creed, color, religion, national origin, physical or mental disability, protected veteran status, age, genetic information, marital status, pregnancy, sexual orientation, gender identity or any other characteristic or status protected by law. If you need a reasonable accommodation for any part of the employment process, please contact us by email at careers@brownells.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this e-mail address. For more information, view the EEO is the Law Poster and Pay Transparency Statement.   This position is currently not accepting applications. To search for an open position, please go to http://crow.appone.com WE ALSO RECOMMEND Other Jobs Within Same Category Infor M3 Systems Analyst/Developer in Grinnell, Iowa Posted on: 1/27/2023 [Apply Now] Cyber Security Engineer in Grinnell, Iowa Posted on: 11/18/2022 [Apply Now] Other Jobs Within 60 Miles Cyber Security Engineer in Grinnell, Iowa Posted on: 11/18/2022 [Apply Now] Infor M3 Systems Analyst/Developer in Grinnell, Iowa Posted on: 1/27/2023 [Apply Now] Executive Assistant to the Chief Marketing Officer in Grinnell, Iowa Posted on: 3/24/2023 [Apply Now] Supply Planning Analyst in Grinnell, Iowa Posted on: 2/23/2023 [Apply Now] Senior Sales Representative in Montezuma, Iowa Posted on: 3/29/2023 [Apply Now]

Click here for technical assistance.