Data Analyst

Codetech • Kansas City, KS

2d • Remote

About The Position

The Production Data Analyst develops database queries, scripts, tools, and methods to manage data according to client requirements, technical standards, and time constraints. The work is primarily data analysis using T-SQL, including reviewing merchant data points in provided tables. The role emphasizes ETL procedures, update queries, and ad-hoc queries for clients and stakeholders. The analyst evaluates and writes SQL queries and creates and maintains database objects such as views, stored procedures, and user-defined functions. The role also follows software development and code-management practices and requires asking questions about outliers rather than making assumptions.

This is a remote, short-term assignment expected to last six months, with the possibility of extension; conversion to full-time employment is unlikely. The work schedule is 9:00 AM to 5:00 PM local time, with candidates required to be in an approved hub location. Candidates must complete a skills assessment and clear a background check before starting. The interview process consists of one 15–20-minute interview with the hiring manager.

Requirements

• Proficiency in SQL, including the ability to create and evaluate complex SQL statements involving multiple tables and complex relationships.
• At least 2 years of hands-on experience with MS SQL Server 2008 R2 or higher as a developer or DBA.
• Experience in data analysis and ability to work independently.
• Basic understanding of and experience with query performance tuning.
• Experience developing and maintaining ETL procedures.
• Ability to work in an environment with deadlines and shifting priorities.
• Effective verbal and written communication skills, with the ability to adjust communication for the intended audience.
• Fluency in English.
• A BS in Computer Science or a related discipline, or equivalent industry experience.
• Completion of the required skills assessment.
• Background check must clear before the start date.
• Must be located within an approved hub location.

Nice To Haves

• Experience with SSIS.
• Early-career experience or availability between jobs may suit the short-term assignment.

Responsibilities

• Develop and maintain ETL procedures according to client specifications and 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.
• Review merchant data points within provided tables and analyze data using T-SQL.
• Follow prescribed software development standards, processes, procedures, and methodologies.
• Interact and correspond professionally with team members, project management, clients, and other stakeholders.
• Accurately log time against project work.
• Ask questions when encountering outliers rather than making assumptions.

What This Job Offers

• Career Level: Entry Level