Optum Services Inc. is looking to solve the problem of transforming raw data into meaningful information to support analytics and insight generation for their clients, ultimately aiming to make healthcare work better for everyone.
Requirements
- Data engineering, ingestion, normalization, transformation, aggregation, structuring, and storage
- Working with industry standard relational, dimensional or non-relational data storage systems
- Designing ETL/ELT solutions using tools such as Azure Data Factory, Databricks, Pyspark, Informatica, DataStage, SSIS , PL/SQL, or T-SQL
- Managing data assets using SQL, Python, Scala, Java, R or other similar querying/coding language
- Working with healthcare data or data to support healthcare organizations
- Creating Source to Target Mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
- Supporting data pipelines that power analytical content within common reporting and business intelligence platforms such as Power BI, Qlik, Tableau, or MicroStrategy
Responsibilities
- implement and manage cross-domain, modular, flexible, scalable, secure, reliable and quality data solutions that transform data to support analytics and insight generation for our clients
- implement, test, deploy, monitor, and maintain the delivery of data in a systematic method and will support a wide variety of analytical needs for our customers
- Support the full data engineering lifecycle including research, proof of concepts, design, development, testing, deployment, and maintenance of data management solutions
- Lead data acquisition efforts to gather data from various structured or semi-structured source systems of record to hydrate client data warehouse and power analytics across numerous health care domains
- Leverage combination of ETL/ELT methodologies to pull complex relational and dimensional data to support loading DataMart's and reporting aggregates
- Detect data quality issues, identify root causes, implement fixes, and manage data audits to mitigate data challenges
- Implement, modify, and maintain data integration efforts that improve data efficiency, reliability, and value
Other
- Telecommuting available from anywhere in the U.S.
- Candidates are required to pass a drug test before beginning employment.
