Data Engineer / ETL Developer Location:Baltimore, Maryland
100,000 - 200,000
Job Description:
Role:Data Engineer / ETL Developer
Location:Baltimore, Maryland
- The Data Engineer/ETL Developer will be responsible for integration and transformation of data sources into dimensional models for intuitive consumption.
- This includes designing DW/BI solution for performance, efficiency, scalability and security. You will have an opportunity to use the latest technology platforms in Tableau, TalenD and AWS (RDS, Redshift and S3).
Responsibilities
- Work closely with the business and technology teams to create scalable data models for reporting and analytical consumption.
- Identify and understand source data systems and become an expert of data sources and flows.
- Design, build and maintain ETL processes.
- Work with business and technology teams to extract data components related to customers, sales, marketing, and accounting for intuitive consumption in the data warehouse.
- Optimize and tune DB schemas for faster performance.
- Explore and recommend technologies and techniques to improve DW/BI functions.
Qualifications
- BS/BA in Computer Science, Information Systems or related field.
- 5+ years experience in relational database concepts with hands-on experience with MySQL, PostGRES, Oracle, or MSSQL.
- 5+ years experience with dimensional and star schema modeling techniques.
- 5+ years experience working with ETL tools (Informatica, IBM Websphere Information integration, SAP Data Integrator or SSIS) and technologies.
- 3+ years working with BI tools (Business Objects, Cognos, Microstrategy, SSRS, and QlikView).
- Experience with Salesforce.com a plus
- Experience with NoSQL databases a plus