Data Architect with Security Clearance

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.