Data Solutions Architect

ECS is seeking a Data Solutions Architect to work in our Arlington, VA office.

Job Description:
Responsibilities:

• Functions as the primary technical architect for data warehousing projects to solve business

intelligence challenges

• Possesses deep technical expertise in database design, ETL (OWB/ODI), reporting, and analytics
• Previous consulting experience utilizing an agile delivery methodology

The selected individual will need to live within driving distance of Arlington VA so that they are able to come into the office if needed. Telework will be available, schedule determined by manager.

Required Skills:

• Three years’ experience with Azure ETL processing
• Three years’ experience utilizing data warehousing methodologies and processes
• Strong conceptual, analytical, and decision-making skills
• Knowledge and Experience of dimensional modeling
• Strong knowledge of Azure Databricks
• Proficiency in creating PL/SQL packages
• Full SDLC and Data Modeling experience
• Ability to create both logical and physical data models
• Ability to tune databases for maximum performance
• Experience in Data Preparation: Data Profiling, Data Cleansing, and Data Auditing
• Ability to work with Business Analysts to create functional specifications and data
• Manages QA functions
• Develops unit, system, and integration test plans and manages execution
• Ability to write technical and end-user system documentation
• Excellent written and oral communication skills
• Experience transforming logical business requirements into appropriate schemas and models
• Ability to analyze and evaluate moderate to highly complex information systems by being able to interpret

such devices as Entity Relation Diagrams, data dictionaries, record layouts, and logic flow diagrams.

Job Type: Full-time

Pay: $130,000.00 - $150,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Experience:

• Azure ETL process: 3 years (Preferred)
• Azure Databricks: 3 years (Preferred)
• PL/SQL packages creation: 3 years (Preferred)
• SDLC data modeling: 2 years (Preferred)

Work Location: In person

Salary : $130,000 - $150,000