Detailed Job Description – Data Engineer
Position: Data Engineer
Location: Columbus, OH
Data Engineer Job Duties: Data Engineer is responsible for managing, functioning, building and maintaining the data architecture of systems implementation. Data Engineer ensures uninterrupted flow of information between systems and their applications. The position will be responsible for hands-on development of various current and new data warehouse initiatives while maintaining the exceptional level of professionalism and customer service standards that is attained with the industry. The specific job duties typically involve the following areas but not limited to these tasks.
Responsibilities:
➢ Contributing at a senior-level to the data warehouse design and data preparation by implementing a solid, robust, extensible design that supports key business flows.
➢ Performing all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.
➢ Establishing efficient design and programming patterns for engineers as well as for non-technical individuals
➢ Designing, integrating, and documenting technical components for seamless data extraction and analysis on our big data platform.
➢ Ensuring best practices that can be adopted in Big Data stack and share across teams and BUs.
➢ Working in a team environment, interact with multiple groups on a daily basis (very strong communication skills).
➢ Make ongoing recommendations of solution standards and system configurations
➢ Work in cross-disciplinary teams to understand client needs and ingest rich data sources.
➢ Research, experiment, and utilize leading Big Data technologies in AWS
➢ Enabling an innovative approach to data platforms which greatly increase the flexibility, scalability, and reliability of IT services at a lower cost.
Requirements for the position:
- Bachelor’s degree in computer related field or equivalent experience in computer systems desired.
- Experience in data analysis, Data Engineering or big data is desired.
- Ability to write, analyze, and debug SQL queries.
- Working experience with Hadoop projects/infrastructure.
- Experience with Data Warehouse design, ETL (Extract, Transform, Load), architecting efficient software solutions
- Experience in the big data space (Hadoop Stack like MIR, HDFS, Pig, Hive, etc.)
- Knowledge of data modeling for both data warehousing and Big Data.
- Experience working extensively in multi-petabyte data environment.
- Experience in engineering large-scale distributed systems in a production environment.
- Exposure with at least one scripting language (Shell, Python, Perl etc.)
Job Type: Full-time
Pay: $74,579.56 - $161,372.74 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Schedule:
- 8 hour shift
Experience:
- Informatica: 1 year (Preferred)
- SQL: 1 year (Preferred)
- Data warehouse: 1 year (Preferred)
Ability to Commute:
- Columbus, OH 43221 (Required)
Ability to Relocate:
- Columbus, OH 43221: Relocate before starting work (Required)
Work Location: In person