Data Analyst

Production Data AnalystThe work is almost exclusively data analysis using T-SQL. The position requires basic SQL competency. This is expected to be a short-term position (6 months) and may likely appeal to those early in their careers or between jobs. They will be reviewing merchant data points within given tables.HM is seeking candidates who are analytical, proficient in TSQL, comfortable asking questions when they encounter outliers (rather than making assumptions), and good cultural fit.Quiz or Skills Test: Candidates must complete the attached skills assessment to be considered.Remote/Onsite: RemoteTime Zone Requirements: All time zones, must be within approved hub locations.Work Schedule: 9 AM - 5 PM local timeTraining Schedule: Refer to the work scheduleInterview Process: One round with the hiring manager (15-20 minutes)Background Check: Background must clear prior to startPotential for Extension: YesSupplier Spotlight: YesThe Production Data Analyst (DA) develops database queries, scripts, tools, and methods to manage data according to client requirements, within defined technical standards, and within time constraints. Emphasis is on ETL procedures. The DA is proficient with relational database concepts and practices, is able to evaluate and write complex SQL queries, and can create and maintain common database objects such as views, stored procedures, and user-defined functions. The DA should be familiar with and able to utilize code management and/or revision control tools and follow standard software development practices. The majority of time is spent developing and refining ETL processes, writing update queries, and writing ad-hoc queries on behalf of clients and stakeholders.Job ResponsibilitiesDevelop and maintain ETL procedures according to client specifications and within defined technical standards.Develop and maintain database stored procedures, user-defined functions, views, triggers and other common database objects.Write custom and ad-hoc SQL queries and update queries.Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions.Interact and correspond professionally with team members, project management, clients, and other stakeholders.Account for and accurately log time against project work.QualificationsBS Computer Science or related discipline, or equivalent industry experience.2+ years hands-on experience with MS SQL Server, 2008 R2 or higher, as a developer or DBA.Strong SQL skills, able to create and to evaluate complex SQL statements involving numerous tables and complex relationships.Ability to work in an environment with deadlines and shifting priorities.Basic understanding of and experience with query performance tuning.Experience developing and maintaining ETL procedures.Experience with SSIS preferred.Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluency in English.CompetenciesIntegrityClient FocusResults-DrivenEntrepreneurial OrientationDecisivenessWork EnvironmentWork is fast-paced and performed in an office environment with extensive contact with clients and employees. The industry we serve demands the highest level of confidentiality and professionalism in safeguarding client and project information. Highly effective Class Action & Claims Solutions and Corporate Services associates thrive on being in an environment that rewards the following critical success factors:AdaptabilityAnalysisAttention to DetailCreativityDevelopment of OthersEnergyFlexibilityIntegrityLearning AbilityListeningTeam PlayerVerbal & Written CommunicationPhysical DemandsThe work environment characteristics described here are representative of those associate encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essentials functions.Position requires no significant manual labor.Position does require moderate standing, sitting, carrying and walking.Position requires infrequent lifting, repetitive bending and/or moving.Position requires close vision, distant vision, peripheral vision, and depth perception.Position requires talking and listening to communications with clients and employees.