Data Engineer

The Data Engineer is a 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 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 moderately 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 moderately 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 and Deliver Resilient, Scalable technical solutions
• Communicate ideas in technical language effectively
• Update and maintain product documentation
• Report issues and impediments in a timely manner
• Work within established framework and processes (Agile)
• Collaboratively work with Agile teams
• Perform and unit and system integration testing when required
• Participate in peer programming, mobbing, hackathons, and code reviews as required
• Support/participate in business intelligence efforts, data analytics efforts, and data governance/quality efforts

Position Qualifications

Education & Experience

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

Preferred Qualifications

• A Bachelor'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.
• Competency in decision making and problem solving skills
• Business acumen, knowledge and professionalism
• Proactive development style, demonstrating initiative and strong attention to detail
• A clear and familiar understanding of the concepts and best practices of data warehouse ETL design
• Demonstrable experience with RDBMS or Big Data technology
• Basic BI Development and basic data modeling & data analysis
• 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 role

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.