Senior Data Architect / Data Engineer
New
J
Jahnel GroupSoftware Development
Schenectady, New York, United States, Remote, 9:00 AM to 5:00 PM ESTFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8+ years
- Required Skills
- SQLGCPGitData engineeringData modeling
Requirements
- 8+ years of experience in data engineering, data architecture, or a closely related field.
- Strong experience designing data architecture and data models for complex enterprise environments.
- Proven experience working with legacy systems and large-scale data transformation or migration efforts.
- Strong understanding of relational data modeling, data structures, schemas, mappings, and normalization.
- Demonstrated ability to determine when a canonical data model is appropriate and when a more flexible approach is needed.
- Strong SQL skills and the ability to quickly write scripts for data transformation and migration.
- Experience with Google Cloud Platform (GCP) and cloud-based data environments.
- Comfortable working hands-on while also making high-level architectural decisions.
- Strong problem-solving skills and the ability to bring structure to ambiguous or messy data environments.
- Experience mentoring or advising other data engineers and helping less experienced team members grow.
- Experience with Git-based development workflows; GitLab experience is a plus.
- Excellent communication skills and the ability to explain complex technical concepts to both technical and non-technical stakeholders.
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field is preferred.
Responsibilities
- Design and guide data architecture for a complex transformation and migration initiative spanning approximately 11 legacy systems.
- Analyze highly varied source data, potentially including roughly 400 form variants and source structures.
- Develop unified or semi-unified data models that balance consistency, flexibility, and long-term maintainability.
- Make thoughtful architectural decisions around canonical data models, mappings, transformations, and source-specific variations.
- Write and ship scripts quickly to support data migration, transformation, validation, and cleanup.
- Identify data quality issues, inconsistencies, and structural gaps across legacy systems and develop practical solutions.
- Collaborate with technical and business stakeholders to understand existing data structures and future-state requirements.
- Provide technical guidance and mentorship to junior and mid-level data team members.
- Help establish patterns and best practices that reduce rework and support future data initiatives.
View Full Description & ApplyYou'll be redirected to the employer's site