Data Architect

Booz Allen Hamilton
Norfolk VA / Remote
30+ days ago

Job Description

Key Role:

Initiate data architecture (DA) related activities, including extract-transform-load (ETL) processes and data warehouse solutions design, through business needs analysis and routine issue resolution. Designs database structures and authors SQL queries and scripts to perform ETL operations. Analyze DA related business needs and work with project staff to make decisions and recommendations on the future of DA developments. Design database, data models, ETL processes, data warehouse applications and business intelligence reports through the use of best practices and tool. Resolve routine DA related issues with business analysts and technology teams by providing advice on data warehousing methods and approaches. Review the current database environment and implement changes to comply with mission critical requirements. This position is open to remote delivery anywhere within the U.S., to include the District of Columbia.

Basic Qualifications:

  • 2+ years of experience in developing complex multi-data source SQL queries on a variety of relational database technologies with a specific emphasis on Microsoft technologies, including Microsoft Access and SQL Server
  • 2+ years of experience with writing data manipulation logic using programming languages, including C# and VBA
  • 2+ years of experience with defining and implementing robust and scalable data structures, including SQL
  • Experience with Microsoft Office, including Access, Word, PowerPoint, Excel and SharePoint
  • Experience with relational database development to support centralized data repositories that enable data science and data analytic activities
  • Knowledge of data management and transformation to provide efficient solutions and strong focus on business outcomes
  • Knowledge of data architecture and designing end-to-end solution on ingest, process, and analysis of large and complex data set
  • Knowledge of database architecture and performance implications, relational and dimensional modeling, and data mining and ETL design processes
  • Secret clearance
  • BA or BS degree

Additional Qualifications:

  • Experience with working in an agile development environment, collaborating with Application Development and Architecture Teams
  • Experience with SQL Server Integration Services (SSIS)
  • Ability to work with government and military clients
  • Ability to respond to changing priorities
  • Ability to meet deadlines, adhere to project plans and support several projects simultaneously
  • BA or BS degree in CS, Information Technology, Engineering, or Mathematics

Clearance:
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Secret clearance is required.

We’re an EOE that empowers our people—no matter their race, color, religion, sex, gender identity, sexual orientation, national origin, disability, veteran status, or other protected characteristic—to fearlessly drive change.

#LI-AH1

Source

https://www.indeed.com/jobs

Not sure if you qualify?

Uvaro is here to help you land great jobs like this one.

Upgrade your skills

Other Jobs

Rise People

Rise is Canada’s complete people management solution that gives employers everything they need to build loyal and productive teams—all in one place. We collaborate and co-create to build solutions that completely change how companies of all shapes and sizes manage their payroll, scheduling, time tracking, group benefits, recruitment, onboarding, and more.

 
Vancouver, BC
Uvaro

1+ years of successful sales development experienced experience in B2B software or B2C services is a plus. Ability to work occasional evenings or weekends.

 
Waterloo, ON / Remote
Sysco

US0006 Sysco North Texas (Division of USA I). Personal protective equipment and masks provided. Sanitizing, disinfecting, and cleaning procedures in place.

an hour ago
Lewisville, TX