Data Architect
Pivotal SolutionsLocation not specified
Posted November 13, 2025
Full Time
About the Company
Pivotal Solutions is a national staffing and consulting firm founded in 2002, specializing in IT & technology, accounting & finance, and now expanding into engineering & construction, supply chain, HR, sales, digital, and life sciences. With a dedicated team of 50 recruiters, the company has filled over 10,000 roles for more than 2,000 clients ranging from startups to Fortune 500 firms across diverse sectors. Pivotal offers a full spectrum of staffing models—including direct hire, contract-to-hire, short‑ and long‑term contracts, and statement‑of‑work placements—tailored to each client’s unique talent needs. Their blend of industry expertise, personalized service, and proven track record positions them as a trusted partner for organizations seeking top talent and strategic workforce solutions.
Job Description
Strong verbal/written communication & facilitation skills. Ability to take a requirement document, work through any ambiguity and follow through to implementation independently. Solid understanding of SQL, Cloud Infrastructure, and data pipeline design.
Requirements
- Strong analytical and problem-solving abilities
- Strong work ethic, sense of ownership and a team player
- Ability to analyze the data to identify the necessary pre-processing steps for the automated ETL processes
- Delivering the data pipeline with Quality and automated testing
- Experience in Cloud Infrastructure (AWS, Azure, GCP)
- Experience building data pipelines in AWS using AWS Glue, Redshift, S3 buckets and other relevant technologies
- Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW
- Proven work experience as an ETL developer
- Experience using Source Code and Version Control systems like Git etc.
- Strong project management skills
- Ability to analyze a company’s big-picture data needs
- Clear communication skills
- Ability to troubleshoot and solve complex technical problems
