Systems Analyst 3

Ampcus Incorporated

Austin, TX

JOB DETAILS
SKILLS
Adobe Acrobat, Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Background Investigation, Business Intelligence, Business Services, Communication Skills, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation, Enterprise Data Integration, GitHub, Government, Healthcare, Identify Issues, Informatica, Information Technology & Information Systems, Java, JavaScript, Microsoft Access Database, Microsoft Excel, Microsoft Office, Microsoft SQL Server, Microsoft Visio, Operational Support, Oracle Database, Performance Analysis, Performance Management, Problem Solving Skills, Python Programming/Scripting Language, Quality Assurance, REST (Representational State Transfer), SOAP (Simple Object Access Protocol), SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Scrum Project Management and Software Development, Snowflake Schema, Software Development Lifecycle (SDLC), State Government, Systems Analysis, Tableau, Technical Writing, Validation Testing, Web Services, Writing Skills, erwin Data Modeler
LOCATION
Austin, TX
POSTED
17 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 Description:
A state government healthcare technology team is seeking an experienced Systems Analyst 3 / Senior Data Engineer to support the development and enhancement of an enterprise data integration hub within a large-scale Performance Management & Analytics environment.

The selected candidate will work within an Agile development environment and support the design, development, implementation, and maintenance of enterprise data integration and analytics solutions. This role involves building ETL workflows, developing complex SQL transformations, automating data acquisition, and supporting data warehousing and business intelligence initiatives.

Key Responsibilities:

  • Develop and maintain ETL mappings and workflows using Informatica PowerCenter or IICS.
  • Acquire and integrate data from multiple sources including Oracle, SQL Server, Excel, Access, and Adobe PDF.
  • Design and develop complex Snowflake SQL scripts and database objects.
  • Create and maintain dimensional data models, views, and materialized views.
  • Develop automated data ingestion and transformation processes.
  • Perform data validation, testing, and quality assurance activities.
  • Participate in Agile sprint ceremonies and SDLC activities.
  • Collaborate with architects, developers, analysts, and stakeholders on solution design.
  • Produce technical documentation, diagrams, and specifications.
  • Support deployment, operations, and enhancements of the data integration hub.
  • Assist with troubleshooting and resolving technical issues.
  • Support analytics and reporting environments including Tableau.

Required Skills & Experience:

  • 8+ years of experience developing ETL mappings and workflows using Informatica PowerCenter or IICS.
  • 8+ years of experience integrating data from multiple technologies and data sources.
  • 8+ years of experience designing and developing complex Snowflake SQL scripts.
  • Strong experience with Oracle and SQL Server databases.
  • Strong analytical and problem-solving skills in data analytics or data warehousing environments.
  • Experience with dimensional modeling and enterprise data warehouse solutions.
  • Experience producing technical documentation and diagrams using Visio, Erwin, and Microsoft Office tools.
  • Proven ability to write efficient, scalable, and testable code.
  • Experience delivering software platforms across multiple organizational units.

Preferred Skills:

  • Agile/Scrum team experience.
  • Python scripting experience.
  • Tableau or business intelligence environment experience.
  • Healthcare industry experience.
  • Experience handling PHI/PII data.
  • JIRA experience.
  • CI/CD pipeline development using GitHub and GitHub Actions.
  • Experience with REST/SOAP Web Services.
  • Java and JavaScript development experience.
  • MuleSoft development experience.
  • Experience with AI-enabled tools such as Snowflake Cortex, Snowflake Intelligence, or Informatica Claire.
  • Prior experience with government or healthcare agencies.

Education:
Bachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience preferred.

Additional Information:

  • Candidates may be required to undergo a criminal background check.
  • Experience working in regulated healthcare or government environments is highly preferred.
  • Strong communication and documentation skills are essential for success in this role.


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