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 • 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 • 2+ years of experience with C# / .Net C# Programming • 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 the 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 Masters Degree in technology
Pay Range: $103,200.00-$150,500.00 Annual
In 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!
We are an equal employment opportunity employer. The Companys 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.