Data Engineer
Data Engineer
- US Citizenship Required
- Contract to Hire Opportunity
- Fully Remote
The Senior Data Engineer will oversee the department's data integration work, including developing data models, maintaining a data warehouse and analytics environment, and writing scripts for data integration and analysis. This role will work closely and collaboratively with members of other areas to define requirements, mine and analyze data, integrate data from a variety of sources, and deploy high quality data pipelines in support of the analytics needs.
Responsibilities
- Maintain and build our data warehouse and analytics environment
- Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into our central data warehouse, and moving data out to applications and affiliates as needed
- Make data available for the reporting and analytics teams
- Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks
- Implement and monitor best in class security measures in our data warehouse and analytics environment, with an eye towards the evolving threat landscape
- Maintain high quality documentation of data definitions, transformations, and processes to ensure data governance and security
- Other duties as assigned
- Provide technical assistance in an on-call rotation
Job Qualifications
Required:
- Bachelor’s Degree in Computer Science or Management Information Systems (MIS) or Business, Finance or Accounting with an emphasis in MIS
- Minimum 5 years experience of developing and supporting enterprise level data warehouse systems
- Strong knowledge of relational databases and SQL. Extract, Transform, and Load (ETL) data into a relational database
- General data manipulation skills: read in data, process and clean it, transform and recode it, merge different data sets together, reformat data between wide and long, etc.
- Demonstrated ability to learn new techniques and troubleshoot code without support, ex. find answers to common programming challenges
- Strong knowledge of T-SQL language as evidenced by ability to write complex SQL queries, Microsoft SQL Management Studio, SQL Analysis Services and SQL Server Integration Services
- Demonstrated ability to work independently and be a self-starter
- Demonstrated ability to work effectively in teams, in both a lead and support role
- Strong analytical and problem-solving skills with the ability to work independently with minimal supervision
Preferred:
- Experience working with Data Vault 2.0
- Experience working with cloud infrastructure services like Amazon Web Services and Google Cloud
- Experience with advanced data visualization and mapping