Logo for PointAbout Inc.

Data Architect (EDW)

PointAbout Inc.

Role overview

Qualifications

  • 15+ years in data architecture or data engineering roles
  • Proven experience owning and delivering enterprise EDW/BI solutions end-to-end with full lifecycle accountability (design, build, deploy, optimize, adoption)
  • Expertise in cloud platforms (AWS preferred) with hands-on experience in AWS Glue and Amazon Redshift; strong SQL and dimensional modeling (star schema, fact/dimension design)
  • Experience building and optimizing ETL/ELT pipelines for large-scale, multi-source data environments; BI integration (Tableau) and prior leadership mentoring teams

Responsibilities

  • Architect end-to-end EDW and BI solutions, design scalable dimensional data models (star schemas, conformed dimensions), and ensure performance, scalability, and reliability; drive cloud deployment and production readiness
  • Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization; ensure solution outcomes and ongoing improvement
  • Translate business requirements into scalable data analytics solutions; design and oversee scalable data pipelines (ETL/ELT); implement data quality, validation, monitoring; integrate analytics data across high-volume, multi-source environments and BI platforms
  • Lead stakeholder engagement and governance: facilitate architecture/design sessions, act as trusted advisor bridging business strategy and technical delivery, mentor BI developers, data engineers, and analysts

Key facts

Hard skills

Data Warehouse Systems Dimensional Modeling SQL (Programming Language) Business Intelligence AWS Glue Amazon Redshift Hybrid Cloud Computing Amazon Web Services Microsoft Azure Data Modeling Data Transformation Data Cleansing Data Discovery Data Quality Data Validation Data Integration Relational Databases Software As A Service (SaaS) Flat File Database JSON Java XML Scalability Product Launch Readiness Data Governance Data Maintenance Data Security Data Visualization CloudBase Solution Architecture SQL Server Integration Services (SSIS) Datastax Informatica Tableau (Business Intelligence Software) Power BI Oracle Business Intelligence (BI) / OBIA Application Development .NET Development Python (Programming Language) Stakeholder Engagement Meeting Facilitation Continuous Improvement Process

Other skills

  • Reliability
  • Leadership
  • Mentorship
  • Accountability
  • Collaboration
  • Communication
  • Team Leadership

About the company

PointAbout Inc. logo

PointAbout Inc.

PointAbout is now 3Pillar Global. VIsit us at http://www.3pillarglobal.com. You can also follow us on http://www.linkedin.com/company/3pillar-global The company creates iPhone, iPad, Android, Blackberry, and Windows Phone 7 applications for brands as well as enterprise internal use. We've designed and developed native applications for clients like the Social Security Administration, US Army, The Outdoor Channel, PBS, Arinc, the Washington Post, Intelsat, Carfax, Huffington Post, OnStar, Cars.com, and many others. We provide mobile strategy planning, advisory, ideation, mobile product concepting, and feature/release planning for consumer and enterprise mobile.

Company details

Company size501 - 1000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Senior Data Archtect (EDW)

Accomplished Tech Visionary: 

Embark on an exciting journey with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure.

 

We are seeking a Senior Enterprise Data Warehouse (EDW) / Architect with a proven record of owning and delivering enterprise-scale data and analytics solutions on mixed prem and cloud environments.

This is a hands-on architecture and delivery role requiring deep expertise across data warehousing, and business intelligence domains with clear evidence of end-to-end ownership from design through production and adoption. The successful candidate for this role is someone who has prior proven experience delivering Enterprise Data Warehouse (EDW) and Business Intelligence (BI) solutions end-to-end and is accountable for performance, scalability, and business impact.

You will lead the design and delivery of scalable, high-performance analytics platforms, while partnering with senior stakeholders and leading delivery teams.

 


Responsibilities:

