ETL Developer & Analyst

Company: clairesinc
Location: Hoffman Estates
Posted on: July 31, 2022

Job Description:

ETL Developer & AnalystResponsible for analysis, design, development, maintenance and support for various data applications within a business intelligence, and advanced analytics in a retail domain environment.---Leverage Microsoft SQL Server Integration Services and related services to design and develop solutions integrating with Internal Applications, Power BI, and Analytics Platforms, in support of a retail environment---Facilitate the conversion of legacy systems ---Leverage data quality prototypes and mappings to operationalize as production jobs ---Work with technical leads, architects, subject matter experts, developers, vendor teams, technical support groups and test teams to deliver value to the business ---Design, prototype, develop, test cases, and document ETL components ---Ability to convert legacy systems to modern applications and platforms ---Perform unit testing of ETL components and document test results ---Support all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing ---Support the ongoing operation of data applications and scheduled jobs ---Provide timely response and resolution of emergency production questions, issues and defects ---Maintain and monitor job schedules About You---Bachelor's degree in Computer Science / MIS, or equivalent work experience ---7+ years' experience implementing and supporting MS based ETL tools and technologiesExperience with Data Quality and Cloud Integration toolsExperience with complex SQL and relational databasesMicrosoft SSIS experience Strong technical and analytical skills MS Azure experience a plus Working knowledge of scripting languages like PowerShell Net programming experience (VB.Net or C#) is a plus --- Excellent skills in writing, maintaining, testing and debugging code in T-SQLExperience with version control softwareExcellent written and verbal communication required Experience writing process flows and requirements documents. Experience in researching and interpreting data, with a solid understanding of relational database concepts and table design Strong demonstration of the skills to align business needs with IT capabilities requiredClaire's is an equal opportunity employer with a strong commitment to diversity and inclusion. We prohibit discrimination on the basis of race, color, religion, sex, age, national origin, sexual orientation, gender identity or expression, disability, veteran status, marital status, or any other legally protected status. Applications by members of all underrepresented groups are encouraged.

Keywords: clairesinc, Hoffman Estates , ETL Developer & Analyst, Professions , Hoffman Estates, Illinois