Job summary
Job post source
This job is from a recruiting firm hiring for a separate company as indicated by the mention of working closely with Texas Health and Human Services Commission and the submission deadline, typical of contract or consulting roles.
Job overview
The Systems Analyst 3 role involves analyzing business needs and automating data processes to support Texas Health and Human Services Commission, focusing on data integration, SQL scripting, and automation for improved data systems.
Responsibilities and impact
The candidate will develop and validate complex SQL scripts and Informatica automations, collaborate on data design, maintain Java web dashboards, produce technical documentation, and assist with development tools configuration.
Experience and skills
Requires 8 years of experience in Informatica ETL automation, complex SQL scripting, data acquisition from multiple sources, Python scripting for automation, technical writing, and defect tracking; preferred skills include AI-enhanced testing and automation frameworks.
Job location and travel
The position is based in Austin, TX with a hybrid schedule of 3 days remote and 2 days onsite.
Application process
Applicants must submit their applications by July 11, 2025, for a contract starting September 1, 2025, and ending August 31, 2026.
Unique job features
The role involves working on data analytics and automation projects with opportunities to engage with AI-enhanced testing and innovative automation frameworks.
Company overview
KAPITAL is a Japanese fashion brand known for its unique and eclectic designs that blend traditional Japanese craftsmanship with contemporary streetwear aesthetics. Founded in the 1980s by Toshikiyo Hirata, the company initially focused on denim production before expanding into a full range of apparel and accessories. KAPITAL makes money through direct sales in its flagship stores, online platforms, and select high-end retailers worldwide. The brand is celebrated for its meticulous attention to detail, innovative use of fabrics, and distinctive, often whimsical, design elements.
How to land this job
Position your resume to showcase your expertise in developing complex SQL scripts and automating ETL processes using Informatica IICS or Power Center, as these are critical for the Systems Analyst 3 role at KAPITAL.
Highlight your experience with data acquisition from multiple sources such as Snowflake, Oracle, SQL Server, Excel, and Adobe PDF, emphasizing your ability to transform and integrate data for dimensional modeling and Tableau visualization.
Apply through multiple channels including KAPITAL's corporate careers page and LinkedIn to maximize your chances, ensuring your application is visible to different hiring managers and recruiters.
Connect with current Systems Analysts, Data Engineers, or team members in the Texas Health and Human Services Commission division at KAPITAL on LinkedIn; start conversations by complimenting recent projects they've shared or asking about their experience working with data automation and Tableau dashboards.
Optimize your resume for ATS by incorporating keywords from the job description such as 'SQL scripts,' 'Informatica IICS,' 'ETL automation,' 'data acquisition,' 'Python scripting,' and 'test plans' to ensure your resume passes initial automated screenings.
Use Jennie Johnson's Power Apply feature to automate applying across multiple platforms, tailor your resume with relevant keywords, and identify LinkedIn contacts to network with, saving you time and increasing your chances of landing the position.
Jennie Johnson works for you!
Here’s what we do to make sure you’re successful:
Targeted Resume Revamp:
We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.
Job Description Dissection:
Unpack the job posting with expert analysis, ensuring your application hits every key requirement.
Bespoke Cover Letter:
Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.
Interview Mastery:
Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.
Direct Application Insights:
Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.
Skills and Gaps Assessment:
Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.
Personalized Email Pitch:
Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.
In-depth Research Guide:
Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.
Detailed Company Analysis:
Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.
Strategic Candidate Overview:
Understand your unique value and why companies would want to interview you, highlighting your background and positioning.