noun_529702_ccPage 1GroupPage 1Page 1Page 1
Skip to main content

Data Developer

  • R0007455
  • Miami / South Florida — Corporate Office

Apply to Job

Job Description
The Data Developer extracts, transforms and loads data from various sources (external and internal) into an enterprise-wide MDM, transactional database and data warehousing systems. The incumbent in this role documents, implements, maintains and enforces the comprehensive data strategy, standards and processes. He/She assists in the design and construction of data structures and solutions and conducts tests of data structures and solutions.

ESSENTIAL JOB DUTIES/RESPONSIBILITIES:

  • Constructs ETL interfaces using SSIS to aggregate, cleanse and migrate data across enterprise-wide MDM, transactional database and Data Warehousing systems using staged data processing techniques, patterns and best practices.
  • Builds various components in SSIS for advanced data formatting and rules injection.
  • Implements and maintains the Enterprise Relational database design including physical and logical data models.
  • Assists in the design and development of database objects, tables, views, indexes, stored procedures, constraints, etc.
  • Analyzes query execution plans and optimizes database code.
  • Constructs Data Access Adapters (Stored Procedures, SQL Views).

Other responsibilities may include:

  • Works collaboratively as part of scrum development team.
  • Automates operational/maintenance tasks.
  • Produces a functional design and architectural document to match customer requirements.
  • Creates stored procedures and functions to incorporate complex database algorithms.
  • Writes and understands complex SQL queries for MYSQL, MS SQL and NoSQL databases.
  • Documents and maintains existing interfaces between applications, databases and third-party systems to meet business requirements.
  • Performs ad-hoc analysis of production data where necessary to develop solutions to reported incidents.
  • Communicates with the appropriate internal and external business and technical customers for information gathering and follow-up.
  • Designs and maintains schema and databases for MySQL, MS SQL and NoSQL.
  • Defines and implements data validation processes to ensure data accuracy.
  • Performs other duties as assigned and modified at manager’s discretion.

KNOWLEDGE, SKILLS AND ABILITIES:

  • Knowledge of, and experience with, SQL techniques and stored procedures in MySQL, SQL Server, and/or Oracle
  • Proficiency with relational databases, including structure design, ad-hoc SQL queries and stored procedures
  • Familiarity with ERD tools (Erwin, data modelers)
  • Ability to effectively query various database platforms to extract required information
  • Understanding of SQL optimization (proper indexing and ability to interpret execution plans)
  • Ability to understand business requirements and convert them into database designs
  • Proven ETL development skills (SSIS, Informatica, or equivalent ETL tool)
  • Advanced skills in Microsoft Office Suite products including Word, Excel, PowerPoint and Outlook, plus a variety of other word-processing, spreadsheet, database, e-mail and presentation software
  • Ability and willingness to travel locally, regionally and nationwide up to 10% of the time
  • Spoken and written fluency in English
  • This job requires use and exercise of independent judgment
Additional Job Description

EDUCATION AND EXPERIENCE CRITERIA:

  • Bachelor degree Computer Science, Management Information Systems (MIS), Mathematics or a related field OR additional experience above the minimum will be considered in lieu of the required education on a year-for-year basis required

  • A minimum of 3 years of ETL (Extract, Transform, Load) coding experience in relational databases

  • A minimum of 1 year of experience working with MySQL, SQL Server or any equivalent relational database systems

  • Experience analyzing and develop transactional and dimensional databases

  • Experience designing and implementing data solutions, including data modeling for databases that serve multiple transactional applications

  • Experience in relational database design, optimization and performance with commercial-grade databases such as MySQL; data dictionaries, data analysis and relational databases

Apply to Job