Systems Analyst 3

Ampcus Incorporated

Austin, TX

JOB DETAILS
SKILLS
Adobe Acrobat, Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Automation, Best Practices, Business Analysis, Business Services, Communication Skills, Computer Programming, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Department of Health and Human Services, Dimensional Modeling, Documentation Models, Enterprise Applications, GitHub, Healthcare, Identify Issues, Informatica, Information Technology & Information Systems, Java, JavaScript, Microsoft Access Database, Microsoft Excel, Microsoft Office, Microsoft Project, Microsoft SQL Server, Microsoft Visio, Multitasking, Oracle Database, Performance Analysis, Performance Management, Problem Solving Skills, Python Programming/Scripting Language, REST (Representational State Transfer), Requirements Management, SOAP (Simple Object Access Protocol), SQL (Structured Query Language), Scripting (Scripting Languages), Scrum Project Management and Software Development, Snowflake Schema, Software Development, Systems Analysis, Technical Writing, Web Services, erwin Data Modeler
LOCATION
Austin, TX
POSTED
19 days ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

 

Job Title: Systems Analyst 3

Location(s): Austin, TX


Job Summary:
Texas Health and Human Services Commission is seeking a Systems Analyst 3 / Data Engineer to support the development and enhancement of the Performance Management & Analytics System (PMAS) data integration hub. The role involves ETL development, data integration, Snowflake SQL development, Informatica automation, dimensional modeling, and agile-based data engineering activities.

Key Responsibilities:

  • Lead and support agile data engineering initiatives.
  • Develop and maintain ETL mappings/workflows using Informatica Power Center or IICS.
  • Acquire and integrate data from multiple sources including Oracle, SQL Server, Excel, Access, and Adobe PDF.
  • Design and optimize complex Snowflake SQL scripts.
  • Create database views and materialized views.
  • Build automation for data acquisition and transformation.
  • Participate in sprint ceremonies and collaborate with architects and engineering teams.
  • Develop technical documentation, diagrams, and specifications.
  • Support testing, deployment, validation, and operational enhancements.
  • Analyze business requirements and recommend technical solutions.
  • Assist with CI/CD, validation automation, and troubleshooting.

Required Skills:

  • 8+ years Informatica Power Center or IICS ETL development.
  • 8+ years data integration from multiple technologies/sources.
  • 8+ years Snowflake SQL scripting and optimization.
  • 8+ years experience in data warehousing, analytics, or performance management systems.
  • Strong analytical, problem-solving, and system analysis skills.
  • Technical documentation and modeling expertise (Visio, Erwin, MS Office, MS Project).
  • Experience delivering enterprise software platforms.
  • Strong coding and software development best practices.

Preferred Skills:

  • Agile/Scrum team experience.
  • Healthcare or HHS agency experience.
  • Experience handling PII/PHI data.
  • Python scripting.
  • JIRA.
  • REST/SOAP web services.
  • Java and JavaScript.
  • GitHub/GitHub Actions CI/CD pipelines.
  • MuleSoft development.
  • AI tools such as Snowflake Cortex, Snowflake Intelligence, or Informatica Claire.
  • Understanding of security principles in healthcare data environments.

Preferred Qualifications:

  • Bachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience.
  • Strong communication and multitasking abilities.
 

Interview:

  • May include pre-selection requirements and background check.


Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com