Systems Analyst 3

MKS2 Technologies, LLC, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Cyber Security, Instructional Design and Training, Software Engineering and IT Support Services to improve the security and well-being of our clients. Our commitment to excellence and our “Mission First” orientation has resulted in steady growth and an expanding client base across government agencies. We have employees nationwide and for the past three consecutive years were named one of the fastest growing Veteran-owned companies in the nation. Please take a moment to browse through our website and learn more about what it means to serve with MKS2.

Category: Applications/Software Development
Location: 4601 W Guadalupe St, Austin, TX 78751 (On-site only)
Duration: 09/01/2025 – 08/31/2026 (with possible renewals)
Hours: Full-time
Salary: $150,000- $160,000
Work Authorization: Local candidates only (within 50-mile radius of Austin, TX)

Benefits: Medical, Dental, Vision - 7 PTO days, 6 paid holidays. 

Job Description:

The Texas Health and Human Services Commission (HHSC) is seeking a Systems Analyst 3 to support the development and enhancement of a data integration hub. The candidate will work within an agile team to design, develop, and implement data solutions that support performance metrics and business intelligence.

Responsibilities:

• Lead agile development teams and serve as a technical leader.
• Acquire and integrate data from various sources (Oracle, SQL Server, Excel, Access, PDF).
• Develop complex SQL scripts and automate ETL processes using Informatica Power Center/IICS.
• Design and implement dimensional data models and materialized views.
• Collaborate with architects and data engineers on optimal data design.
• Validate and verify SQL scripts, Informatica workflows, and database views.
• Participate in sprint ceremonies and requirements/design sessions.
• Create mockups and technical documentation.
• Support deployment, operations, and enhancements of the data integration hub.
• Ensure compliance with security and data privacy standards.

Minimum Qualifications:

• 8+ years of experience with:
  • Informatica Power Center/IICS for ETL automation.
  • Data integration from multiple sources for Tableau.
  • Complex Oracle/Snowflake SQL scripting.
  • Systems analysis for data analytics or warehousing.
  • Technical writing and diagramming (Visio, Erwin, MS Office).
  • Software platform planning across organizational units.
  • Writing efficient, testable code using best practices.

Preferred Qualifications:

• 6+ years: Strong communication and multitasking skills.
• 4+ years: Agile team experience, healthcare data security, BI tools, Python scripting, JIRA, HHS agency experience, handling PII/PHI.
• 2+ years: Java/JavaScript, REST/SOAP web services, CI/CD with GitHub Actions, Mulesoft, C# development.
• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).

Additional Requirements:

• Must pass a criminal background check.
• Must sign HHSC Acceptable Use and Integrity Agreements.
• Must complete cybersecurity training.
• Must already reside in Texas (no relocation candidates).
• May be required to work evenings, weekends, or holidays.

Diversity creates a healthier atmosphere: MKS2 Technologies is proud to be an Equal Employment Opportunity / Affirmative Action employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.