Azure Data Architect

Company Overview

PCS Retirement, LLC, a subsidiary of FSG Parent L.P., is one of the nation's largest independent and conflict-free retirement solution providers in the industry. PCS provides recordkeeping services to 19,000 plans and 850,000 eligible participants representing more than $26 billion in assets under administration. PCS' comprehensive retirement solutions platform includes business development tools for financial advisors, a data-driven recordkeeping technology that supports all types of retirement plans [401(k), 403(b), 457, Cash Balance, Defined Benefit, Non-Qualified], individual retirement accounts (including payroll deduction IRAs), and health savings accounts. 

At PCS Retirement, we cultivate an environment built on trust, where every team member is empowered to take ownership and contribute to our shared vision. Through collaborative teamwork we foster growth, both personally and professionally, ensuring that together we exceed expectations and achieve remarkable success.  

To learn more, visit https://www.pcsretirement.com/

Job Summary

We are seeking an experienced Azure Data Architect with a strong background in designing and implementing enterprise-scale Data Lakehouse architectures. The ideal candidate will have 8+ years of experience in data engineering and architecture, with expertise in Azure Data Factory, Azure Databricks, Delta Tables, Unity Catalogs, GitHub, and GitHub Workflows. The candidate will play a key role in building scalable, secure, and optimized data solutions to enable data-driven decision-making across the organization. 

Job Responsibilities

• Architect and Design Solutions: Lead the design and implementation of Data Lakehouse architectures using Azure technologies such as Data Factory, Databricks, Delta Tables, and Unity Catalog.
• Data Integration: Develop and implement pipelines to ingest, transform, and integrate data from various sources using Azure Data Factory and Databricks.
• Data Governance and Security: Establish and enforce best practices for data governance, security, and compliance using tools like Unity Catalog and Azure RBAC.
• Collaboration and Version Control: Leverage GitHub and GitHub Workflows to manage version control, CI/CD pipelines, and collaboration across teams.
• Performance Optimization: Optimize the performance of data pipelines and storage for scalability and efficiency, ensuring minimal downtime and high availability.
• Stakeholder Engagement: Work closely with business stakeholders to gather requirements and translate them into technical solutions aligned with business objectives.
• Documentation and Training: Prepare architectural documentation and conduct knowledge-sharing sessions to upskill team members.
• Emerging Trends: Stay updated on emerging trends in data architecture, Azure technologies, and industry best practices. 

• 8+ years in data engineering/architecture with a focus on Data Lakehouse design and implementation.
• Proven expertise in Azure Data Factory, Databricks, Delta Tables, Unity Catalog, and GitHub.

Technical Skills:

• Strong programming and scripting skills (e.g., Python, SQL, PySpark)
• Experience with CI/CD pipelines, version control, and workflow automation using GitHub Workflows.
• Solid understanding of data governance, security, and compliance practices.
• Azure Certification: Azure certification (e.g., Azure Solutions Architect, Azure Data Engineer Associate) is desirable but not mandatory.

Soft Skills:

• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities to work effectively with cross-functional teams.

Preferred Skills:

• Familiarity with Power BI or other visualization tools.
• Knowledge of machine learning and advanced analytics pipelines.
• Experience with multi-cloud or hybrid cloud environments.

Remote Work Information

For all virtual remote positions, in order to ensure employees can effectively perform their job duties with no distractions, we require an uninterrupted virtual work space and there is also an expectation of family care being in place during business hours. Additionally, there is an internet work speed requirement of 50 MBps or better for individual use. If more than one person is utilizing the same internet connection in the same household or building, then a stronger connection is required. If you are unsure of your internet speed, please check with your service provider. Please ensure that you are able to meet these expectations before applying.

Compensation Information

The average salary for this position is expected to be between $90,000 and $140,000/year however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. We do not anticipate candidates to be paid at the top of the range however, from time to time, it may occur on a case-by-case basis. Other rewards and benefits may include: 401(k) match, medical, dental, vision, life insurance, short and long term disability, paid-time off, etc. For more information, please visit pcsretirement.com/careers

Additional Information

As an employer, PCS believes our success depends on diversity, inclusion, and mutual respect among our team members. We want to look like our customers, and we recruit, develop, and retain the most hardworking people from a diverse candidate pool. We are committed to making all employment decisions based on business need, merit, capability, and equality of opportunity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state, or local protected class.