The Data Solutions Engineer I will drive point to point data integration for the enterprise data warehouse and data marts. Experience with retail industry sales, inventory, accounting and financial reporting data is a plus. As a knowledgeable developer in data integration, this individual will support the delivery of accurate and timely accounting/financial data for strategic decision support as a member of the enterprise data team.
Compensation: $103-129k salary with benefits; commensurate with experience
Responsibilities:
Strong SQL development experience in SQL Server including T-SQL, procedures, functions, advanced queries and DDL
Ability to develop/support Informatica (or similar advanced ETL tool) workflows/mappings based upon user requirements and data modeling
Migrate code between test, Quality Assurance (QA) and production environments
Develop and maintain extract, transform and load (ETL) jobs within a complex enterprise data warehouse environment in support of financial users and analytical applications
Develops a complete set of ETL documentation describing the current configuration of the system
Configuration of the ETL environments to meet user and security requirements. Familiarity with audit logging
Performance tune SQL statements executed by ETL code as required for tuning, develop standards and tuning metrics and alert thresholds
Perform source system analysis as required, understanding of windows operating system
Requirements:
Willingness to work with customers, managers, and executives of varying levels of technical expertise while always maintaining a professional attitude
Self-motivated with ability to prioritize and succeed with varying degrees of requirements
Excellent oral and written communication and problem-solving skills
Minimum of 8 years ETL and Data Warehousing experience
Advanced T-SQL and ETL experience extracting data from databases, flat files and excel
Complex problem solving and analytical thinking
Excellent oral and written communications including ability to translate technical information for a business audience
Significant Database Tuning Experience
Ability to lead testing initiatives for releases as needed
Experience in supporting multiple products/projects simultaneously
Project management skills
Desirable:
Bachelors or Master's Degree in technology.
.Net C# Programming experience.
Pay Range:
$103,200.00-$150,500.00 AnnualIn addition to competitive pay, we offer Paid Time Off, 401(k), an Employee Assistance Program, Good Sam Roadside Assistance, discounts, paid parental leave (if eligibility is met), Tuition Reimbursement (if eligibility is met), and on the job training opportunities. Full-time associates are offered a comprehensive benefit package including medical, dental, vision and more! Part-time associates are offered access to dental & vision coverage! For more information please visit: www.mycampingworldbenefits.com
We are an equal employment opportunity employer. The Company's policy is not to discriminate against any applicant or employee based on race, color, sex, sexual orientation, gender identity, religion, national origin, age (40 and over), disability, veteran or uniformed service-member status, genetic information, or any other basis protected by applicable federal, state, or local laws.