Cloud Data Engineer II

Mariner Finance•White Marsh, MD

27d•Onsite

About The Position

Cloud Data Engineer II FLSA StatusExempt Schedule: Work hours will depend on the business hours of the time zone serviced. To the extent permitted by law, the Company may, in its sole discretion, change the work schedule to address business need. In This Role, You Will: Be responsible for the design and implementation of our enterprise cloud infrastructure, software, and integrations. Provide experience and expertise to deliver cutting-edge solutions as a key member of this highly productive team. Design, develop, and maintain the enterprise cloud architecture. IND1 #LI-JA2 #LI-Onsite

Requirements

Bachelor's degree in Computer Science, Information Systems Management, Engineering, or related field; additional, applicable years of experience may be substituted for the bachelor's degree.
Minimum of three (3) years' experience with ETL Development and Data Migration.
Advanced expertise with AWS services such as EC2, Redshift, S3, SageMaker, Lambda, Matillion and API Gateway.
Expertise with building and enhancing Machine Learning Models in SageMaker/Python.
Advanced SQL Query, ETL/ELT/LET and Data Architecture experience.
Broad experience in building out VPCs, subnets and network routing on AWS.
Experience using Microsoft's SQL Server, SSIS, SSAS, SSRS (Reporting Services), PowerBI Dashboards, and OLAP services.
Ability to quickly identify and troubleshoot problematic faults in data pipelines and infrastructure.
Ability to design tables, data-marts, and/or databases to suit business needs.
Knowledge of data mapping, data integration, database design and data warehouse concepts.
Experience with Jira, Bitbucket, and GitKraken with a good understanding of Git.
Desire and ability to learn emerging technologies and methodologies.
Ability to interpret requests and requirements in order to build appropriate automated solutions.
Ability to work with shifting deadlines in a fast-paced environment.
Strong computer skills including Microsoft Office (Visio, Excel, Word, & Outlook).
Strong attention to detail, interpersonal skills, and notation skills.

Nice To Haves

AWS Certifications.
Glue and Comprehend.

Responsibilities

Lead the hands-on technical delivery of new services and capabilities within the AWS environment.
Manage the AWS Cloud Infrastructure and assist in the maintenance of the SQL Server environment, identifying and troubleshooting faults as well as providing recommendations to ensure proper utilization.
Gather and process raw data from multiple disparate sources (including writing scripts, calling APIs, writing SQL queries, etc.) into a form suitable for data warehousing and machine learning.
Review and interpret ongoing business requirements. Research required data and build appropriate deliverables.
Refactor or develop relational data models, dimensional data models, data dictionaries and necessary metadata using Amazon Redshift in AWS.
Research and propose opportunities for data acquisition and new uses for existing data.
Code, test, and document new or modified data systems to create robust and scalable data/machine learning models for analytics.
Contribute to the design and direction of enterprise-wide data architecture as well as design documentation deliverables.
Create supporting technical and functional documentation, including data flow diagrams, and provide support for deployed solutions.
Work both independently and in collaboration with our application developers and data analysts to design and build high-performance algorithms, prototypes, predictive models and proof of concepts using SageMaker and other modeling tools.
Identify and implement process improvements through the design and implementation of policies, procedures, standardized documentation, and analytics infrastructure to enforce industry best practices.
Collaborate with Quality Assurance team and Subject Matter Experts to ensure valid and proper deliverables.
Supports business decisions with ad-hoc analysis as needed.
Explain tasks and processes in a clear and concise manner that can be consumed and understood to non-technical business associates.
Participate in rotation of after-hours support.
Complete projects, prioritize tasks, and provide frequent progress reports with limited direction from team leads based on company needs.
Cultivate business relationships with stakeholders.
May perform additional functions depending on market demand and staffing in order to provide consistent quality customer service.