Post Job Free
Sign in

Data Architect

Company:
iPipeline
Location:
Exton, PA, 19341
Posted:
May 16, 2024
Apply

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)

Apply