Architecture & Solution Design

  • Architect & Design end-to-end EDW and BI solutions

  • Design and implement scalable dimensional data models (star schemas, fact/dimension design, conformed dimensions)

    • End-to-End Delivery Ownership

  • Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization & support

  • Ensure performance, scalability, and reliability across EDW and BI platforms

  • Drive cloud deployment and production readiness of analytics solutions

  • Take accountability for solution outcomes, adoption, and continuous improvement

    •  

     

    Data Engineering & Integration

  • Translate business requirements into scalable data analytics solutions

  • Design and oversee scalable data pipelines (ETL/ELT) supporting enterprise analytics

  • Lead development of data transformation, cleansing, and enrichment processes

  • Implement data quality, validation, and monitoring frameworks

  • Integrate analytics data ingested across high-volume, multi-source environments (APIs, relational systems, SaaS, flat files, JSON/XML) and make it available for various data consumers 

  • Integrate and enhance large scale BI solutions both on prem and in the cloud

    •  

     

    Leadership & Stakeholder Engagement

  • Facilitate architecture and technical design sessions

  • Act as a trusted advisor bridging business strategy and technical delivery

  • Lead and mentor BI developers, data engineers, and analysts

    •  

     

    Governance & Best Practices

  • Establish and enforce data governance, data stewardship, security, and reporting standards

  • Define best practices across:

  • Data modeling

  • Data engineering pipelines

  • Visualization standards

  • Performance optimization

  • Deliver scalable, reusable, and enterprise-aligned solutions


    • Must Haves:

    Must-Have Requirements

  • 15+ years in data architecture, or data engineering roles

  • Proven experience owning and delivering enterprise EDW/BI solutions end-to-end

  • Demonstrated accountability for full lifecycle delivery (design, build, deploy, optimize, adoption)

  • Expertise in cloud platforms such as AWS GLue and Amazon Redshift 

  • Deep expertise in dimensional modeling (star schema, fact/dimension design)

  • Strong hands-on SQL and data modeling expertise using Microsoft SQL Server

  • Experience building and optimizing ETL/ELT pipelines and large-scale data platforms using current ETL tools

  • Proven Experience working with complex, high-volume, multi-source data environments

  • Prior experience implementing or integrating BI solutions ideally using Tableau

  • Experience deploying solutions in cloud environments (nice to have AWS, or Azure)

  • Proven leadership experience mentoring teams and engaging senior stakeholders


    • Nice to Haves:

    Nice To Have Requirements

  • Experience using SSIS, DataStage, Informatica, etc

  • Tableau or PowerBI experience 

  • Experience integrating Salesforce data into EDW/ BI ecosystems

  • Prior experience working in FinTech verticals

  • Prior experience building operational BI solutions

  • Prior application development experience ideally using either Java or .Net C#, Python


    • What is it like working for 3Pillar Global?
  • At 3Pillar Global, we are the power behind the brands you know. We are hiring new team members to assist us in continuing our growth trajectory as a fast growing global team of thousands of professionals. New Leaders will live our shared values of Intrinsic Dignity, Open Collaboration, Outsized Impact, and Continuous Improvement everyday to harness The Power of Team and deliver exceptional products and services for our clients. 
  • We support the comprehensive wellbeing of our team members, through:
  • Career growth and development
  • Physical and mental wellbeing: as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging unlimited PTO to take some needed time off, we want all of our team members operating at their best.
  • Living our value for Intrinsic Dignity as an equal opportunity employer and, 
  • Providing a comprehensive US benefits package that includes:
  • 100% 3Pillar funded medical and dental coverage for employees and their dependents
  • Unlimited PTO
  • Company paid disability and life insurance, and 
  • Generous Parental Leave
    •

    Apply once. Then go straight to the hiring manager.

    After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

    MR

    Marcus Rivera

    Chief Revenue Officer

    m.rivera@company.com
    linkedin.com/in/marcusrivera
    Unlocked after you apply
    ·

    Data Architect Related jobs

    CanadaData Architect

    Other jobs at PointAbout Inc.

    Premium

    Reach out to the hiring manager directly.

    Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

    • Full match report with fit score and gaps
    • Career diagnostics on how recruiters read you
    • Curated company matches and warm intros
    • 48h early access to new roles

    Cancel anytime.