Computer Aid, Inc.

ETL Developer

US-NY-Albany
Employment Type
Contract

Position Description/Responsibilities (CCC/Vendor)

Join a world leader in IT metrics and productivity! Computer Aid, Inc.  (CAI) is a full service Information Technology outsourcing firm with more than 30 years of experience and a world leader in IT measurement and IT productivity.

 

We are seeking an ETL Developer

 

LOCATION

 

This position is located in Albany, NY.  

 

  • Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts
  • Create and optimize queries for front-end and back-end applications
  • Design and develop views and stored procedures in support of system and information requirements
  • Contribute to the design of dimensional modeling schemas for a data warehouse
  • Identify and recommend solutions for database performance issues and optimization
  • Work with the Database Administrator to create and execute DDL scripts
  • Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
  • Recommend and establish optimum data access techniques; support database functions by designing and coding utilities and scripts; contribute to the creation and maintenance of an enterprise data dictionary
  • Work with key stakeholders on a disaster recovery plan
  • Maintain a high level of service by establishing and enforcing organization standards and following established change management processes
  • Continue to improve professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies
  • Foster and contribute to a culture of excellence grounded in listening, learning, problem solving, and teamwork 
  • Assist in the improvement and integration of automation and tools designed to support work and decision making
  • Effectively communicate, collaborate and problem-solve with relevant stakeholders
  • Perform other responsibilities as assigned

 

Expected Deliverables

  1. Tested ETL code
  2. Optimized queries
  3. Tested DDL scripts

 

Experience Level: mid-level to senior

The Contractor should be able to demonstrate the following skills

 

  • Four years of relevant experience as described above
  • A strong technical knowledge of Microsoft SQL Server (version 2012 or newer preferred)
  • Significant experience with SQL Server Integration Services
  • Strong scripting abilities utilizing various programming/scripting languages (T-SQL, VB Script, Powershell, Bat files, C#, etc.)
  • Experience developing ETL in a data warehouse environment
  • Experience with Tableau (preferred)
  • An understanding of Microsoft Windows Server 2008+, Active Directory, Windows networking (DHCP, DNS)
  • Strong ability to work in a team dedicated to creating systems that are user-friendly, enable easy self-service, and are scalable and flexible to support emerging strategic needs of NYSERDA
  • Demonstrated commitment to ongoing learning / ability to share and facilitate knowledge within a highly dynamic team.
  • Demonstrated problem-solving ability; an entrepreneurial edge, resourcefulness, adaptability, and an instinct for surfacing value and pragmatic solutions
  • As this contract may become a permanent position: Bachelor degree in information systems or related field and 4 years relevant work experience as a SQL Server Developer; or an unrelated degree and 6 years relevant work experience as a SQL Server Developer; certificates from recognized programs that indicate mastery of tools and techniques relevant to the assignment may substitute for up to six months of experience
  • As this contract may become a permanent position it is requested that all applicants be eligible for hire within New York State government at the time of submission.

 

 

 

 

 

 

 

Position Requirements/Technical Skills (CCC/Vendor)

 

 

 

 

Company Overview (CCC Only)

Computer Aid, Inc. (CAI) is an innovative solutions company managing engagements with numerous Fortune 1000 companies and government agencies. CAI is headquartered in Allentown, Pennsylvania with a staff of over 4,200 professionals working at locations around the world in a variety of industries.  Our services leverage technology to provide outstanding customer experiences that generate new value for our clients, our employees, and our greater communities. 
CAI is building a culture of continued learning, support, and personal development in a collegial environment. We also strive to make a positive impact on our surrounding communities through various outreach programs. We make a positive difference for our associates and the communities in which we serve.
Our mission: Provide industry-leading services and an incredible workplace for our associates, while making an impact on our communities.
CAI is an Equal Opportunity/Affirmative Action employer. Minorities, women, veterans and individuals with disabilities will receive consideration and are encouraged to apply.

For more information on our professionals, services, and industries we support, please see our website www.compaid.com.

Status of Your Application:

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed