19 days old

ETL Developer

ROXBURY CROSSING, MA 02120
  • Job Code
    580402
  • Payrate
    $50 To $55

The person will leverage Data Integration tools such as SAS Data Integration Studio to integrate data into CLIENT's data resources for use with internal dashboards, reports and scorecards, as well as for adhoc analyses. The person will have responsibility for administering the ETL server environment, including building and managing ETL jobs, job scheduling, and monitoring system performance. The incumbent will have a good understanding of data warehouse implementations as well as possess good data analysis, and SQL skills. This person will take on project management responsibilities to manage the development and implementation of new features and functions for projects that are small to medium in size. This person will need to work independently as well as part of a collaborative team.


Skills and Abilities



  • Two (2) or more years of experience as an ETL developer or similar role working with complex SQL queries and extracting data.
  • Proven analytical and problem-solving skills, along with strong written and verbal communication skills.
  • Experience with relational database management systems (RDBMS), and an understanding of relational database design.
  • Excellent written and oral communication skills
  • Proven ability to pay attention to details in a fast-paced environment with multiple initiatives. Keeps track of various deadlines and is consistent in meeting them.
  • Ability to be flexible, versatile and adaptable in day to day activities conducted in a fast-paced environment.


Principle Duties and Responsibilities



  • Develop and maintain data integration/ETL jobs in order to deliver information requests and deepen the analytics capabilities of CLIENT operations, fiscal, and administrative staff.
  • Triage, troubleshoot and resolve data issues from end users and internal team members.
  • Develop and maintain standards pursuant to CLIENT's architecture, report documents, dashboards, cubes, and other data warehousing development practices.
  • Create and/or perform peer review of Business ETL code from other analysts and programmers to ensure that all code and processes conform to CLIENT and DSS standards and guidelines.
  • Create and execute test plans and test scripts for unit and system testing of ETL code and reports, based upon requirements specifications.
  • Develop and enforce change management and versioning processes surrounding new releases of ETL jobs and evaluate and recommend new tools and methodologies to assist with change and version management.
  • Migrate ETL job changes between development, test, training, and production environments and maintain a proper development cycle.
  • Assist with performing upgrades of CLIENT's data environment when necessary.
  • Assist with performing change impact analysis on code changes in order to assist with estimating level of effort required for code changes and testing.
  • Review current operational data structures and data flows and recommend optimizations and opportunities for automation.
  • Evaluate and recommend new tools and methodologies to assist in meeting business requirements through data integration and reporting.
  • Provide training to DSS team and end-users on key analytic and reporting systems and databases when necessary.


Qualifications



  • Must have a bachelor's degree preferably in the area of management information systems or similar; masters degree is beneficial.
  • Must possess strong oral and written communication skills.
  • Must be capable of working independently with limited to no supervision.
  • Must possess a strong background in data warehousing projects relative to data integration, showing progressive experience in this area.
  • Must be able to identify, triage, and resolve or dispatch issues.
  • Must be willing to contribute to and foster a team player culture where all are encouraged and willing to share information accurately.
  • Experience with ETL tools such as SAS, Informatica, Data Stage, and Ab Initio are a plus
  • Must possess strong data analysis skills and be able to perform data analysis using SQL, SAS or similar query languages
  • Working knowledge of HTML, ASP (1.0) and ASP.NET(1.0, 2.0) using Vb script and Java script is a plus, but not required
  • Experience in Health Care a plus, but not required

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

ETL Developer

Randstad Technologies
ROXBURY CROSSING, MA 02120

Share this job

ETL Developer

Randstad Technologies
ROXBURY CROSSING, MA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast