Acme Marinas is looking for an Experienced Data Engineer to help launch a Data Analytics Project. This is a great opportunity for someone willing to start from the ground up on building a Data Warehouse and Pipeline Strategy to improve business decisions. The perfect candidate needs to be motivated by new challenges and learning a new industry.
The Data Engineer is responsible for designing, building and optimizing systems for data collection, storage, access, and analytics at scale.
Essential Functions/Responsibilities:
- Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Creates Snowflake modelling roles, databases, schemas, ETL tools with cloud-driven skills
- Work on SQL performance measuring, query tuning, and database tuning
- Handles SQL language and cloud-based technologies
- Creates the RBAC model at the infra and data level.
- Work on Data Masking / Encryption / Tokenization, Data Wrangling / ECreLT / Data Pipeline orchestration (tasks).
- Setup AWS S3/EC2, Configure External stages and SQS/SNS
- Performs Data Integration e.g. MSK Kafka connect and other partners like Delta lake (data bricks)
- Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies
- Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
- Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues
- Performs other duties as assigned or required.
Required Education and Experience
- Bachelor’s degree computer science/engineering or information systems
- 3-7 years of Data Engineering experience required
- Preferred hospitality industry experience with expertise in point-of-sale systems and experience with rolling up individual businesses (and multiple systems) into a consolidated, corporate platform.
- Experience in managing multiple projects at one time.
- Experience working in a team-oriented, collaborative environment.
- Hands-on experience with business requirements gathering/analysis.
- Proven experience in systems and network design and development.
- Strong understanding of information processing principles and practices.
- Strong knowledge of software evaluation principles and practices.
- Proven project planning and management experience.
Required Knowledge, Skills and Abilities:
- Experience with Snowflake, SQL, Python and Java
- Exceptional analytical, conceptual, and problem-solving abilities.
- Exceptional understanding of the organization’s goals and objectives.
- Superior written and oral communication skills.
- Excellent architecture and technical support documentation skills.
- Strong interpersonal and consultative skills.
- Ability to conduct research into emerging technologies and trends, standards, and products as required.
- Ability to present ideas in user-friendly language.
- Able to prioritize and execute tasks in a high-pressure environment.
- Ability to exercise good judgment in evaluation situations and making decisions.