Description

Design and implement data integration solutions supporting dimensional modeling and visualization.

Responsibilities

• Develop complex Oracle SQL scripts, views, and materialized views to transform source data into dimensional models.
• Build automation workflows using Informatica Power Center and IDMC to ingest data from external sources.
• Maintain Java-based web interfaces used for Tableau dashboard delivery.
• Translate business requirements into technical enhancements and functional mockup validations.
• Collaborate with architects and data engineering teams on implementation designs and acquisition strategies.

Required Skills

• 8+ years developing and administering Informatica Power Center and IDMC.
• 8+ years designing efficient, complex Oracle SQL scripts.
• 8+ years integrating data from Oracle, SQL Server, Excel, Access, and Adobe PDF.
• 8+ years developing scripts using Python.
• 8+ years working within Agile sprint teams using JIRA.
• 8+ years with technical writing and diagramming using Visio or Erwin.
• 8+ years planning and delivering software platforms across multiple organizational units.
• Strong analytical skills acting as a system analyst for data warehousing or performance management projects.
• Proficiency with Microsoft Office Suite, including Excel, Word, PowerPoint, and MS Project.

Preferred Skills

• Bachelor's degree in Computer Science, Information Systems, or Business.
• Experience applying security principles to healthcare data.
• Proven ability to write well-designed, testable, and efficient code.

Key Skills

Education

Bachelor's Degree