Data Engineer / Architect (U.S. Citizen) - POWERHOUSE INSTITUTE INC

Data Engineer / Architect


NOTE:   This is a full-time employment opportunity (No C2C, subcontractor or 1099 engagements, please).  The candidate MUST be a U.S. Citizen and have an active secret clearance (preferred) OR able to qualify/hold a secret clearance.  This is a remote opportunity with future possibility of becoming hybrid - candidate must be in local to the DC/MD/VA area (Arlington VA). 

Daily Responsibilities

• Responsible for designing, creating, deploying, and managing how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data in some way.
• Design new architectures and re-designing existing architectures; including data structures and database code. Design and build relational databases.
• Perform data access analysis design, and archive/recovery design and implementation, especially in a Microsoft SQL Server environment. Able to define, design, and build dimensional databases.
• Design and implement all database objects including schemas, tables, clusters, indexes, views, sequences, packages, and procedures based on system requirements.
• Develop data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. Develop strategies for data acquisitions, archive recovery, and implementation of a database. Translates business needs into long-term architecture solutions.
• Managing input of various data sources, definition of database architecture, development of database code, construction, and maintenance of ETL based processes, design of database reporting, construction of data flow diagrams and creation of documentation manuals.
• Creating code for database modification, constructing, and accessing databases using stored procedures, triggers, and functions; developing ETL processes.
• Implement and optimize queries and stored procedures.  
• Designing new architectures and re-designing existing architectures (including data structures and database code).
• Review and develop object and data models and the metadata repository to structure the data for better management and quicker access.
• Provide guidance and support to all technical positions including system architects, developers, and database administrators.

Requirements

• Must be a U.S. Citizen as mandated by our government client.
• Must have an active secret clearance (preferred) OR able to qualify/hold a secret clearance.
• Must be local to the DC/MD/VA metro area, no convenience travel.
• 12 years related in the software development field.
• 10 years of professional experience in database architecture
• 3 years of experience managing data integration between SaaS solutions and between SaaS and .NET applications.
• Expert-level knowledge of Microsoft SQL Server.
• Expert knowledge with data profiling and migration tasks. Data migration expertise.
• Expert in backup integrity and disaster recovery situations. Expert in a data warehouse environment, which includes data design, database architecture, and metadata repository creation.
• Expert with data definition language to implement database objects. Experience with coding stored procedures, functions, and triggers to implement data access controls.
• Expert reviewing, testing, and troubleshooting database structures and code.
• Experience masking and replicating large data sets (for privacy and testing purposes) using enterprise tools.
• Experience enforcing change management processes in each environment.
• BS/BA degree in Computer Science, Information Sciences, or related IT discipline.  Additional ten (10) years of related professional experience can be substituted for a BS/BA degree.

 

Powerhouse Institute, Inc. is a Management Consulting and Technology Solutions company. Our people bring a great mix of expertise and commitment to deliver solutions and solve problems.

Our services include Management Consulting, Enterprise Architecture, Solutions Architecture, Cloud Solutions, Cloud Migration, Data Analytics, Cyber Security, IT Services, and Training.

Powerhouse Institute, Inc. is an Equal Opportunity Employer. Powerhouse Institute, Inc. does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

Powered by JazzHR