Data Architect

Data Architect

Job Description
PRISM is seeking a strategic and technically adept Data Architect to drive enterprise analytics initiatives using the Microsoft data ecosystem. This role blends hands-on data science with leadership responsibilities, guiding a team in delivering scalable, secure, and actionable insights through tools like SQL Server, SSIS, Power BI, and Active Directory. The successful candidate will develop and support SSIS/ETL jobs and SQL Server databases to meet organizational objectives and goals. This position is Hybrid with 3 days onsite per week at the customer site in the DMV area.

Key Responsibilities:

• Lead the design and deployment of predictive models and machine learning algorithms.
• Architect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalability.
• Develop and oversee Power BI dashboards, ensuring alignment with business KPIs.
• Manage secure data access and compliance using Active Directory roles and policies.
• Mentor junior data scientists and analysts, fostering a culture of innovation and excellence.
• Collaborate with cross-functional teams to translate business needs into data-driven strategies.
• Establish best practices for data governance, quality assurance, and model lifecycle management.
• Communicate insights through compelling visualizations and executive-ready storytelling.

Qualifications
Required Skills & Qualifications:

• Must have a Bachelor's degree and 5+ years of experience in data science, analytics, or business intelligence.
• Prefer technical lead or team lead experience.
• Deep expertise in SQL Server, SSIS, and Power BI.
• Strong understanding of Active Directory for role-based access control.
• Ability to architect end-to-end data solutions and guide technical direction for complex data schemas.
• Experience with Azure Data Factory and Microsoft Fabric for cloud-based data orchestration.
• Excellent communication skills for stakeholder engagement and executive presentations.
• Bachelor's or Master's degree in Data Science, Computer Science, or a related field.

Nice to Have:

• Familiarity with Azure Synapse, Databricks, or Delta Lake.
• Microsoft certifications (e.g., Azure Data Scientist Associate, Power BI).
• Exposure to CI/CD pipelines and DevOps practices for data workflows.
• Proficiency in Python for statistical modeling and machine learning.

ABOUT PRISM
PRISM is devoted to modernization and innovation within the world of technology, security, and IT enterprise solutions. We are recognized for meeting performance requirements and exceeding customer expectations since 1994. Our culture is founded on relationships, opportunity, and success. Offering comprehensive benefit plans including medical, dental, vision and 401K along with our people - first approach sustains our reputation as a premier employer. PRISM is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.