CGS Federal (Contact Government Services) is looking for a Data Architect in Washington – Apply Here!

Deal Score0
Deal Score0

As a senior data architect for CGS, you will be responsible for the design, develop, and implementation of Data Warehouse database structures and Analytical Database structures. You will work with Business groups and Application Teams during pre & post assessment periods. You will report to Supervisor/Team Lead. You should be able to write complex SQL’s. You will write and execute Stored Procedures for analysis for data. You should understand the needs of the Business team and BI team for building proper Data Warehouse and DataMart. You should be capable of developing structured and unstructured data model for BI and Analytics. This job is 90% Remote.

Job Duties
• Understand and translate business needs into data models supporting long-term solutions for different Judiciary systems
• Work with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data models
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Optimize and update logical and physical data models to support Data Initiative project for different phases of implementation
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
• Recommend opportunities for reuse of data models in new environments
• Perform reverse engineering of physical data models from databases like DB2 and SQL scripts
• Evaluate data models and physical databases for variances and discrepancies across the different source systems in Judiciary
• Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Judiciary Standards
• Work with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfaces
• Review modifications to existing software to improve efficiency and performance

Experience
• Bachelor’s degree
• 8+ years of experience in Data Modeling
• 5+ years of experience in Bigdata Technologies
• Exposure with Snowflake’s Cloud Data Warehouse
• Well, versed in understanding relational data, dimensional data, unstructured data, and master data
• 6+ years of experience in data modeling software 
• AWS and Other Cloud systems experience 
• 8+ years of SQL and data profiling skills
• Experience in Data Modeling for Databases like DB2, AWS’ Redshift, Dynamo DB, Postgres, SQL Server

Some Benefits Of The Position Include
• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays

This is a job post for a position with CGS. We are a small business driven by providing our clients the most exceptional service in the sector. In order to give our clients, the best service we need to have the right team of motivated individuals to provide that service to them.

Our staff core values are as follows:

Honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

For more information about CGS please visit: https://www.cgsfederal.com

Powered by JazzHR

ruHklJCLwG

Apply Here

We will be happy to hear your thoughts

      Leave a reply

      Tech Jobs Here
      Logo

      Get Alerts on the Latest Job Posts in your Inbox- Daily!

       

       



       

      We will not spam you. Don't forget to add us to your contacts!