Information & Technology Management · 3 months ago
Systems Analyst 3 (7/22)
Austin, TX
Contract
Onsite
Senior Level, Lead/Staff
8+ years expInformation & Technology Management is seeking a Systems Analyst 3 to establish and configure the foundational infrastructure for the Data Integration Hub. The role involves applying Agile methodologies, automating data acquisition, and ensuring system efficiency through testing and quality assurance.
Information ServicesInformation Technology
No H1B
U.S. Citizen Only
Responsibilities
Establish and configure the foundational infrastructure required for the Data Integration Hub
Ensure scalability, security, and performance readiness of the infrastructure
Apply Agile methodology across all SDLC phases including planning, development, testing, and deployment
Create and manage Epics, User Stories, and Tasks to guide development efforts
Validate performance metric requirements to ensure system efficiency and reliability
Automate data acquisition from diverse internal and external data sources
Develop complex SQL scripts to transform raw data into a dimensional model
Create and maintain views and materialized views in Oracle for optimized data access
Utilize Informatica PowerCenter/IICS for data extraction, transformation, and loading (ETL)
Automate ETL processes to ensure timely and accurate data integration
Conduct integration, load, and stress testing to validate system robustness
Develop automated verification and validation processes for SQL scripts and ETL workflows
Deploy the Data Integration Hub internally and externally with proper version control and documentation
Ensure smooth rollout and accessibility for stakeholders
Provide ongoing support and enhancements to the Data Integration Hub
Address technical issues and implement improvements based on user feedback and evolving requirements
Lead Agile development teams and participate in sprint ceremonies
Collaborate with architects, data engineers, and stakeholders to refine designs and strategies
Develop mockups and engage with customers for validation and feedback
Produce and maintain technical specifications, diagrams, and documentation
Participate in requirements and design sessions to ensure alignment with business needs
Interpret changing business requirements and propose system enhancements accordingly
Qualification
Required
Experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS
Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF
Experience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient
Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project
Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project
Experience in planning and delivering software platforms used across multiple products and organizational units
Proven ability to write well designed, testable, efficient code by using best software development practices
Preferred
Excellent Oral And Written Communication Skills
Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required
Experience On An Agile Sprint Team
Understanding of security principles and how they apply to healthcare data
Experience with state of the art software components for a performance metrics data visualization or business intelligence environment
Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience
Prior Experience In The Healthcare Industry
Prior experience with an HHS agency
Prior experience working with PII or PHI data
Experience designing and developing scripts using Python
Experience with JIRA software
Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.)
Experience designing and developing code using Java and JavaScript
Experience developing CI/CD pipelines with GitHub and Git Actions
Experience As a Mulesoft Developer
Experience developing code in C#
Company
Information & Technology Management
Information & Technology Management: Pioneering Innovation Since 1989, Leading in MLOps Today! With over 20+ years as an IT leader driving digital transformation through software engineering, DevOps, Data Engineering, and Analytics, ITM has been at the forefront of technological innovation.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase