Data Architect

3Pillar Global

Data Architect at 3Pillar defining data structures and supporting clients with analytics solutions. Collaborating closely with stakeholders to enhance data management and business intelligence efforts.

Posted 5/25/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAWSAzureDynamoDBETLGoogle Cloud PlatformHadoopHDFSJavaKafkaLinuxNoSQLPySparkPythonScalaSparkSQLTableau

About the role

Key responsibilities & impact

Translate business requirements into data requests, reports and dashboards.
Strong Database & modeling concepts with exposure to SQL & NoSQL Databases
Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures
Expertise in designing and writing ETL processes in Python / Java / Scala
Understanding of Hadoop framework - Exposure to PySpark, Spark, Storm, HDFS, Hive
Strong hands-on experience with either Databricks or Snowflake; experience with both is desirable.
Knowledge of Master Data management and related tools
Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices
Skilled in ensuring data accuracy, consistency, and quality
Experience with the AWS/Azure/GCP data engineering services
Knowledge of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lakeformation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch
And / OR
Knowledge of Azure services viz., ADF, Data Catalog, Databricks, Azure Synapse Analytics, ADLS Gen2, Azure Devops
Ability to implement data validation processes and establish data quality standards.
Experience in Linux
Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights

Requirements

What you’ll need

Assessments of existing data components, Performing POCs, Consulting to the stakeholders
Proposing end to end solutions to an enterprise's data specific business problems, and taking care of data collection, extraction, integration, cleansing, enriching and data visualization
Ability to design large data platforms to enable Data Engineers, Analysts & scientistsStrong exposure to different Data architectures, data lake & data warehouse
Define tools & technologies to develop automated data pipelines, write ETL processes, develop dashboard & report and create insights
Continually reassess current state for alignment with architecture goals, best practices and business needsDB modeling, deciding best data storage, creating data flow diagrams, maintaining related documentation
Taking care of performance, reliability, reusability, resilience, scalability, security, privacy & data governance while designing a data architecture
Apply or recommend best practices in architecture, coding, API integration, CI/CD pipelines
Coordinate with data scientists, analysts, and other stakeholders for data-related needs
Help the Practice grow by mentoring junior Practice members, leading initiatives, leading Data OfferingsProvide thought leadership by representing the Practice / Organization on internal / external platforms

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLNoSQLETLPythonJavaScalaHadoopPySparkSparkLinux

Soft Skills

consultingmentoringleadershipcommunicationproblem-solvingcollaborationdata governancedata qualitystakeholder engagementthought leadership