Cloud Data Platform Administrator

Company Description

At Adtalem we are working together to positively impact the education and healthcare landscapes for the better. We do this by leveraging the collective strength of our institutions to address social disparities and cultivate an environment that supports the overall well-being and prosperity of communities and the world around us. We are bridging the gap between equitable access to high-quality education and systemic change in healthcare. Our talented team members are delivering on our promise to empower students to achieve their goals find success and make inspiring contributions to our global community.

Adtalem Global Education is a national leader in post-secondary education and leading provider of professional talent to the healthcare industry. Adtalem educates and empowers students with the knowledge and skills to become leaders in their communities and make a lasting impact on public health well-being and beyond. Through equitable access to education environments that nurture student success and a focus on expanding and diversifying the talent pipeline in healthcare Adtalem is building a brighter future for communities and the world. Adtalem is the parent organization of American University of the Caribbean School of Medicine Chamberlain University Ross University School of Medicine Ross University School of Veterinary Medicine and Walden University. Visit Adtalem.com for more information and follow on Twitter and LinkedIn. Adtalem believes in a culture of collaboration creativity and innovation which thrives when we can work flexibly. Depending on your location this role may be hybrid or remote.

• REMOTE – If you live over 50 miles from Adtalem offices in Chicago IL Addison IL Columbia MD Minneapolis MN and Miramar FL this role is remote. However occasional office visits may be required based on business needs with advance communication for such requests.

Job Description

Adtalem Global Education has embraced cloud technologies in the data warehouse domain for data storage pipelines modeling reporting and analytics. CDP administrator will play a crucial role in configuring maintaining upgrading & supporting the tools used in this domain of data warehouse and ensure availability of systems. This role requires pro-active skills and dynamic acumen in interacting with the data warehouse team including data engineers data analysts data architects BI reporting team and analytics team. CDP administrator will also interact with infrastructure team in planning & maintaining the cloud data warehouse systems and work with auditors to ensure industry compliance.

• Manage & configure the IICS (Informatica Intelligent cloud service) tool to ensure pipelines comply with the SLAs.

• Manage & configure the ingestion pipelines setup for various sources through Fivetran tool to ensure pipelines comply with the SLAs.

• Manage & configure Google Big Query Administration

• Manage projects datasets & tables.

• Answer audit questions and build/maintain automated process to help audit activities.

• Secure resources and ensure correct access to the users.

• Manage workloads (jobs queries & compute capacity).

• Monitor resources (quotas jobs & compute).

• Optimize workloads for best performance to control costs. Troubleshoot error messages and quotas to save costs.

• Proficiency in relational database & SQL to manage and support day to day operations.

• Manage Power BI administration for organization-wide settings in assigning roles and configuring monitoring & provisioning organizational resources. Knowledge on Azure cloud technology will help in managing the Power BI efficiently.

• Work involves promoting code for data pipelines model work reporting and analytics code. Azure Devops and Github repositories are used for code promotions. CDP admin should have the knowledge to add/modify the Devops process as needed complying to auditing requirements.

• Work with auditors in supporting user access reviews defining roles and accesses to data warehouse tools and in general develop industry standard compliance process to adhere to PCI SOX GDPR CCPA. Skills to automate audit activities is a must.

• Development skills in writing python google function and using other google technologies Unix shell scripting to automate and python coding skills to support ingestion and other application needs is preferred. Should have network knowledge to work with infrastructure network team to request firewall changes network devices & a good understanding of WAN operations to deal with cloud-based data sources.

• Should have good Unix knowledge to manage the IICS servers FTP servers and manage Batch operations. Scripting with Unix shell & python to support batch operations is preferred. Should have good windows skills to ensure software tools availability and serve the data engineers reporting and analytics team. Establishing best practices in monitoring maintaining supporting data pipelines data warehouse related servers data warehouse software/tools & cloud data warehouse infrastructure.

• Good knowledge on licensing of software used in Data Warehouse administration.

• Knowledge on paid media digital marketing and relating APIs for data ingestion pipelines will be a plus. Document the activities & process relating to CDP administration and architecture.

• Work with architects to maintain standards manage architectural issues and recommend alternatives to simplify the methods and process.

• Meet with subject matter experts in different areas of the business be able to learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business. processes. Performs other duties as assigned.

• Complies with all policies and standards.

Qualifications

• Bachelor’s degree in computer science Engineering or Information Systems.

• Five (5) plus years SQL experience with Relation database systems (RDBMS).

• Python code development using google function and Unix required and Unix shell scripting required.

• Proficiency in Data Warehouse concepts (e.g. Star Schema Data Model Data Lake Semantic Layer).

• Excellent listening verbal and written communication skills; ability to communicate effectively at all levels of the organization and vendors.

• Strong collaboration and interpersonal skills.

• Demonstrated ability to perform duties and responsibilities on time with moderate supervision.

• Good knowledge in administration of IICS (Informatica Intelligent Cloud Services) Fivetran & GCP.

• Ability to monitor and optimize BigQuery performance including query optimization and resource allocation.

• Strong knowledge of Google BigQuery including its architecture optimization and best practices.

• Understanding of cloud computing concepts and experience with cloud platforms especially Google Cloud Platform.

• Google Cloud certifications especially those related to data engineering and cloud architecture can be beneficial.

Additional Information

In support of the pay transparency laws enacted across the country the expected salary range for this position is between $82364.67 and $149076.17. Actual pay will be adjusted based on job-related factors permitted by law such as experience and training; geographic location; licensure and certifications; market factors; departmental budgets; and responsibility. Our Talent Acquisition Team will be happy to answer any questions you may have and we look forward to learning more about your salary requirements. The position qualifies for the below benefits. Adtalem offers a robust suite of benefits including:

• Health dental vision life and disability insurance

• 401k Retirement Program + 6% employer match

• Participation in Adtalem’s Flexible Time Off (FTO) Policy

• 12 Paid Holidays For more information related to our benefits please visit: https://careers.adtalem.com/benefits. You are also eligible to participate in an annual incentive program subject to the rules governing the program whereby an award if any depends on various factors including without limitation individual and organizational performance.

Equal Opportunity – Minority / Female / Disability / V / Gender Identity / Sexual Orientation