Job Description

Junior Architect

Contract-to-Hire

Hybrid-Philadelphia, PA

Job Summary

Our client is seeking a detail-oriented and motivated Junior Architect to join their Solutions Architecture team. In this role, you will support the design and delivery of enterprise-level data solutions that manage structured and unstructured data, enabling scalable processes and strong business intelligence capabilities.

This position is highly collaborative and focuses on solution design reviews, documentation, data modeling, and adherence to data architecture best practices within an on‑prem SQL Server environment. You will work closely with senior architects, data engineers, analysts, and cross‑functional teams to align on standards, evaluate tools, and support the creation of efficient, reliable, and well‑documented data solutions.

The ideal candidate is eager to learn, technically curious, and capable of balancing multiple priorities in a fast-paced environment while maintaining clear communication and strong process discipline.

Core Responsibilities

• Assist in designing and documenting data structures, pipelines, and architectural components aligned with business and technical standards.
• Support data quality efforts during ingestion, processing, and final load to target systems.
• Help build and enhance ingestion frameworks for structured and unstructured data, including quality checks and reporting.
• Contribute to standard data consumption methods such as database views, extracts, and APIs.
• Assist in the development and maintenance of data systems such as data warehouses and data lakes.
• Support solution design across on‑prem platforms (e.g., Kubernetes, Teradata) and cloud platforms (e.g., Databricks, AWS S3, Redshift).
• Help determine appropriate storage platforms based on privacy, access, and sensitivity needs.
• Document data lineage, transformation logic, and architectural decisions to support troubleshooting and impact analysis.
• Collaborate with platform and technology teams to optimize data sourcing, processing, and architectural consistency.
• Assist with data migrations and conversions as platforms evolve.
• Identify and escalate technical issues using established policies and processes.
• Apply data sensitivity, privacy rules, and compliance requirements throughout the data lifecycle.
• Monitor system logs and notifications to support database and application quality.
• Support problem-solving using reusable logic, data files, or standardized patterns.
• Provide insights and trends related to specific data sources when needed.
• Maintain regular, consistent, and punctual attendance; flexibility for occasional night/weekend work.
• Perform other duties as assigned.

Additional Responsibilities

• Support solutions architecture work with emphasis on front-end solution components.
• Assist with backend design tasks on small-to-medium initiatives and serve as backup to lead architects as needed.
• Participate in evaluating tools and technologies using standard comparison frameworks.
• Support proof‑of‑concept initiatives and long-term architecture planning.
• Contribute to ongoing data management initiatives.

Technical Skills

• Proficiency with SQL, data warehousing concepts, and data modeling best practices.
• Exposure to Python, PowerShell, and cloud technologies.
• Familiarity with enterprise reporting tools (e.g., OBI, Crystal Reports).
• Experience with visualization tools such as Tableau, Power BI, or Qlik, including data storytelling.
• Strong skills with Office 365 or similar productivity suites.
• Experience using JIRA and Confluence.
• Strong documentation skills, including process flows and ERDs.

Preferred Experience

• Exposure to systems thinking and systems analysis.
• Familiarity with Lean and Agile methodologies.
• Understanding of SDLC frameworks.

Soft Skills

• Strong collaboration and communication abilities.
• Ability to think strategically and understand broader architectural impacts.
• Proactive, transparent communication style with strong attention to detail.

Job Tags

Similar Jobs