Sr. Data Engineer (Hybrid--Richmond, VA)

Position Description

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.

Organizational Relationship

This position reports to the Manager - Software Engineering

Salary offered will be based on several factors including but not limited to education, work experience, certifications, etc. This position is also eligible to participate in either an applicable incentive compensation plan for the position or a discretionary profit sharing bonus program. General information on our comprehensive benefits package can be found by visiting https://www.atlanticunionbank.com/about/careers/benefits.

We are proud to be an Equal Employment Opportunity employer. We maintain a drug-free workplace.