Data Warehouse Developer in Juno Beach, FL at APEX Systems

Date Posted: 9/7/2019

Job Snapshot

Job Description

Job #:  981965
Apex Systems has an opening for a long term Data Engineer in Miami, FL. Client is seeking candidates strong in SQL to and schema/table design to assist them in migrating large amounts of data to AWS.  Ideally looking for a candidate with RedShift exposure for moving data to AWS.
The job description is provided below.  If interested, please email your up to date resume to Aaron Gibbs, Senior Professional Recruiter, via agibbs@apexsystemsinc.com.  If you wish to receive job alerts from Apex that match your criteria please join our Talent Network/Job Portal via https://itcareers.apexsystemsinc.com.
Job Description:
  • Design, develop and maintain optimal data pipeline architecture.
  • Assemble large, complex data sets that meet business requirements.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • Work with stakeholders to assist with data-related technical issues and support their data needs.
  • Work with data and analytics experts to strive for greater functionality in our data systems.
  • Responsible for ensuring compliance with applicable laws, regulations and company policies across areas of organizational responsibility.
  • Advanced working SQL knowledge and experience working with relational databases (SQL Server, Oracle, PostGre SQL, DynamoDB, query authoring (SQL)
  • Experience working with columnar databases such as AWS Redshift
  • Excellent understanding of AWS Architecture Experience designing data warehouse using Ralph Kimball Methodologies.
  • Experience working with large Data Warehouses - multiple TB Scale.
  • Power BI experience and advanced DAX writing skill highly preferred.
  • Should have the ability to independently design Business Intelligence / analytic solutions.
  • Experience documenting business requirements and technical architecture/design while translating complex requirements and designs for development, testing and implementation
  • Provide conceptual and logical data architecture supporting visualization, research, and machine learning teams
  • Collaborate with cross-functional agile teams of software engineers, data engineers, ML experts, and others in building new product features
  • Proven analytical and problem-solving skills
  • Effective verbal and written communication skills with both management and peers
  • Candidate is required to have significant ETL / ELT experience, lead analysis, architecture, design, and development of data warehouse and business intelligence solutions.
  • Desirable tool experience: Redshift, Matillion / Talend / Informatica / SSIS

 
 
 
 
 
 
 
 
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178-6178.

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs