Sr. Data Engineer

Location: TAMPA
Category: Technical Support and Services
Employment Type: Contract
Job ID: 16060
Date Added: 12/12/2023

Apply Now

Fill out the form below to submit your information for this opportunity. Please upload your resume as a doc, pdf, rtf or txt file. Your information will be processed as soon as possible.

* Required field.
Job Purpose: Provide an overview of the responsibilities of the job by providing a summary of the most important aspects and duties of the job (1-3 sentences).
 The Data & Analytics Team is seeking a passionate Senior Data Engineer to lead the technical design and development of the enterprise data eco-system.  This person will be responsible for scoping new architecture, leading and guiding data engineers in development and implementation of robust and scalable enterprise data solutions to support current & future initiatives. This individual will not only work hands on with the data engineering team, but will also be responsible for the designing and implementation of solutions that proactively manage and monitor the data ecosystem of analytics, data lakes, warehouses, MDM platforms, and other tools.
Direct Reporting Relationships: List other jobs in the company that report into this position.
  • Direct Reports? Yes ?  No  ?
  • This position will not have direct report reports under their supervisory organization.  This is expected to grow as we build out the data and analytics practice.
Main Responsibilities and Accountabilities: List the 4-8 essential functions of the job.
 
  • Review requirements and design data architectures based on the standards set by the manager which drive data strategy implementation and transform business strategies into information architectures.
  • Design, implement, and train the data engineering team members on strong and measurable processes, tools and engineered data management solutions to support all data platforms – such as data warehouse, lakes, visualization tools, master data management, and advanced analytics tools.
  • Developing, deploying, scheduling, and maintaining the data pipeline workflows to move data from multiple source systems to the cloud data warehouse.
  • Review business requirements and provide appropriate levels of effort to leadership that provide guidance on capacity planning and concise tasks to the team on how to implement appropriate schema and data models.
  • Creating the data ingestion framework for Snowflake for both full and incremental data loading from different source systems.
  • Further develop current cloud data warehouse (Snowflake) with both structured and un-structured data.
  • Developing dbt models and macros using SQL and Jinja languages with best practices to extract, load, and transform the data for medium to large enterprises using Snowflake.
  • Tune ETL for maximum performance.
  • Data Profiling, Data Cleansing, and Data Auditing.
  • Loading large volumes of data.
  • Decoding and writing complex SQL queries.
  • Performance tuning of queries and data loading process.
  • Modeling normalized and de-normalized data structures.
  • Ensure best practices are established and built into SOPS.
 
 
Minimum Qualifications and Experience Requirements: Provide hiring requirements necessary to successfully perform this job; indicate required and preferred levels for each category below.

Education
 
  • A bachelor’s or master’s degree in business administration, computer science, data science, information science or related field, or equivalent work experience.

Experience
 
  • Programming (SQL) – 8 or more years
  • Data Management Concepts (Data Extraction, Cleansing, Transformation, loading, Validation, Migration, Modelling, RDBMS concepts) – 8 or more years
  • Snowflake – 4 or more years
  • ETL (dbt, SSIS) – 4 or more years
  • Azure Architecture & Services (Blob Storage, Data Factory, Data Lake, DevOps) – 4 or more years
  • Git Hub – 4 or more years
  • Data Visualization Tools (Power BI, Tableau) – 4 or more years

Certifications/Designations
 
 
  • Manufacturing industry experience, a plus
  • Experience pulling and merging data from multi-ERPs/source systems, required
  • SSIS Experience, required
  • Extensive design and development experience in Data warehouse and data marts
  • Snowflake SnowPro Core Certified required
  • DBT experience required
  • GIT Hub experience required
  • Azure Data Factory Experience required
  • Microsoft Azure Data Fundamentals Certified
  • Experience making data usable to the end users
  • Experience working in a complex data environment.
  • Agile Delivery Experience, a plus