Data Architect - Herndon, United States - CGH Technologies, Inc.

Description

Job Description

CGH Technologies, Inc. (CGH) is a business solutions firm, specializing in Data Management, Software Engineering, and Business Intelligence solutions. Located within the Washington corridor, CGH has worked successfully with Government, Commercial and International sectors, providing management consulting, software development and facilities/infrastructure design, maintenance and program management support of large, complex operational environments and facilities security maintenance. CGH has an exciting opportunity for a Data Architect to join the CGH Team.

Purpose:

The Data Architect will support projects under the guidance of the Chief Technical Officer to help define and support long-term, enterprise-level data architecture and management strategies. The qualified candidate will have proven abilities in developing data architecture solutions for large scale enterprise applications.

Responsibilities:

• Work closely with business analysts, subject matter experts and development teams to design, develop, test, implement and support master data management (MDM) project.
• Participate in meetings with both technology and business team to facilitate the understanding, clarification and implementation of data requirements.
• Develop data architectural diagrams to illustrate architectural complexities and interactions.
• Acts as the subject matter expert for multiple portfolios of moderate complexity and serves as the system architecture authority within that scope.
• Identifies and evaluates data architecture models utilizing knowledge of industry and technical trends. Reviews and approves design decisions prior to implementation to ensure adherence to prescribed guidelines.
• Advises client regarding data architecture, vision and strategy, innovations and enterprise architecture services.
• Serves as the lead data architect for all data warehouse, reporting, and analytic (BI/DSS) projects; and plays a lead role in establishing data ownership/stewardship within the organization.
• Hands on experience in design, development and operations of complex database systems.
• Manage a data architect task order on large contract vehicle.
• Plan/Execute data analysis, development, prototyping and deployment utilizing agile and project management best practices.
• Create and execute project plan; plan and track schedules and technical quality performance requirements; provide weekly status reports to customer and to contract Program Manager; and ensure task is completed on schedule and within budget.
• Conduct Technical Solutions Assessments and Trade-off Analysis.
• Define the overall customer data strategy for a portfolio of programs. This will require solving some fundamental and highly challenging issues in terms of what data to capture and how to integrate the data between the business functions, and how to organize it for maximum leverage; what tools and technologies we should deploy; and how we define data governance.
• A key challenge will be to build capabilities that can grow and expand to encompass Software as a Service offerings and an increasing portfolio of support, service, and community web-sites. A core component of the execution is the setup of data stewardship capabilities to implement data governance.
• Work with downstream application designers to integrate data input into the various workflows. Work with data warehousing, analytics systems to make sure that data is leveraged appropriately.
• Develop and deliver critical dashboards that describe the state of data health across the enterprise at the highest level. This will highlight data issues from capture or edge systems.
• Act as an industry thought leader to continue to build up awareness of company as a front-runner SaaS company across the broader web business community as well as a company that leads in utilizing data as a strategic advantage. This may involve speaking at industry events, sharing best-practices with other team members, building working relationships with key data experts, firms, and consultants, and more.
• The Data Architect needs to be able to have an end-to-end vision, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive Stages involved. They will need to be able to address issues of Data Migration (Validation, Clean-up and Mapping), and will need to understand the importance of Data Dictionaries.

Qualifications

Number of Years Experience Required:

• 15 years of information technology or technical architecture/design experience.
• Minimum 10 year's hands-on experience with geospatial data.
• Minimum 10 year's hands-on experience with PostgreSQL and PostGIS databases.

Minimum Education and Certifications Required:

• Bachelor's Degree in computer science, information technologies, or related field preferred.

Technical Skills Required:

• Senior Java Fullstack developer
• Experience with designing and developing maps on the web using OpenSource frameworks
• Expert with FME a plus
• Experience with data modeling, architecting, data analysis, data migration tools, data modeling, data integration, data warehousing, database design, and performance tuning on larger databases
• Experience in various technologies and design
• Experience with PostgreSQL and PostGIS Databases
• Oracle Advanced Replication, monitoring and tuning, backup and disaster recovery
• UNIX System Administration

Computer Skills:

• Oracle 10g/9i/8i/8.0/7.x Database Administration
• Oracle 10gRAC
• Oracle PL/SQL
• SQL*Plus
• Unix Administration & Shell Scripting
• Oracle Designer 6
• Developer 2000 (Forms & Reports)
• Production Support / Database Maintenance / Security
• Microsoft Office Suite

Other Knowledge, Skills, and Abilities Required:

• U.S. Citizen or person with valid U.S. Work Visa who has lived in the U.S. for 3 or more years.
• Experience working with appropriate programming languages, operating systems, hardware and software.
• Experience working with industry specific technologies.
• Strong communication skills.
• Strong interpersonal and presentation skills for interacting with the most senior levels of internal staff, management and clients.
• Strong analytical and problem solving skills.
• Strong leadership skills.
• Good project management skills.
• May require occasional light lifting of up to 10 pounds.
• While performing the duties of this job, the individual is regularly required to sit, stand, talk, hear and use a computer/keyboard/mouse for several hours on a daily basis.

Candidates selected will be subject to a Government background investigation and must meet eligibility requirements.

CGH offers a comprehensive benefits package to include medical, dental, short- and long-term disability insurance, life insurance, commuter benefit, and flexible spending account. Other benefits include 401K, paid holidays, and Paid Time Off (PTO).

CGH is an Equal Opportunity Employer