Data Engineer - Informatica Cloud

Reliance Steel & Aluminum • Cypress, CA

71d • $106,000 - $146,000

About The Position

The Data Engineer II will be an integral member of the Reliance IT Data Integration team and will be expected to clean, prepare, and optimize data for consumption. The Data Engineer-II will work with the team to create high end data and analytics driven ETL solutions leveraging Informatica Data Management Cloud (IDMC), Amazon Web Services (AWS), Big Data tools and technologies. The Data Engineer II will collect and curate data from disparate sources to perform data interrogation, develop analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics. The Data Engineer II will communicate with stakeholders and conduct research to develop a comprehensive understanding of relevant business needs and requirements. In this role, the individual will identify and collect structured and unstructured data from various sources, evaluate the data to ensure that they meet analytic needs, and prepare the data for analysis. The role will require business and technical requirements gathering and documentation (BRD, PRD) experience, as well as data workflow design and presentations.

Requirements

• Bachelor's degree in computer science, Data Science, Mathematics, or equivalent work experience in a related field required.
• 4+ years of relevant experience in design, execution, and the use of a wide array of data analysis techniques and tools in designing solutions required.
• Advanced experience in Informatica Data Management Cloud (IDMC) required.
• Experience with programming languages such as Python, R, etc. required.
• Experience with relational SQL and NoSQL databases required.
• Experience with AWS GLUE ETL and AWS Analytics Services: Lambda, Step functions, EMR, Athena preferred.
• Must be self-motivated and able to work independently, with minimal supervision and as part of a team.
• Detail oriented with excellent interpersonal communication skills (verbal and written), with the ability to interact with all levels of an organization.
• Excellent customer service skills.
• Excellent analytical skills: expertise in statistical and data science principles and methods.
• Advanced experience in data quality, data wrangling, cleansing, and standardization required.
• Experience implementing and working with on-premise and cloud infrastructure required.
• Strong project management and organizational skills. Experience using a version control system is a plus (GitHub, Subversion, Azure Dev Ops).
• Proven history of delivering analytic solutions to solve complex problems using a data-driven approach and technical innovation.

Responsibilities

• Create and document technical designs for medium to high complexity solutions that may include integrations with external systems.
• Facilitates peer technical design review.
• Design systems that span multiple technologies/platforms.
• Define and document work processes/standards.
• Create and apply design standards across all applications.
• Design solutions to meet performance requirements and scalability expectations.
• Conduct data analysis and modeling to design medium to complex systems utilizing multiple technologies.
• Collect and curate data from disparate sources to perform data wrangling to clean, prepare, and standardize data for consumption.
• Design and create framework, program controls and services that can be utilized by other developers in creation of applications.
• Apply mathematical principles or statistical approaches to solve complex problems in scientific or applied fields.
• Analyze data to discover and interpret patterns, trends, and variances.
• Assist with technical design.
• Troubleshoot and resolve technical issues.
• Develop knowledge of the company's applications.
• Facilitates peer code reviews.
• Research, analyze, and identify data requirements and business processes.
• Develop data science models to automate manual processes and to scale pipelines.
• Derive insight driven outcomes while utilizing the latest technologies and programming languages.
• Extract and transform data through normalization, field mapping, merging, and other techniques to standardize and prepare data for analysis.
• Collaborate with cross functional teams to identify and solve business intelligence and data issues.
• Proactively enhances systems for stability, efficiency, scalability, and robustness.
• Develops, sponsors, and supports the introduction of new and improved methods, products, procedures, and technologies.
• Devise, makes recommendations, and guide implementation of corrective and/or preventive actions.
• Suggest better alternatives and solutions to given requirements based on experience.
• Construct new data assets by combining data from multiple sources, which may be ambiguous, incomplete, or inconsistently formatted.

Benefits

• 401k
• health_insurance
• dental_insurance
• vision_insurance
• paid_holidays
• tuition_reimbursement
• flexible_scheduling

What This Job Offers

• Career Level: Mid Level
• Industry: Merchant Wholesalers, Durable Goods
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees