Analytica is seeking a Data Architect to support dynamic federal government enterprise data programs. The ideal candidate will lead the architecture and implementation of robust high-volume system architectures using innovative technologies.
Responsibilities include (But Are Not Necessarily Limited To):
Support development of complex logical and physical database design efforts using databases such as PostgreSQL and SQL Server.
Develop solutions for multiple large data warehouses/operational data stores with knowledge of high scale or distributed Relational Database Management systems (RDBMS) and traditional RDBMS with hands-on programming capability in such environments.
Develop database procedures and functions and develop extract, transform, and load (ETL) processes.
Assists in developing and administering data standards, policies, and procedures, metadata and including data security.
Assists management in the application of information security and the adherence to data management policies, principles, and practices.
Work with teams to train users on consuming data and the appropriate tools and technical skills require to do so. Provide training where needed.
Bachelor’s degree in Computer Science, Engineering, Science, or related field
3+ years of experience in database design, architecture, and data modeling
Experience with query tuning, optimization, and refactoring for performance
Experience in SQL Server and/or PostgreSQL
Experience in Linux Environment and Shell Scripting
Experience in managing code using GitHub or other Source Code Management Tool
Experience with Data Marts, Data Lakes
Implemented data sharding strategy to house Big Relational Data in CitusDB, AWS Redshift and AWS RDS
Provided DataMart catered to various Research groups
Devised data migration strategy from local datacenter to AWS cloud native infrastructure
Leveraged all prominent AWS Lambda, S3, SNS, ECS, Glue, RDS, Redshift and other various other services to replace legacy big data system
Leverage Vagrant, Docker to facilitate productivity for fellow team members.
Used various programming (Python, Java, Go, Bash) languages to quickly devise solutions for each use case
About Analytica: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. The company is an award-winning SBA certified 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. As a federal contractor, Analytica is required to verify that all employees are fully vaccinated against COVID-19. If you receive an offer and are unable to get vaccinated for religious or medical reasons, you may request a reasonable accommodation.