Building digital businesses, together.
Data Architect
Location
California
Posted
11 hours ago
Salary
0
Seniority
Senior
Job Description
Data Architect
3Pillar Global
• 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
Job Requirements
- 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
- At 3Pillar, we offer a world of opportunity:
- Imagine a flexible work environment – whether it's the office, your home, or a blend of both. From interviews to onboarding, we embody a remote-first approach.
- You will be part of a global team, learning from top talent around the world and across cultures, speaking English everyday. Our global workforce enables our team to leverage global resources to accomplish our work in efficient and effective teams.
- We’re big on your well-being – 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 generous time off, we want all of our team members operating at their best.
- Our professional services model enables us to accelerate career growth and development opportunities - across projects, offerings, and industries.
- We are an equal opportunity employer. It goes without saying that we live by values like Intrinsic Dignity and Open Collaboration to create cutting-edge technology AND reinforce our commitment to diversity - globally and locally.
- Join us and be a part of a global tech community! 🌍💼 Check out our Linkedin site and Careers page to learn more about what it’s like to be part of our #oneteam!
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Data Engineer
CAMP Systems International, Inc.The world's leading Aircraft Maintenance Tracking Solutions provider.
• Design, develop, and maintain high-performance, scalable, high-volume, and efficient ETL/ELT pipelines to extract, transform, and load data from various sources such as Oracle. • Create and optimize data models and schemas to support various use cases (such as AI/ML solutions, benchmarking, customer data delivery) in Snowflake and Redshift. • Ensure data quality, integrity/completeness, and governance by implementing best practices for monitoring and validation. • Build automated monitoring and alerting mechanisms. • Collaborate with cross-functional teams to understand data requirements to support business objectives. • Stay up to date with emerging trends and technologies in data engineering.
![n Human Resources & Management Systems [ nHRMS ] logo](https://storage.googleapis.com/remote-rocket.appspot.com/n%20Human%20Resources%20%26%20Management%20Systems%20%5B%20nHRMS%20%5D.jpeg?GoogleAccessId=firebase-adminsdk-ptm37%40remote-rocket.iam.gserviceaccount.com&Expires=16447017600&Signature=gAXJ9oaC2K4TwXZmvUlILVAhLj4yugM6sM%2Br6EyOaZu1zWwg5iQ8nxQFuzxdbSiNvawTgyWoX9FaFhFj2DxksvRzFLzMei1CRoLhP2idwb0NG1vcgx8%2BDesyNAGqCZLnmGgfzbmJJ0y3%2FelbmlWfC6q8EN3AjPnVDjXui5%2FXgz%2FN5LsR3D2LCOYQlm2b98lKJtvENTBWBvom%2FNyzkTuO3g4c5DemOZaZn8WR0czmJolu6TYiOmIsjiWh%2BwxdjfPeKWdJE%2FH7RdO1iUBS%2Fex8owYwLEKAs29bsvCUNYVLmWYlXj7NwZK12nf6PFqMkRlE7lxddAOQwPT6GoUnMykhXg%3D%3D)
Principal Data Architect
n Human Resources & Management Systems [ nHRMS ]360 Degree HR Solutions in India & United States
• Define enterprise data architecture strategy and roadmap. • Design scalable cloud-native data platforms on GCP and Azure. • Develop conceptual, logical, and physical data models. • Drive Data Mesh, Data Fabric, governance, and analytics initiatives. • Mentor engineering and analytics teams. • Partner with stakeholders to translate business requirements into solutions. • Support AI/ML, advanced analytics, and modern data platform initiatives.
• Monitor and support the Production Data Warehouse environment • Troubleshoot and resolve issues related to ETL jobs, data loads, and performance bottlenecks • Coordinate with development, infrastructure, and business teams to ensure smooth operations and incident resolution • Perform root cause analysis for incidents and recurring issues and contribute to the continuous improvement of support and maintenance processes.
• Proactively monitor and support the Production Data Warehouse environment daily to guarantee seamless stability and uninterrupted operations. • Drive the successful execution and punctual completion of all End-of-Day (EOD) and End-of-Month (EOM) processes. • Expertly troubleshoot and resolve challenges related to ETL jobs, data loading, and performance issues to keep systems running optimally. • Collaborate closely with development, infrastructure, and business teams to ensure smooth workflows and swift incident resolutions. • Create and maintain comprehensive documentation, including operational procedures, runbooks, and support guides, to empower the team and streamline processes.
