Cloud Data Platform Adminstrator

3 weeks ago

Chicago, United States Burtch Works Full time

Position Overview


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.


Essential Functions

  • 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.


Skills & Competencies

  • 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.

  • Cloud Data Platform Adminstrator

    4 weeks ago

    Chicago, United States Burtch Works Full time

    Position OverviewCDP 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...

  • Google Cloud Platform Data Engineer

    3 weeks ago

    Chicago, United States Publicis Sapient Full time

    Job Description This position requires in-depth knowledge and expertise in GCP services, architecture, and best practices. Will work closely with clients to understand their business objectives and develop strategies to leverage GCP to meet their needs. They will collaborate with cross-functional teams to design, implement, and manage scalable and...

  • Sr. Data Engineer

    1 week ago

    Chicago, United States PeopleCaddie Full time

    Job Description: SR. Data Platform EngineerDuration: 6 months contract (potential extension)Location: Chicago, ILPURPOSE: Client seeks an experienced Data Platform Engineer who will be an exceptional addition to our growing Data Platform Architecture team. He will work closely with data engineering, data product managers and data science teams to meet data...

  • Cloud Data Engineer

    4 weeks ago

    Chicago, Illinois, United States BBI Full time

    BBI is a multi-national IT consulting services provider in the new generation digital technology ecosystem.We are driven by our artistic approach to engineering, crafting solutions that ignite change and yield tangible results.The IT Cloud Engineer will be responsible for designing, implementing, and managing our client's business-critical infrastructure...

  • Junior Cloud Platform Engineer

    4 days ago

    Chicago, United States Patterned Learning AI Full time

    Job Description Junior Cloud Platform Engineer - Remote Job, 1+ Year Experience Annual Income: $60K - $65K, Onsite A valid work permit is necessary in the US/Canada About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the...

  • Junior Cloud Platform Engineer

    2 days ago

    Chicago, United States Patterned Learning AI Full time

    Job Description Junior Cloud Platform Engineer - Remote Job, 1+ Year Experience Annual Income: $60K - $65K, Onsite A valid work permit is necessary in the US/Canada About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the...

  • Cloud Data Architect

    7 days ago

    Chicago, United States Laiba Technologies Full time

    **Position: Cloud Data Architect** **Location: Chicago, IL** - 15+ years of experience - Certifications ( AWS / Snowflake / Datawarehouse) - Datawarehouse Architecture / Concepts - Data Modelling Concepts & Architecture - Data Structure & Architecture - DB Experience - Snowflake Concepts - AWS Data Lake - ETL/Informatica/ Datastage - AWS Services/...

  • Platform Architect

    4 days ago

    chicago, United States United Airlines Full time

    There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...

  • Senior Software Engineer

    2 days ago

    Chicago, United States Balyasny Asset Management Full time

    ROLE OVERVIEW The Senior Software Engineer will be a key member of a small, focused product team working to create the core data platform that BAM’s data analysts, data scientists, quantitative investors, and researchers can rely on for sourcing investment data sets. The platform’s cloud-native ecosystem includes Dockerized ingestion pipelines running in...

  • Product Manager, Cloud Application Security

    3 weeks ago

    Chicago, United States Data Theorem Full time

    Job DescriptionJob DescriptionYour CareerData Theorem focuses on preventing application security (AppSec) data breaches. The main areas of security specialty include: API, Cloud, Mobile, Web, and Software Supply Chain. We are searching for exceptional talent pursuing an opportunity to grow and take ownership of the projects that resonate most with them.As a...

  • Data Input Specialist

    5 days ago

    Chicago, United States V Cloud Choice Full time

    **About Vcloud Choice** Vcloud Choice is a leading provider of cloud-based solutions for businesses worldwide. Our cutting-edge technologies empower organizations to optimize their operations, enhance productivity, and achieve their strategic objectives. As we continue to expand our services, we are seeking a dedicated Customer Support Specialist to join our...

  • Senior Architect, Data

    7 days ago

    chicago, United States United Airlines Full time

    There’s never been a more exciting time to join United Airlines. We’re on a path towards becoming the best airline in the history of aviation. And we’re growing – in the years ahead, we’ll hire tens of thousands of people across every area of the airline. Our careers include a competitive benefits package aimed at keeping you happy, healthy and...

  • Senior Platform Engineer

    3 weeks ago

    Chicago, United States CME Group Full time

    Description Platform Engineering Job Description The Platform Engineering team is a collection of highly skilled individuals ranging from development to operations with a security first mindset who strive to push the boundaries of technology. We champion a DevSecOps culture and raise the bar on how and when we deploy applications to production. Our core...

  • Entry Level Business Analyst

    3 days ago

    Chicago, United States Data Cloud Merge Full time

    Company DescriptionData Cloud Merge is a communications Company that was established in the year 2002 and located in Jersey City, New Jersey. It has gained a lot of experience in providing innovations in IT that were formerly found in large companies alone. The Company provides dedicated IT innovations at friendly prices unlike other companies that operate...

  • Technology Architect

    2 days ago

    Chicago, IL, United States Ascendion Inc. Full time

    Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. We have a culture...

  • Cloud Data Architect

    1 week ago

    Chicago, United States Tekfortune Inc Full time

    Role: Cloud Data Architect Job Location: Chicago, IL Mandatory required skills Strong Data Background Job Description ¿ Responsible for ensuring that the data management and governance frameworks are in place and adhered to ¿ Responsible for Architecting, designing and building out the AWS services ¿ Responsible for guiding and resolving issues with AWS...

  • Cloud Data Engineer

    3 days ago

    Chicago, United States Saxon Global Full time

    Job Description: You have the opportunity to join a small team focused on the firm's strategic investments in our Cloud Data Operations space. You are a passionate visionary and technologist with a focus on data operations, cloud solutions, and implementations. In your role, you will be given great latitude to flex your skillset while benefiting from the...

  • Salesforce Platform Manager

    4 weeks ago

    Chicago, United States Rush Street Interactive Full time

    As a Salesforce Platform Manager, you will own the integrity and strength of the Salesforce platform and other solutions as required. You'll act as a trusted advisor to our team and clients, and an effective mentor for other professionals working alongside you. You will have a deep understanding of the Salesforce platform but just as importantly, top-notch...

  • Snowflake Cloud Administrator

    2 days ago

    Chicago, United States Ansys Full time

    **Requisition #**: 14292 **Our Mission: Powering Innovation That Drives Human Advancement**: When visionary companies need to know how their world-changing ideas will perform, they close the gap between design and reality with Ansys simulation. For more than 50 years, Ansys software has enabled innovators across industries to push boundaries by using the...

  • Sr Platform Engineer

    4 weeks ago

    Chicago, IL, United States CME Group Full time

    Description Platform Engineering Job Description The Platform Engineering team is a collection of highly skilled individuals ranging from development to operations with a security first mindset who strive to push the boundaries of technology. We champion a DevSecOps culture and raise the bar on how and when we deploy applications to production. Our core...