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.
data engineer, ingestion, normalization, transformation, aggregation, structuring, and storage
relational, dimensional, or non-relational data storage systems
Leverage DevOps tools to enable code versioning and code deployment
designing ETL/ELT solutions using tools like SSIS, Informatica, DataStage, Health Catalyst, PL/SQL, T-SQL, etc.
creating Source to Target Mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
with healthcare data or data to support healthcare organizations
data warehousing solutions, knowledgebase, and analytics solution
Experience in Unix, Linux or Powershell or other batch scripting language
Depth of experience and proven track record creating and maintaining sophisticated data frameworks for healthcare organization
Experience supporting data pipelines that power analytical content within common reporting and business intelligence platforms (e.g. MicroStrategy , Power BI, Qlik, Tableau, etc.
supporting analytical capabilities inclusive of reporting, dashboards, extracts, BI tools, analytical web applications and other similar products
proven contribution in creating healthcare insights
Nice to have: exposure to Azure, AWS, or google cloud ecosystems, Amazon Redshift, Amazon S3, Hadoop HDFS, Azure Blob, or similar big data storage and management components
