Sr. Data Engineer

Position : Sr. Data Engineer

Duration: 04 Months Contract
Location: 1800 ROBERT FULTON DR STE 310 RESTON, Virginia 20191 (3 days onsite)

The Senior Data Engineer is a senior technical role in supporting the information management architecture of the Enterprise Data Warehouse solution. The role will be actively responsible for designing the data acquisition, data staging, loading, and transformation into the Enterprise Data Warehouse. This role will be a technical expert and resource collaborating with the Data Architect, Software Engineers, Product Owners, and Project Team to develop and deliver data storage and movement solutions and to organize and oversee the loading of data into the related systems. Additionally, the Senior Data Engineer will bridge gaps related to Business Intelligence functions, supporting the analytics produced by the organization, and providing expertise tying data movement together with data consumption.

Position Accountabilities:

Design and develop complex ETL solutions using data warehouse design best practices

Analyze data requirements, data models, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects

Create complex business intelligence reports and data visualizations using tools like Python, Tableau, and PowerBI

Analyze business requirements and outline solutions

Validate code against business and architectural requirements

Create and test prototypes

Troubleshoot applications and resolve defects

Work within an agile framework

Plan, Prioritize and Deliver Resilient, Scalable technical solutions

Communicate ideas in both technical and user friendly language

Update and maintain product documentation

Escalate issues and impediments in a timely manner

Work within established framework and processes (Agile)

Collaboratively work with Agile teams, as well as independently

Perform and coordinate unit and system integration testing when required

Participate in peer programming, mobbing, hackathons, and code reviews as required

Support and occasionally lead business intelligence efforts, data analytics efforts, and data governance/quality efforts

Position Qualifications

Education & Experience

• A Bachelor's Degree or a combination of equivalent work experience
• 7+ years of previous experience in information technology, preferably within the financial services or other highly-regulated industry
• 5+ years ETL development experience
• 3+ years of Business Intelligence, Data Analytics, or Data Science experience
• 3+ years of experience in an Agile environment
• Knowledge of ETL and data warehouse design
• Experience using Python for data movement/manipulation
• Extensive experience with data dictionaries, data analysis and relational databases
• Experience with a business intelligence toolset

Preferred Qualifications

• A Master's Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.

Knowledge & Skills

Creative problem solver with excellent communication, leadership and collaboration skills.

Advanced decision making and problem solving skills

Business acumen, knowledge and professionalism

Proactive leadership style and a self-starter and strong attention to detail

A clear and familiar understanding of the concepts and best practices of data warehouse ETL design

Demonstrable expertise with RDBMS or Big Data technology

Foundational Database administration skills; Broad DW skills including Semantic Layer, Basic BI Development and basic data modeling & data analysis

Methodical and structured approach to design and development.

Delivery focused with the ability to prioritize activities.

Flexible team player within a small, multi-disciplinary team.