IT Operations - Data Integration Engineer

Virtual Req #622
Saturday, April 17, 2021

More than 48 million Americans have some form of hearing loss. ClearCaptions service and equipment removes communication obstacles through its commitment to making lives better and adhering to the belief that every word matter. As a Federal Communications Commission (FCC) certified telephone captioning provider, ClearCaptions follows the highest industry standards for privacy, security and professionalism on all of our captioning calls. ClearCaptions is dedicated to developing fast, easy and life-changing communications for hard-of-hearing individuals.

Data Integration Engineer

This position will be a key role in helping to build the infrastructure that will allow data exchange between applications and databases within the company as well as transfer data to and from external sources.   The Data Integration Engineer will ensure data integrity and process consistency while maintaining efficient data integration solutions.  This role will be responsible for analysis, design, documentation, unit testing, and support of data integration and database objects development.

 

This position will be based out of our Corporate Headquarters in Roseville, CA.

 

Responsibilities:

  • Work with 3rd party data providers and APIs to pull data into Microsoft SQL Server
  • Write, test, and troubleshoot complex SQL queries, stored procedures, and ETL processes.
  • Ensure a high degree of data quality from end to end across integrations.
  • Maintain and support existing ETL process
  • Help migrate and build our data flow architecture in the cloud
  • Write and maintain documentation on integration processes and execution procedures
  • Participate in the design and execution of governance activities associated with ensuring data solutions architecture assurance and compliance

Qualifications

  • 5+ years Microsoft T-SQL and Microsoft database technologies (strong knowledge of stored procedures, ETLs, complex queries & joins, and user-defined functions)
  • 3+ years Data Integration technologies and principles with a strong knowledge of SSIS package development, deployment, and troubleshooting
  • Solid software development and programming skills in a programming language such as Python, C#, Java, Javascript, etc.
  • Experience with Microsoft Excel
  • Experience with REST and other web API and data transmission technologies
  • Excellent communication skills, both verbal and written.
  • Advanced problem solving and analytical skills.
  • Experience using version control systems (GIT, SVN, TFS, etc)
  • Python programming language experience
  • Experience with real-time data streaming technologies
  • Experience with Azure data services

  Preferred Skills

  • Experience in telecom or call center industry
  • N1QL, Couchbase, Apache Kafka, AWS, Salesforce, Talend

 

Physical Requirements:

Employees may experience the following physical demands for extended periods of time:

  • Sitting, standing and walking (95-100%)
  • Keyboarding (40-60%)
  • Viewing computer monitor, tablet and cell phone screen requiring close vision (40-60%)

Work Environment:

Work is performed in a business office environment.

Compensation:

A competitive compensation package will be offered to successful candidates.

 

 

Disclaimer:

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications
required of employees to this job.

 
ClearCaptions is an equal opportunity, at will employer and does not discriminate against any employee or applicant for employment because of age, race, religion, color, disability, sex, sexual orientation or national origin. 

 

Other details

  • Pay Type Salary