HS Intern Data Engineering

HSIntern Data Engineering

Chicago, IL (Hybrid)

The American Medical Association (AMA) is the nation's largest professional Association of physicians and a non-profit organization. We are a unifying voice and powerful ally for America's physicians, the patients they care for, and the promise of a healthier nation. To be part of the AMA is to be part of our Mission to promote the art and science of medicine and the betterment of public health.

We continuously work to embed equity in our internal practices and are committed to increasing the diversity of our staff across all levels of the organization. We intentionally work to create the right conditions to enable our employees to feel that they can be their authentic selves and fully participate in the life of the enterprise.

We encourage and support professional development for our employees, and we are dedicated to social responsibility. We invite you to learn more about us and we look forward to getting to know you.

We have an opportunity at our corporate offices in Chicago for a HSIntern Data Engineering on our HSProduct Development & Data Ops team. This is a hybrid position reporting into our Chicago, IL office, requiring 2 days a week in the office.

As a HSIntern Data Engineering; you will support the expansion of the Health SolutionsData Science function through the analysis of existing AMA data assets as wellas potential data acquisitions opportunities that would provide benefit to theAMA. Conduct analyses to enhance thecollection, enrichment, and management of AMA's data, to optimize current usageand enable new business uses of these data assets. Develop consistent and timely analysis ofmetrics and key performance indicators, scorecards and trending reports thatlead to informed business decisions and reflect the true state of AMA dataassets. Assist in the implementation ofthe long-range AMA Physician Masterfile strategy and the overall data managementprocess modernization effort. Assist indevelopment of innovative Data Science approaches to enhance analyticalcapabilities of the Health Solutions Group.

RESPONSIBILITIES:

• Support the Data Management group and overall Health Solutions team through insightful data analysis and the development of analytical reporting, including subject areas of data collection, data quality, business rule adherence, and optimal choice of data fitness.
• Tailor analytical/reporting output to be digestible given the audience through usage of visualization and dashboards.
• Utilize technical acumen to automate reports over time and eliminate unnecessary manual processes.
• Support the overall effort to modernize and enhance AMA data management architecture.
• Assist in development and testing of innovative analytical approaches, including but not limited to Big Data, A.I., machine learning, text analytics, and Natural Language
• Processing (NLP).Assist in vendor integration, data management work flow evaluation and optimization, vendor service level adherence monitoring activities, and requirements gathering around internal data management processes as effort moves forward.
• Respond to data analysis needs and help deliver data analysis projects through the appropriate choice of front-end error detection and correction, process control and improvement, or process design strategies.
• Develop testing and processes to ensure data integrity and accuracy of the data, as well as proof of concept matching exercise to vet external data sources and gauge benefit.
• Follow all processes and procedures and provide documentation on all work.
• Support the ongoing effort to master AMA data assets through the implementation of an enterprise wide physician Masterfile strategy, work closely with technology partners to leverage technology tools to the utmost and understand internal data flow and ETL activities between current AMA systems and future platforms.

May include other responsibilities as assigned

REQUIREMENTS:

1. Be working towards a BS or MS degree in Data Science, Statistics, Analytics, Computer Science, Information Systems, or a related degree.
2. Basic analysis skills; familiar with data analysis tools and techniques, such as SAS, R, Python, SPSS, text analytics, NLP; Able to manage and integrate insights and establish monitoring around multiple internal data sources, such as AMA Masterfile, Enterprise Data Warehouse, customer database and purchased/appended data if available.
3. Ingestion, standardization, metadata management, business rule curation, data enhancement, and statistical computation against data sources that include relational, XML, JSON, streaming, REST API, and unstructured data.
4. Understanding of orchestration and scheduling tooling such asJenkins/Airflow/Rundeck
5. Experience and interest in presenting analytic findings to business customers.
6. Familiar with reporting and visualization tools, such as Tableau, Power BI, Business Objects, etc.
7. Familiar with SQL in the extraction and manipulation of datasets.
8. General knowledge of transactional data processing, ETL, data warehouse, data mart, and operational reporting solutions a plus.Any experience with the following tools is desirable: Aqua Data Studio, IBM DataStage / QualityStage, Information Analyzer, Informatica Business Glossary and Powercenter.
9. Any experience with or basic understanding of newer database structures and models such as NoSQL, Hadoop, Marklogic and Cassandra, a plus.
10. Programming skills in Python, Java highly desirable.
11. Experience and interest in deeper analysis of data subjects, potentially spanning over a timeline of several months.
12. Experience with various batch matching methodologies. Willingness to learn and work with disparate data sets of varying structures and quality and interested in creating ad hoc methodologies to facilitate matching on these data sets, often without the benefit of common keys.
13. Any knowledge/interest in implementing data management systems, ETL development, or master data management solutions is highly desirable.

What Puts You Over The Top • Some practicalexperience working on AWS or another cloud provider • Some practical experiencedeveloping with Apache Spark and/or Hive • Good knowledge of SQL and experiencewith columnar datastores • You are working on your Masters degree

The American Medical Association is located at 330 N. Wabash Avenue, Chicago, IL 60611 and is convenient to all public transportation in Chicago.

We are an equal opportunity employer, committed to diversity in our workforce. All qualified applicants will receive consideration for employment. As an EOE/AA employer, the American Medical Association will not discriminate in its employment practices due to an applicant's race, color, religion, sex, age, national origin, sexual orientation, gender identity and veteran or disability status.

THE AMA IS COMMITTED TO IMPROVING THE HEALTH OF THE NATION