Data Warehouse Architect

Published date Posted on Indeed on Nov 20, 2021 (8 d ago)

Data Warehouse Architect

Company Introduction

Our mission is the enablement of every organization and person with the technology to positively impact the health of planet Earth. Persefoni is creating an all-in-one platform that allows organizations to measure, analyze, and reduce their Enterprise Carbon Footprint. Our goal is to provide our customers unprecedented visibility and insights into the impact their organization has on the environment. Leveraging the latest breakthroughs in data science and software, our technology will empower teams and leaders to mobilize their organizations to continuously improve their greenhouse gas emissions metrics.

Our Core Values

Sustainability - We are committed to sustainable business practices across our entire operation and culture. We go beyond achieving balance. We are a net-positive contributor to the environment, our employee’s lives, and the global community.

Impact - We are focused on and passionate about tackling the biggest and hardest problems that will have the greatest impact. We create significant, not incremental, solutions.

Collaboration - We are always aligned in our goals and efforts to create the most impactful technologies possible. Constant cooperation across our company, customers, and partners is our standard mode of operating.

Equality - We value and respect people and organizations of all backgrounds. Ours is a culture of innovation, creativity, diversity of thought, and inclusion.

About the Role

As the Data Warehouse Architect, you will be a key member of the Information Technology department and manager of Persefoni’s back office information architecture. Working closely with our Business Intelligence team, you will have primary responsibility for the replication and transformation of source system data into consumable models. Additionally, you will be responsible for managing and maintaining the logical and physical structure of the warehouse database as well as ensuring that the source data is appropriately classified and that the appropriate security models are in place.

How You’ll Know You’re on the Right Track

  • Within your first two weeks, you will have an initial understanding of Persefoni’s key source systems and our current replication and transformation patterns using Fivetran and DBT. You will also have assessed the current state of our data warehouse’s physical and logical design.
  • Within your first four weeks, you will have an understanding of the current high priority BI requirements in our pipeline and will have begun the process of delivering reusable models ready for visualization in Tableau.
  • Within your first two months, you will have begun working with our BI Developers to publish single-source-of-truth self-service models for our Tableau Explorers to begin using.
  • Within your first three months, you will be establishing and communicating target states for our information architecture and will begin managing toward milestones to achieve those objectives.

Responsibilities

  • Work within an agile team of scrum master, system administrators, and Business Intelligence developers to source and transform data based on provided requirements.
  • Build and manage Fivetran data pipelines from existing and new source systems.
  • Classify data using a data classification framework to ensure that the information is appropriately secured
  • Build and manage data transformation workloads (DBT) that create ready-to-use data models for visualization.
  • Provide transformation lineage diagrams visualizing the transformation of source to target data.
  • Develop and maintain data architecture and relevant visualizations
  • Continue building trust in Persefoni’s data catalog used for enterprise-wide analytics.
  • Assist with incident management related to corporate reporting.
  • Design the logical and physical structures of the warehouse database, and administer access accordingly.
  • Assist with other enterprise-wide projects as needed and appropriate.

Skills and Qualifications

  • Six or more years experience in data warehousing
  • Extensive experience with best practices and preferred patterns for data replication, transformation, and logical and physical modeling.
  • Experience as a technical leader with the ability to assess and communicate current, target, and incremental states of the data architecture
  • Excellent oral, written, and presentation skills, with extensive experience working with senior business and technical leaders, up to and including C-Suite executives. Comfort speaking to large audience.
  • Strong interpersonal skills and the ability to champion ideas.
  • Familiarity with agile delivery frameworks
  • Experience managing roles, users, schemas and permissions within a Postgres database
  • Extensive experience writing SQL
  • Experience in DBT, Fivetran, and Tableau preferred

Job Type

Full-time. Remote. Salary based on experience and location.

Benefits

  • Generous PTO policy
  • 401K with company match
  • Health, Dental, & Vision Insurance
  • Disability, Life Insurance
  • Equity Incentive Plan

Interview Process

  • Step 1: Initial candidate screening call
  • Step 2: Interview with member(s) of our Information Technology team
  • Step 3: Interview with our Director of Business Platforms, Architecture & Analytics
  • Step 4: Offer extended
  • Step 5: Background check and on-boarding

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Jobvite Jobvite |
|
2 d ago

#Description#Jobvite is an end-to-end Talent Acquisition Suite that takes a marketing-first approach to intelligently attract dream candidates, automatically screen for the highest quality, engage employees invested in the future, and retain the people who care the most about you

Piper Companies Piper Companies |
|
5 d ago

Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b

Alvaria employs a team of passionate individuals who are changing the face of customer engagement. Over our 40-year history we have empowered employees by creating an inspired community that values Urgency, Accountability & Results. Our ability to think big has enabled us to

Remote Opportunity Main responsibilities:Create visualizations and analyses that provide business insights for our global customers.Build prototypes for demonstration and illustration purposes for peer groups, Business partners, or senior leaders.Expertise in SQL can independentl

Description:Le’fant is a rapidly growing CVE Certified, Service Disabled Veteran Owned Small Business specializing in management consulting for the federal government. Our compensation and benefits plans are designed to attract and retain the industries best talent to provi

The connection has a fantastic opportunity through our Technical Staffing division for a Senior Informatics BA. This is a permanent position with our end client.This is a remote position.Responsibilities:Prepare business requirements document by performing various analyses and in

Location:North America›RemoteJob Type:Full-timeFunctional Area:SalesJob Level:Mid-Senior LevelBecome a Principal Business Analyst in an Innovative High-Tech Security CompanyJob ID: HID2033Location: Remote, USTravel: Up to 20%#Securing your Future!Business analysts (BAs) ar

IQVIA IQVIA |
2 d ago

The IQVIA Data Management and Analysis team (DMA) is part of the market-leading Contract Performance Solutions group which helps manufacturers with all aspects of government and commercial drug rebate programs. We create value for our clients by analyzing and validating pharmaceu

More jobs by this company

Persefoni AI Persefoni AI |
4 d ago

Company IntroductionOur mission is the enablement of every organization and person with the technology to positively impact the health of planet Earth. Persefoni is creating an all-in-one platform that allows organizations to measure, analyze, and reduce their Enterprise Carbon F

Persefoni AI Persefoni AI |
4 d ago

Company IntroductionOur mission is the enablement of every organization and person with the technology to positively impact the health of planet Earth. Persefoni is creating an all-in-one platform that allows organizations to measure, analyze, and reduce their Enterprise Carbon F