Job Summary:
The Systems Analyst will be responsible for developing mappings and workflows to automate ETL processes acquiring and integrating data from various sources designing complex SQL scripts and providing analytical and problem-solving skills for data analytics and warehousing projects. This role requires strong technical writing diagramming skills and experience in planning and delivering software platforms.
Location: Austin N/A Texas United States
Responsibilities:
- Develop mappings and workflows to automate ETL processes.
- Acquire and integrate data from multiple data sources for use in data visualization.
- Design and develop complex SQL scripts.
- Provide analytical and problem-solving skills for data analytics and data warehousing projects.
- Create technical documentation and diagrams.
- Plan and deliver software platforms.
- Develop scripts using Python.
- Participate on an agile sprint team.
- Write well-designed testable efficient code.
- Self-manage multiple responsibilities and prioritize assignments.
- Develop dashboards and reports.
Required Skills & Certifications:
- Experience developing mappings and workflows to automate ETL processes using Informatica IICS IDMC or Power Center.
- Experience acquiring and integrating data from multiple data sources.
- Experience designing and developing complex SQL scripts.
- Strong analytical and problem-solving skills.
- Technical writing and diagramming skills.
- Experience in planning and delivering software platforms.
- Bachelors degree in Computer Science Information Systems or Business or equivalent experience.
- Expertise and hands on experience with Web Applications and programming languages such as HTML CSS JavaScript JQuery and APIs
- Functional knowledge or hands on design experience with Web Services (REST SOAP etc.)
Preferred Skills & Certifications:
- Experience designing and developing scripts using Python.
- Experience on an agile sprint team.
- Experience with JIRA software.
- 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.
- Prior experience in the Healthcare Industry.
- Prior experience with an HHS agency.
- Prior experience working with PII or PHI data.
- Prior experience creating website/user interfaces by using standards HTML/CSS practices
- Experience developing dashboards and reports using Tableau including connecting to external data sources.
Special Considerations:
- Must understand security principles and how they apply to healthcare data.
Scheduling:
- Not specified.