Sr. Snowflake Developer

Apex Systems Smithfield , RI 02917

Posted 4 weeks ago

Job Description: Job #: 1019369

Apex Systems combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country.

Apex has an opportunity for a Sr. Snowflake Developer role in the Smithfield, RI area. This is a 6+ months contract position and the pay rate is flexible depending on experience. Here are the details:

For applicants who are interested in this Sr.Snowflake Developer opportunity; please send a Word resume to Katie Nasuti, Account Manager at [ Link Removed ]

Position: Sr. Snowflake Developer

Apex Job ID: 1019369

Location: Smithfield, RI

Rate: Negotiable Based on Experience

Duration: 6+ months contract position

We are seeking a Snowflake Developer to assist in the creation of a client Data Lake on an Amazon Web Services platform. The Business Intelligence group is responsible for designing, building and maintaining the operational and analytical capability for the business. The data infrastructure is going through significant growth, and this is an opportunity to take a contributing role in shaping the business capability in this area. This business has been tasked with building a Data Lake on Snowflake hosted on AWS. This is a multi-year initiative which starts with foundational buildout in 2019 followed by prepared and curated layers.

Responsibilities

  • Lead in the development, improvement and maintenance of database applications both as an individual contributor and as a team member

  • Designs batch cycle procedures on major projects using scripting and Control M

  • Performs functional analysis for major projects supporting several corporate initiatives

  • Acts as an expert technical resource across functional organizations and monitors performance of project plans

  • Works with IT partners and user community for project definition

  • Works on multiple platforms and multiple projects concurrently

  • Performs independent technical analysis, debugging and troubleshooting.

  • Performs code and unit testing for complex scope modules, and projects

  • Serves as a technical resource for others

  • Participates in rotating production support activities

Required Qualifications

  • Solid understanding of database engineering and design (Relational, De-normalized, Data Lakes, etc.)

  • Eight to ten years of Solid programming skills experience in database development (main focus is Oracle)

  • Hands-on experience with leading at least one Snowflake implementation

  • Strong Database experience in Oracle, Hadoop/Hive or DBMS (Snowflake, Netezza, NoSQL a plus)

  • Experience developing data ingestion processes using Kafka

  • Knowledge of AWS and Azure platforms

  • 3 or more years of Development experience Java a must, and experience developing Python (OR SPARK) based code that reads/writes data into databases

  • Comprehensive experience with database systems and related software

  • Experience with Control M (or similar job scheduling AutoSys)

  • Ability to read and interpret physical data models

  • Solid knowledge of DBMS optimizer and performance tuning techniques

  • Ability to translate requirement documents into technical solutions

  • Experience with CI/CD pipeline and SDLC

  • Knowledge of Agile development

  • Good communications skills in addition to being a phenomenal teammate

Preferred Qualifications

  • Developing ETL solutions (Informatica nice to have)
  • Experience working with off-shore environments and Financial Services will be a plus.

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 [ Phone number blocked ] -6178.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Snowflake Developer

Apex Systems

Posted 2 days ago

VIEW JOBS 11/16/2019 12:00:00 AM 2020-02-14T00:00 Job Description Job #: 1017792 Apex Systems combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country. Apex has an opportunity for a Snowflake Developer role in the Smithfield, RI area. This is a 6+ months contract position and the pay rate is flexible depending on experience. Here are the details: For applicants who are interested in this Snowflake Developer opportunity; please send a Word resume to Sierra Smith, Technical Recruiter at [ Link Removed ] Position: Snowflake Developer Apex Job ID: 1017792 Location: Smithfield, RI Rate: Negotiable Based on Experience Duration: 6+ months contract position We are seeking a Snowflake Developer to assist in the creation of a client Data Lake on an Amazon Web Services platform. The Business Intelligence group is responsible for designing, building and maintaining the operational and analytical capability for the business. The data infrastructure is going through significant growth, and this is an opportunity to take a contributing role in shaping the business capability in this area. This business has been tasked with building a Data Lake on Snowflake hosted on AWS. This is a multi-year initiative which starts with foundational buildout in 2019 followed by prepared and curated layers. Responsibilities * Participates in the development, improvement and maintenance of database applications both as an individual contributor and as a team member * Designs batch cycle procedures on major projects using scripting and Control M * Performs functional analysis for major projects supporting several corporate initiatives * Acts as an expert technical resource across functional organizations and monitors performance of project plans * Works with IT partners and user community for project definition * Works on multiple platforms and multiple projects concurrently * Performs independent technical analysis, debugging and troubleshooting. * Performs code and unit testing for complex scope modules, and projects * Serves as a technical resource for others * Participates in rotating production support activities Required Qualifications * Solid understanding of database engineering and design (Relational, De-normalized, Data Lakes, etc.) * Five to eight years of Solid programming skills experience in database development (main focus is Oracle) * Hands-on experience with at least one Snowflake implementation * Strong Database experience in Oracle, Hadoop/Hive or DBMS (Snowflake, Netezza, NoSQL a plus) * Experience developing data ingestion processes using Kafka * Knowledge of AWS and Azure platforms * 3 or more years of Development experience – Java a must, and experience developing Python (OR SPARK) based code that reads/writes data into databases * Comprehensive experience with database systems and related software * Experience with Control M (or similar job scheduling AutoSys) * Ability to read and interpret physical data models * Solid knowledge of DBMS optimizer and performance tuning techniques * Ability to translate requirement documents into technical solutions * Experience with CI/CD pipeline and SDLC * Knowledge of Agile development * Good communications skills in addition to being a phenomenal teammate Preferred Qualifications * Developing ETL solutions (Informatica nice to have) * Experience working with off-shore environments and Financial Services will be a plus. 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 [ Phone number blocked ] -6178. Apex Systems Smithfield RI

Sr. Snowflake Developer

Apex Systems