Data Engineer

Company:
Location: Saint Petersburg, FL 33701

*** Mention DataYoshi when applying ***

Data Engineer

Who You Are and What You'll Do:

As a Data Engineer, you will work as part of the data services team, and report to Director, Data Management. You will be primarily responsible for implementing ETL/ELT processes that populate Kimball-style star schemas, using a variety of source data on multiple data warehouse implementations supporting a product. You will also participate in the requirements-gathering process, and assist with designing the business processes and dimensional models.

Strong Data Engineer candidates will have a deep understanding of both OLTP and star schemas (with OLAP specifically being a huge advantage). Further, they will conduct deep analysis on source data to determine the feasibility of using this data to solve business needs. The resulting processes should be scalable, efficient, audited and as re-usable as possible.

Your Day to Day:

  • Production support
  • Develop, design, tune and maintain ETL/ELT processes
  • Design and develop stored procedures, functions, views and triggers to be used during the ETL process
  • Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball-style dimensional models
  • Write scripts for automated testing of data in the target facts and dimensions
  • Capture audit information during all phases of the ETL process
  • Write and maintain documentation of the ETL processes via process flow diagrams
  • Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues
  • Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables
  • Collaborate with business users, other data services team members, and other developers throughout the organization to facilitate everyone's understanding of issues that affect the data warehouse
  • Query optimization

Knowledge, Skills and Experience to Be Successful in This Role:

  • 3-5 years of experience with data warehousing and business intelligence projects
  • 5+ years of experience with relational databases (SQL Server or Oracle)
  • 3-5 years of experience with SSIS
  • Experience pulling data from a variety of data source types (Postgres a plus)
  • Dimensional modeling experience preferably with a modeling tool such as Toad Data Modeler, ERwin, Embarcadero, ER/Studio Data Architect etc.
  • Experience working with large data sets, tables containing greater than a billion rows
  • Experience developing SSIS packages to load slowly changing dimensions
  • Experience supporting and troubleshooting production ETL process issues
  • Strong experience working with T-SQL and query optimization

Additional Knowledge, Skills and Experience That Will Help You Stand out as a Candidate:

  • Familiarity with the Kimball lifecycle
  • Experience with OLAP is strongly preferred. SSAS and DAX knowledge is highly desirable
  • Big Data experience a plus
  • Cloud experience with Azure or OCI
  • Experience with SQL 2017-2019 and the Microsoft BI stack
  • Snowflake
  • Oracle 12c and above
  • Python

*** Mention DataYoshi when applying ***

Offers you may like...

  • BairesDev

    ETL + Data Engineer - Remote | REF#7363
    Salvador, BA
  • Trustly

    Senior Data Engineer
    Vitória, ES
  • HILLEBRAND Personalberatung

    Senior Data Engineer (m/w/d)
    Wien, W
  • Segula Technologies

    Data Analyst / Data Engineer - Funktionale Entwick...
    Graz, ST
  • Personalservice Plus GmbH

    Data Analyst/Data Engineer – Funktionale Entwicklu...
    Graz, ST