Data Engineer

HDR   •  

Omaha, NE

5 - 7 years

Posted 286 days ago

This job is no longer available.

  As a Data Engineer working with HDR’s Predictive Analytics Team, you will work with other Data Engineers designing and building automated systems for historical and predictive analysis to support Data Science and Data Analysis projects. You will be responsible for sourcing, collecting, storing, processing, integrating, and making data available to Data Scientists and Data Analysts for analysis and predictive modeling.  You will provide strategic input and develop enhancements to HDR’s proprietary databases, data pipelines, analytical tools, and when appropriate, develop data tools in-house.  This position reports to the Vice President of HDR Consulting and is a key member of the Predictive Analytics team.
Additional duties include:
• Collaborate with a team of data/analytics experts and subject matter experts to solve company and client problems using data;
• Design and develop data warehouse for ease of use, organization, accessibility, security, regulatory (HIPAA, FERPA, etc.) compliance, performance, scalability, monitoring, and availability;
• Clean, transform, aggregate and integrate data into data warehouse;
• Design and develop ETL system and data pipelines that move data from a variety of sources into warehouse, monitor data quality, check for errors and conform data to standards;
• Build Database objects (tables, views, stored procedures, functions, etc.) and data services that provide data in format most useful for analysis and predictive modeling;
• Maintain data pipelines, architecture and schemas to maximize the (re-)usability, accuracy, robustness, performance, and scalability;
• Source data from public sources such as web services (e.g. REST APIs), files (CSV, xlsx, xml, etc.) and web pages (e.g. web scraping);
• Create and maintain documentation, data governance policy and metadata repository to ensure the accuracy, validity, reusability, and consistency;
• Learn and evaluate 3rd party data tools, develop in-house data tools, and train team on use;
• Stay abreast of trends and new developments in data technology;
• Contribute to strategy and roadmap for Predictive Analytics;
• Work to understand the needs of Data Scientists and Data Analysts and design, develop and document data objects to anticipate the needs of Data Scientists and Data Analysts;
• Work iteratively without complete specifications to solve complex problems involving challenging data sets with little to no guidance or direction. 


 Qualifications: • Bachelor's degree in computer science, engineering, mathematics, statistics, management information systems or related field preferred;
• Masters degree in similar field preferred;
• Minimum five (5) years related experience preferred; 3 years required;
• Has extensive knowledge of database technology, best practices and patterns;
• Knowledge of and experience with dimensional data modeling and data warehousing;
• Has experience building data pipelines and ETL systems;
• Independent worker able to manage multiple projects and priorities;
• Advanced analytical thinking and problem solving skills;
• Strong communication skills with the ability to compile and present information;
• A high level performer and self-starter with a strong customer service focus;
• Comfortable working with clients to make data requests and resolve issues with client data;
• Must work responsibly with confidential and private information;
• Potential travel up to 25%. Passport will be required;• Preference given to local candidates;
Experience using the following technologies is preferred: 
• Databases: Microsoft SQL Server; 
• ETL tools: SQL Server Integration Services (SSIS); 
• Scripting languages: Python, R, PowerShell; 
• Reporting tools: Tableau, SQL Server Reporting Services (SSRS), Power BI; 
• Other: ArcGIS, XML, CSS, JavaScript