Job Description
The Kinetic Group is a world leader in the design, manufacturing, and distribution of small caliber ammunition under the iconic brands B&P, CCI, Federal Premium, Fiocchi, HEVI-Shot, Remington and Speer. We have domestic ammunition manufacturing facilities in Minnesota, Idaho, Arkansas, and Missouri, and service law enforcement, government agencies and sporting enthusiasts throughout the world. Today, The Kinetic Group is a part of the Ammo+ division of The Czechoslovak Group (CSG), which holds a diverse portfolio of companies in the defense, security, automotive, aerospace and rail industries.
We are seeing a BI Developer to design and create Tabular Cubes, SSIS Integrations and SRSS reports for our Sporting Products division, The Kinetic Group. This role will leverage your understanding of complex business logic and your ability to build code for multi-lingual, multinational applications. Interfacing with other developers and architects on a global basis, you will own projects from the requirements phase and through deployment, ensuring that design and quality standards are met. Creativity, drive, initiative, and customer service are imperative to success. You will collaborate with users and/or Business Analysts to define BI requirements. From requirements, you will develop proofs of concept to validate ideas or technologies as we create and deliver data products (i.e., reports, dashboard/scorecards, self-service options, and BI query objects) that will streamline operations and scale with the business.?As a member of the IT team, you will be responsible for on-going process improvements, developing a collaborative environment and building relationships with the business.
This position reports directly to our VP Information Technology, and is based out of our Anoka, MN location.
What you'll do :
Design, develop and maintain Tabular models based on Operational Data Store and/or Enterprise Data Warehouse.
Design and develop SSRS reports and SSIS integrations.
Entity Relation Diagram (ERD) and metadata documentation of data services including Tabular models and SSRS Reports.
Works with corporate IT to help manage and maintain the BI environment.
Respond and resolve data discrepancies and performance issues related to Tabular models and SSRS Reports.
Software Used: Visual Studio, SSRS, SSAS, SSMS.
??
Experience you bring :
Bachelor's degree in IT related discipline or equivalent experience.
2-5 years translating business requirements into SSRS reports, Tabular Models and SQL views and Stored Procedures.
Proven experience with the Microsoft Business Intelligence stack.
Experience with data architecture, including Enterprise Data Warehouse and Operational Data Store.
Experience tuning queries to optimize for large datasets.
Proven experience working with complex SQL Queries and multi-domain Enterprise Operational Data Store.
Superior problem-solving and multi-tasking abilities with strong customer service orientation.
Knowledge of ERP application and supply chain data.
Knowledge of Manufacturing and B2B business processes.
Experience with Agile methodologies.
Work Environment:
Employee work assignments may include tasks working with and/or exposure to potentially hazardous areas, including flammables and explosives. Safety training is provided to all employees to ensure compliance with company and federal regulations.
Pay Range:
$75,800.00 - $106,000.00
The actual annual salary offered to a candidate will be based on variables including experience, geographic location, education, and skills/achievements, and will be mutually agreed upon at the time of offer.
We offer a highly competitive salary, comprehensive benefits including: medical and dental, vision, disability and life insurance, 401K, PTO, tuition reimbursement, gear discounts and the ability to add value to an exciting mission!
Our Postings are not intended for distribution to or use in any jurisdiction, country or territory where such distribution or use would violate local law or would subject us to any regulations in another jurisdiction, country or territory. We reserve the right to limit our Postings in any jurisdiction, country or territory.
Equal Opportunity Employer Minorities/Females/Protected Veteran/Disabled
International Traffic in Arms Regulation (ITAR) and Export Administration Regulation (EAR) Requirements:
To conform to U.S. Government export regulations, applicant must be a (i) U.S. citizen or national; (ii) U.S. lawful, permanent resident (a/k/a green card holder); (iii) Refugee under 8 U.S.C. Section 1157; or (iv) Asylee under 8 U.S.C. Section 1158 or be eligible to obtain the required authorizations from the U.S. Department of State.
Gun Control Act Requirements:
It is unlawful for these categories of persons to possess (for business or personal reasons) firearms or ammunition: (i) convicted of a crime punishable by imprisonment for a term exceeding one year; (ii) fugitive from justice; (iii) unlawful user of or addicted to any controlled substance (as defined in section 102 of the Controlled Substance Act 21 U.S.C. 802); (iv) who has been adjudicated as a mental defective or has been committed to any mental institution; (v) illegal alien; (vi) discharged from the Armed Forces under dishonorable conditions; (vii) who has renounced his or her United States Citizenship; (viii) who is subject to a court order restraining the person from harassing, stalking, or threatening an intimate partner or child of the intimate partner; or (ix) who has been convicted of a misdemeanor crime of domestic violence.
Across The Kinetic Group, we rally for the customer by fostering collaboration, sharing insights and scaling competencies. We engineer our products in ways that match the drive of the people who put them to work in the field, on the course and on the battlefield. We're not just a name on the door - we are the people developing the products that help customers the world over.
The Kinetic Group is an equal opportunity employer. All applicants are considered for employment without to regard race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and any other characteristics protected by law. The EEO Law poster is available here: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf
If you need a reasonable accommodation because of a disability for any part of the employment process, please send an e-mail to careers@tkghunt.com .