Solutions Architect

Analytica is seeking a Solutions Architect with ability to build & maintain complex cloud-based data solutions based upon AWS & Snowflake. The ideal candidate will be comfortable collaborating with federal clients to architect and develop secure, cloud solutions.  
Analytica is recognized by Inc as one of the fastest-growing private small businesses in the US.  We work with US government customers in civilian and national security missions to deliver data-driven solutions.  The company offers highly competitive compensation with opportunities for bonuses, employer-paid health care, training and development funds, and a 401k match 

  
Key Responsibilities 

• Design and Architecture 
• Develop scalable and secure cloud-based data architectures using AWS and Snowflake. 
• Define data models, data pipelines, and ETL/ELT processes to support analytics and client needs in the federal space. 
• Establish best practices for data storage, processing, and retrieval in cloud environments. 
• Implementation and Development 
• Transition existing cloud AWS environment without interruptions to ongoing operations 
• Build and optimize data pipelines using AWS tools (e.g., Glue, Lambda, S3, Redshift) and Snowflake. 
• Collaborate with engineering teams to integrate data solutions with existing applications and systems. 
• Implement monitoring, logging, and alerting mechanisms for cloud data infrastructure ensuring data pipeline health and performance. 
• Collaboration and Leadership 
• Partner with stakeholders to gather and understand business requirements and translate them into technical solutions. 
• Provide mentorship and technical leadership to data engineers and analysts, promoting adherence to architectural standards.  
• Facilitate cross-functional collaboration to drive successful project delivery.  
• Provide technical mentorship and leadership within the organization. 
• Security and Compliance 
• Ensure data solutions meet enterprise security and compliance standards. 
• Implement role-based access controls (RBAC), encryption, and data masking in Snowflake. 
• Monitor and mitigate potential vulnerabilities in AWS data services. 
• Maintain system ATO FISMA/ NIST security controls, FEDRamp 
• Optimization and Performance 
• Optimize Snowflake data warehouses for performance and cost efficiency. 
• Fine-tune AWS resources to minimize latency and maximize throughput. 
• Perform regular audits and capacity planning for data infrastructure. 

Basic Qualifications 

• Bachelor’s degree in Computer Science, Information Technology Management, Engineering or related field.  
• U.S. Citizenship required
• CMS Experience
• Current AWS Solution Architect certification. 
• 10+ years of professional experience developing and testing large scale, enterprise software.   
• 6+ years of experience developing governed data analytics solutions, including expertise in data pipelines, transformations, and visualizations. Including experience with Tableau, PowerBI, Qlik, or QuickSight integrations.  
• 5+ Cloud based data warehousing experience to include Redshift, SnowFlake, Databricks  
• Hands-on experience designing and deploying large-scale cloud-based data solutions. 
• Experience integrating Snowflake with AWS tools and third-party systems. 
• Proven expertise with AWS services (e.g., S3, Glue, Lambda, EC2, IAM, Redshift, etc.). 
• Deep understanding of Snowflake architecture, including data sharing, multi-cluster warehouses, and Snowpipe. 
• Strong proficiency in SQL and experience with scripting languages (e.g., Python, Java, or Scala). 
• Knowledge of data modeling, data warehousing concepts, and schema design. 
• Strong communication and collaboration abilities. 
• Analytical mindset with problem-solving skills. 
• Ability to adapt to rapidly changing technologies and business needs
• Ability to adapt to rapidly changing technologies and business needs

Preferred Qualifications 

• Snowflake SnowPro Certification (preferred) 
• Snowflake SnowPro Certification (preferred).   
• Familiarity with data visualization tools (e.g., Tableau, Power BI, SAS, Jupyter Notebook). 
• Experience with CI/CD pipelines and infrastructure-as-code tools like Terraform or AWS CloudFormation. 
• Knowledge of big data frameworks i.e., healthcare claims  
• Understanding of machine learning workflows and data science integration in cloud ecosystems. 
• Familiar with CMS AWS infrastructure, data management and cloud services tools 
• Support the project director in ensuring the contract requirements surrounding the data environment and technology functions of the contract are satisfied. The tasks must include, but are not limited to: 
• Establish documentation and procedural standards for a transition and the steady state environment. 
• Prepare data management and data governance plans as needed. 
• Prepare and submit to the CMS Project Officer: 
• Host’s Current Hardware and Software Infrastructure 
• Host Annual Utilization Report 
• Host Security 
• Disaster Recovery Exercise 
• Continuity of Operations Plan 
• Disaster Recovery Plan 

About ANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established SBA certified HUBZone and 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.