Senior Database Architect

Project Description - Long term Data Warehouse Project with Innovative Data Management Consulting Firm. We are looking for someone like you to be a Senior Database Architect for Federal customer. Preferably a Master's Degree in Engineering, Computer Science, Systems, Business or related scientific/technical discipline and 10+ years of relevant experience.

15 years of additional relevant experience may be substituted for education.

Prior experience in a federal data warehouse and understanding of government procedures and regulations is preferred.

Must be authorized to work for any employer in the U.S

Must be able to obtain and maintain the required security clearance

As a Database Architect, you will support the design, implementation, and management of the database infrastructure. The ideal candidate should have a strong background in database design, optimization, and security in complex, federal environments. This is a hands on role, strong data warehousing experience needed at the technical level more than functional. Experience working with Federal clients.

NOTE: Job is initially on-site at customer location but strong chance will go to hybrid after employee proves themselves and is comfortable with the team.

Key Responsibilities:

• Performs a key management and thought leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, strong ETA skills, text mining, data discovery, statistical methods, database design and implementation.
• Develops and helps institute best practices, methodologies and standards with regards to Master Data Management (MDM), Data Dictionary, Data Quality, Data Governance, Data Structure, Data Architecture, and Data Security.
• Develops overall strategic data architecture direction and provides a comprehensive road map
• Works with Solution Architects, domain experts, and other project team members to develop consensual data architecture and data design to ensure the proposed solution meets both client and end user needs.
• Steward of Enterprise Data Lifecycle Management including data quality, data conversion, and data security technologies.
• Defines and achieves the strategy roadmap for the enterprise; including data modeling, implementation and data management for our enterprise data warehouse and advanced data analytics systems
• A Senior Database Architect has vast experience in assessing various alternative products, tools, and approaches for data management. A Senior Database Architect can clearly define risks and benefits of various approaches for a given need and create overarching design strategies.
• Serve as the Lead Database Architect

Participate in stakeholder meetings to understand and document technical requirements.

Collaborate with team to generate technical documentation including development planning, technical architecture, software testing and deployment process.

Participate in the development and execution of Change Management and Release Management Plans.

Provide recommendations for improvements and alternative solutions as part of an analysis of alternatives (AOA), with the goal of improving the stability, reliability and availability of the EDW.

Make internal and systematic changes to technical aspects as part of change management processes.

Participates in team calls and meetings.

Provides accurate and timely status reports on the progress of assigned tasks.

Coach and mentor team members.

Create and maintain documentation on processes and procedures and participate in period reviews of existing processes.

Provide after-hours remote support for incidents and emergencies as needed.

Be available on Government site in Washington DC during normal hours of operations.

Required Qualifications

• Strong experience with SQL 2005 and above
• Hands-on experience with NOSQL databases
• Excellent SQL skills and demonstrated ability to write complex queries
• Hands on experience with data profiling tools and processes
• Well versed in the following data domains: Master Data, Operational Data, Analytical Data, Unstructured Data, and Metadata.
• Expert knowledge of normalized and dimensional modeling techniques.
• Experience with data modeling (e.g. Erwin, Visio, Sybase Power Designer, EA, etc.), 3rd normal form and dimensional (Star schema, Snowflake).
• Experience with BI solutions: architecture, design and development of data marts, and reporting models. Hands on experience with BI tools, (e.g. Tableau, Dynamics, OBIE)
• Ability to manage multiple deadlines and work with Senior Executives (VP, Directors), Solution Architects, domain experts, and project team members to scope mobility solutions deliverables, tasks and levels of effort
• Solid experience with Data Warehouse and BI systems; extensive experience for collecting business requirements from customers, and transform the requirements into DB data processes and data schema.
• Proven ability to extract/source data from multiple data sources and integrate them into a single source view/report/dataset
• Strong understanding of data warehousing concepts and practices
• Working knowledge of all phases of the Software Development Life Cycle (SDLC).
• Experience with analyzing complex data correlations with the ability to define and explore the ‘what if’ scenarios
• Excellent oral and written communication skills; must be proficient developing and delivering presentations on solution and business case/value to senior U.S. Federal Government managers
• 10+ years of hands-on experience with data modeling, architecture, and implementation
• Minimum of a Bachelor's Degree (preferably Master’s Degree) in Computer Science or comparable industry experience
• Additional Requirements:
• Experience with Data API and Data Services applying SOA design and principles
• Big Data Analytic skills (Hadoop, Horton, Cloudera, MapR, R Language, etc.)

Desired Knowledge and Skills:

• Experience with government digital data strategy roadmap on the Cloud, On-Prem, and Hybrid environments
• Familiarity with network infrastructure, cloud solutions, Internet technologies, wireless networks, and machine-to-machine communications (i.e., Internet of Things) is preferred
• Familiarity with Agile Development Methodology
• Sound understanding of Business Intelligence related Data Profiling, Reporting Tools, Visualization, Analytics, Dashboards, and Predictive Analysis through tools and technologies. Demonstrated business acumen and the ability to apply technology solutions to solve business problems
• Experience in delivering self-service BI solutions that promote data discovery
• Current Environment:
• Oracle

• Informatica/ETL
• Tableau
• OBIE
• Dynamics

Basic Qualifications:

• US Citizen
• Preferably Masters Degree in engineering /Bachelors Degree with 10+ years exp
• Experience working with IT teams and collaborating with technical teams of diverse IT related skill
• Experience creating briefs, spreadsheets, and concise, clear documentation
• Exemplary communication and analytical skills

Compensation and Benefits:

• IAS offers very competitive salary range for this position based on experience and other factors.
• Retirement
• Life & Disability Insurance
• Career Development
• Medical, Dental, & Vision Care
• Among others

Job Type: Full-time

Pay: $140,500.00 - $152,500.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Retirement plan

Compensation package:

• Yearly pay

Experience level:

• 10 years

Schedule:

• 8 hour shift

Ability to Relocate:

• Washington, DC 20006: Relocate before starting work (Required)

Work Location: In person