Data Engineer

Company Name: Optomi
Location: USA
Posted by:

Miranda Supeno

Miranda Supeno

Optomi, in partnership with a digital firm that is at the forefront of Amazon analytics is seeking a Data Engineer to help take their best in class platform to the next level. As a Data Engineer, you’ll be responsible for working to build out and improve the company's data ingestion, transformation, transactional and data warehousing needs.

What The Right Candidate Will Enjoy

• Working with a RAPIDLY growing, technology driven company made up of A players with one unified mission
• Beautiful new office space in Federal Hill / Locust Point
• Direct access to executive leadership
• Unique opportunity to work with Amazon data sources
• Unlimited growth potential
• Flexible and fun work environment

Key Responsibilities

• Lead the technology strategies from a database perspective to align to the client technology standards
• Ability to work in a multi-tasking environment.
• Drive secure solutions that perform well and scale with the organization. Strong point of view on how things should get done
• Drive standardization on software solutions being implemented for data storage for all ETL processing.
• Determine the right data strategy for loading data efficiently and accurately
• Determine the right place for a data source to be stored to be used optimally. Determine where data sets should be loaded for application use or reporting use.
• Architect the proper data model for Application performance and reporting visualization
• Document the data model/Dictionary to enable a team of analysts
• Oversee data security and best in class data access protection procedures are in place
• Identify poorly running SQL and made changes to SQL or business process to correct issues
• Create custom monitoring jobs to keep database performance statistics and project future growth.
• Determine an archive strategy for all data that will encompass a hot, warm, cold data strategy. As it becomes costlier to store data in Red Shift, we need to determine what data should be kept there for fast retrieval and then determine what data needs to be available at a more cost-effective option
• Troubleshoot and root cause all data delays and inaccuracies to provide proactive monitoring and automation is in place

Apply Today If Your Background Includes

• Bachelor’s Degree, preferably in IT/Data-related field
• At least 3 years of experience in Python. Must be able to code in Python
• At least 3 years of SQL experience
• At least 2 years of AWS or other Cloud technology experience
• Redshift/Snowflake experience
• At least 2 years of Amazon EMR experience

• Seniority level

  Entry level

• Employment type

  Full-time

• Job function

  Information Technology

• Industries

  Information Technology and ServicesComputer SoftwareFinancial Services