Data Warehouse Engineer

Company Information

Recognized as one of the Best Places to Work in South Carolina, AMAROK (formerly known as Electric Guard Dog) is the Ultimate Perimeter Security solution. Our unique and technically advanced electric fence reliably stops theft and other criminal activity by guarding our customers’ property and assets 24/7. We are active in 48 states and Canada with more than 4,000 commercial and industrial locations.

Summary

This contract assignment will assist the AMAROK Technical Lead, Applications & Data with the creation of the first version of the AMAROK Data Warehouse.

This is a 6 month renewable contract with the possibility of becoming a permanent position. This role would require occasional travel to our headquarters in Columbia, SC.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Provide primary technical development and support for the AMAROK data warehouse.
• Working with IT, Business Leads, and Subject Matter Experts, create detailed requirements for AMAROK Data Warehouse, beginning with Finance and Sales Subject Areas.
• Assist with design and build of SSAS tabular data model.
• Extract, transform, and load AMAROK data into the SSAS tabular data model.
• Develop key deliverables including dashboards, reports, and analyses in PowerBI and SSAS.

Experience

• Bachelor’s degree from four-year college or university, preferably in Computer Science or equivalent technical/engineering field preferred, and 5+ years of industry experience as a SQL Server DBA, Data Engineer, Application Engineer, or related technical role.
• Proven Data Warehouse analysis and design experience
• Hands on and in-depth working experience in Data Warehouse (i.e. SQL Server, SSAS) and Visualization Platforms (i.e., PowerBI, Tableau, QlikView)
• Proven experience with ETL function and tools (i.e. Tray, Talend, MuleSoft)
• Relational Data Design and Management across complex systems
• Strong understanding of Systems Development Lifecycle (SDLC)
• Experience with Custom Application Development a plus

Our recruiting experience is digital! AMAROK is an EEO/Affirmative Action Employer and will make all employment related decisions without regard to age, race, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, or veteran status.