Data Architect
Ness Digital Engineering
full-time
Posted on:
Location Type: Hybrid
Location: Boston • Massachusetts • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
CloudETLPythonSQL
About the role
- Design and implement scalable, efficient Snowflake data models to support HR analytics, workforce planning, and KPI reporting.
- Develop and optimize integrations between Workday, Snowflake, and downstream analytics platforms; ensure seamless, accurate data flow across systems.
- Define and enforce data governance, quality, and metadata management standards to ensure data consistency and compliance.
- Maintain comprehensive technical documentation and data dictionaries for warehouse structures, transformations, and integrations.
- Monitor and tune ETL/ELT pipelines, ensuring high-performance data transformation and loading processes.
- Partner with HR, Data Engineering, and Analytics teams to translate business logic into reusable and governed data assets.
- Participate in unit, integration, and regression testing to validate data pipelines and ensure data accuracy.
- Support data analysis and troubleshooting across the full implementation and operational lifecycle of HR data solutions.
Requirements
- Proven experience architecting and implementing solutions on Snowflake or similar cloud data warehouse platforms.
- Advanced SQL skills and hands-on experience with data transformation and pipeline optimization tools.
- Strong understanding of ETL/ELT frameworks, data validation, and reconciliation techniques.
- Demonstrated experience working with HR data structures, Workday, or other HRIS systems.
- Strong analytical mindset and problem-solving ability, with attention to data integrity and business context.
- Experience with Python for data engineering, automation, or orchestration tasks.
- Track record of designing data warehouses or analytical platforms leveraging HR data to drive insights and advanced reporting.
Benefits
- Hybrid work arrangement (4 days from office)
- Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SnowflakeSQLETLELTdata transformationdata pipeline optimizationPythondata governancemetadata managementdata validation
Soft skills
analytical mindsetproblem-solvingattention to data integritybusiness context