Apex Systems
Sr Data Engineer
Apex Systems - Glen Allen, Virginia, United States, 23059
Work at Apex Systems
Overview
- View job
Overview
Sr Data Engineer
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. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.
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. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.