Data Solutions Engineer
Source: Himalayas
AI Summary Powered by Gemini
This role involves driving enterprise data integration for a data warehouse and data marts, with a focus on accounting and financial data. Key requirements include strong SQL and ETL development experience, with a minimum of 8 years in data warehousing.
Job Description
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 experienceResponsibilities:Strong SQL development experience in SQL Server including T-SQL, procedures, functions, advanced queries and DDLAbility to develop/support Informatica (or similar advanced ETL tool) workflows/mappings based upon user requirements and data modelingMigrate code between test, Quality Assurance (QA) and production environmentsDevelop and maintain extract, transform and load (ETL) jobs within a complex enterprise data warehouse environment in support of financial users and analytical applicationsDevelops a complete set of ETL documentation describing the current configuration of the systemConfiguration of the ETL environments to meet user and security requirements. Familiarity with audit loggingPerformance tune SQL statements executed by ETL code as required for tuning, develop standards and tuning metrics and alert thresholdsPerform source system analysis as required, understanding of windows operating systemRequirements:Willingness to work with customers, managers, and executives of varying levels of technical expertise while always maintaining a professional attitudeSelf-motivated with ability to prioritize and succeed with varying degrees of requirementsExcellent oral and written communication and problem-solving skillsMinimum of 8 years ETL and Data Warehousing experience2+ years of experience with C# / .Net C# ProgrammingAdvanced T-SQL and ETL experience extracting data from databases, flat files, and ExcelComplex problem solving and analytical thinkingExcellent oral and written communications, including the ability to translate technical information for a business audienceSignificant Database Tuning ExperienceAbility to lead testing initiatives for releases as neededExperience in supporting multiple products/projects simultaneouslyProject management skillsDesirable:Bachelors or Master's Degree in technology.Pay Range:$105,800.00-$162,200.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.comWe 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.Originally posted on Himalayas
Full Description
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 experienceResponsibilities:Strong SQL development experience in SQL Server including T-SQL, procedures, functions, advanced queries and DDLAbility to develop/support Informatica (or similar advanced ETL tool) workflows/mappings based upon user requirements and data modelingMigrate code between test, Quality Assurance (QA) and production environmentsDevelop and maintain extract, transform and load (ETL) jobs within a complex enterprise data warehouse environment in support of financial users and analytical applicationsDevelops a complete set of ETL documentation describing the current configuration of the systemConfiguration of the ETL environments to meet user and security requirements. Familiarity with audit loggingPerformance tune SQL statements executed by ETL code as required for tuning, develop standards and tuning metrics and alert thresholdsPerform source system analysis as required, understanding of windows operating systemRequirements:Willingness to work with customers, managers, and executives of varying levels of technical expertise while always maintaining a professional attitudeSelf-motivated with ability to prioritize and succeed with varying degrees of requirementsExcellent oral and written communication and problem-solving skillsMinimum of 8 years ETL and Data Warehousing experience2+ years of experience with C# / .Net C# ProgrammingAdvanced T-SQL and ETL experience extracting data from databases, flat files, and ExcelComplex problem solving and analytical thinkingExcellent oral and written communications, including the ability to translate technical information for a business audienceSignificant Database Tuning ExperienceAbility to lead testing initiatives for releases as neededExperience in supporting multiple products/projects simultaneouslyProject management skillsDesirable:Bachelors or Master's Degree in technology.Pay Range:$105,800.00-$162,200.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.comWe 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.Originally posted on Himalayas