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.
Basic Qualifications: 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.