Senior Technical Analyst (Contract)

Job Title: Senior Technical Analyst

Location: Merrillville, IN (Remote)

Rate: $45 - $50/hr

Contract Duration: 1 Year (with possible extensions)

Contract Type: W-2 (Must be authorized to work in the U.S.; no sponsorships, no F1-OPT sponsorships available and no C2C)

Job Description

We are seeking, for our client, a detail-oriented Senior Technical Analyst with expertise in data analysis and processing. In this role, you will be responsible for extracting, cleansing, transforming, and validating data from multiple sources. The ideal candidate will apply logical frameworks to structured data and validate outputs using images. Strong proficiency in Excel (advanced formulas, macros), Power BI, and SQL is required. This role demands excellent analytical skills, the ability to automate repetitive tasks, and a keen eye for accuracy. Experience with workflow automation, data integrity checks, and making informed decisions based on validated insights is essential. Additionally, experience in coordinating with contractors and facilitating effective communication between internal and external stakeholders is a plus.

Key Responsibilities

• Data Processing:
  • Extract, cleanse, transform, and validate data from various sources.
  • Apply logical frameworks to structured data and validate outputs using images.
• Analysis & Reporting:
  • Develop and maintain advanced Excel models (including formulas and macros) to analyze data.
  • Utilize Power BI and SQL to generate insightful reports and dashboards.
• Automation & Efficiency:
  • Automate repetitive tasks to improve operational efficiency.
  • Perform data integrity checks to ensure accuracy across datasets.
• Collaboration & Communication:
  • Coordinate with internal teams and contractors to ensure seamless data processing.
  • Communicate findings and recommendations effectively to stakeholders.

Qualifications

• Education:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).

• Experience:

  • Minimum of 3 years of experience in data analysis, extraction, cleansing, transformation, and validation.

• Technical Skills:

  • Strong proficiency in Microsoft Excel (advanced formulas, macros).
  • Proficient in Power BI and SQL.
  • Experience with workflow automation and data integrity checks.

• Soft Skills:

  • Excellent analytical and problem-solving abilities.
  • Strong written and verbal communication skills.
  • Proven ability to coordinate with contractors and facilitate communication between diverse stakeholders.

Salary : $45 - $50