Data Architect at iPipeline

Posted in Information Technology 16 days ago.

Type: Full-Time
Location: Exton, Pennsylvania





Job Description:

Responsibilities:



  • Migrate data and tools (modernize) from on premise to Cloud technologies

  • Design and create data models that facilitate near real-time analytics data

  • Design, develop, automate, monitor, and maintain ELT/ETL applications using preferred tools and techniques on Snowflake and AWS

  • Design, develop, and support internal tooling related to datalake deployment and management

  • Tune recurring SQL code on Snowflake for optimal performance and cost

  • Work with our analytics team to provide backend support for our data offerings

  • Enable data observability and resource governance in Snowflake


 


Required Qualifications:



  • Experience with AWS technologies

  • Data warehouse experience, preferably in Snowflake

  • Experience with data delivery and datalake ideology

  • Understanding of data warehouse and master data management approaches, ELT industry standards, and general data development best practices

  • Experience building Star Schema models

  • Possess strong communication skills and the ability to work with technical and business teams


 


Desired Qualifications:



  • Experience with Streamlit app development

  • Cross-disciplinary experience with coding languages and data (example: combined SQL + Python + JS or functional programming with data and set awareness)

  • Experience with Infrastructure as Code (IaC) methodology and tools such as Terraform or Chef

  • Experience with BI reporting tools such as Power BI, Tableau, QLIK, or Sigma

  • Experience as Snowflake/cloud warehouse admin desirable


 

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

System Eng





More jobs in Exton, Pennsylvania


Uber Freight

American Cybersystems, Inc.

iPipeline
More jobs in Information Technology


AT&T

AT&T

AT&T