Data Solutions Engineer
Camping World
full-time
Posted on:
Location Type: Remote
Location: Remote • Illinois, Kentucky, North Carolina, Tennessee, Texas • 🇺🇸 United States
Visit company websiteSalary
💰 $103,200 - $150,500 per year
Job Level
SeniorLead
Tech Stack
ETLInformaticaSQL
About the role
- Drive point to point data integration for the enterprise data warehouse and data marts
- Support the delivery of accurate and timely accounting/financial data for strategic decision support as a member of the enterprise data team
- Strong SQL development experience in SQL Server including T-SQL, procedures, functions, advanced queries and DDL
- 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
- Develop 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
- 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
- Significant Database Tuning Experience
- Ability to lead testing initiatives for releases as needed
- Project management skills
- 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
Benefits
- Paid Time Off
- 401(k)
- Employee Assistance Program
- Good Sam Roadside Assistance
- Discounts
- Paid parental leave (if eligibility is met)
- Tuition Reimbursement (if eligibility is met)
- On the job training opportunities
- Comprehensive benefit package including medical, dental, vision and more!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLT-SQLETLInformaticadata warehousingdata integrationdatabase tuningextract transform loadadvanced queriesDDL
Soft skills
complex problem solvinganalytical thinkingproject managementcommunicationself-motivatedprioritizationprofessional attitudeleadershipteam collaborationcustomer engagement