Job Description Job #: 985994Our client is looking for a Principal Data Architect for their office in Durham, NC. Candidates should have architect level experience with Java/AWS/Data Lake.If qualified, please send your resume to Morgan at email@example.com!The Data Engineer will work closely with senior engineers, data scientists and other stakeholders to design and maintain moderate to advanced data models. The Data Engineer is responsible for developing and supporting advanced reports that provide accurate and timely data for internal and external clients. The Data Engineer will design and grow a data infrastructure that powers our ability to make timely and data-driven decisions. Job Description Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient programming processes Document, and test moderate data systems that bring together data from disparate sources, making it available to data scientists, and other users using scripting and/or programming languages Write and refine code to ensure performance and reliability of data extraction and processing Participate in requirements gathering sessions with business and technical staff to distill technical requirement from business requests Develop SQL queries to extract data for analysis and model construction Own delivery of moderately sized data engineering projects Define and implement integrated data models, allowing integration of data from multiple sources Design and develop scalable, efficient data pipeline processes to handle data ingestion, cleansing, transformation, integration, and validation required to provide access to prepared data sets to analysts and data scientists Ensure performance and reliability of data processes Define and implement data stores based on system requirements and consumer requirements Document and test data processes including performance of through data validation and verification Collaborate with cross functional team to resolve data quality and operational issues and ensure timely delivery of products Develop and implement scripts for database and data process maintenance, monitoring, and performance tuning Analyze and evaluate databases in order to identify and recommend improvements and optimization Design eye-catching visualizations to convey information to users Hiring Requirements Bachelors degree in Computer Science or related field or equivalent experience 7+ years programming experience in Java (required) and Python is really nice to have 7+ years of SQL programming skills (Intermediate to Advance SQL programming skills) Strong Data Lake experience Experience working in AWS and other cloud technologies Demonstrated experience working with large and complex data sets Experience with business intelligence tools (Tableau) Hiring Preferences Experience with query and process optimization Ability to translate task/business requirements into written technical requirements Reliable task estimation skills Excellent quantitative, problem solving and analytic skills Ability to document data pipeline architecture and design Ability to collaborate effectively with business stakeholders, performance consultants, data scientists, and other data engineers Proficient in use of MS Office applications including expert level Excel programming Ability to quickly become an expert in operational processes and data of lines of business Ability to troubleshoot and document findings and recommendations Ability to communicate risks, problems, and updates to leadership Ability to keep up with a rapidly evolving technology spaceEEO EmployerApex 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. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178.