The IT Data Analyst supports Development Operations of the Amneal Intelligence Platform (AIP) in the Amazon cloud (web services). Position requires strong analytical skills and an ability to work with large amounts of data, extract relevant information, and draw logical conclusions.
Essential Functions:
1) Monitor interfaces to extract data from Amneal business systems and supply them to AIP and Gross-to-Net System 2) Monitor Glue ETL jobs transforming extracted data into Parquet format for AIP's raw, curated, and published data zones 3) Transform data from raw to curated and published zones to enable self-service data analytics and visualization tools, e.g., Tableau, SAS, Power BI, Alteryx, Trifacta 4) Monitor Glue ETL jobs transforming extracted data from Parquet into JSON format for upload into Reltio master data management system 5) Monitor Ataccama Data Quality Engine to be run bi-weekly or monthly, as needed 6) Configure Data Quality dashboard in AWS using knowledge of Linux, Python, JavaScript/JSON 7) Add / Remove / Change data attributes to an existing data set that feeds the Data Quality Engine 8) Add / Remove / Change Data Quality rules using Ataccama, SQL, and Python 9) Remediate/correct exceptions generated by Gross-to-Net system data loader process 10) Collaborate with off-shore master data management stewards to create/maintain master data in source systems 11) Administer the Reltio Master Data Management system in Amazon Web Services 12) Administer the Boomi Integrate and Flow platforms to process master data additions and updates
1) Maintain business data glossary and configuration of electronic data catalog, e.g., Collibra / Alation 2) Help evolve the Amneal Intelligence Platform to support Machine Learning and Artificial Intelligence applications
Additional Responsibilities:Education:
Bachelors Degree (BA/BS) Technical field - Required
Master Degree (MBA) Business Analytics - Preferred
Experience:
1 year or more in Business Analytics
1 year or more in Programming experience with MySQL, MS SQL Server, MogoDB, Python, R, Tableau and MS Power BI
Skills:
o Databases and languages: MySQL, Microsoft SQL Server, Python, R - Intermediate
o Business Intelligence / Visualization tools: Tableau, Power BI - Intermediate
o Ability to perform data extractions and transformations using joins, nested joins, and complex SQL queries - Intermediate
• Learning agility and business-technology communications: o Ability to learn new technologies quickly o Ability to work with offshore development and support teams o Excellent business acumen and communication skills - Intermediate