Careers

Added Oct 18, 2021 Data Engineer (22943) Nashville, TN | Contract Apply

Job Description

Looking for more than just another assignment? We're looking for you! This isn't just another assignment, but a real opportunity and a challenge for the right person. LRS Consulting Services is seeking a remote ETL/SSIS Developer for a long term contract opportunity with our client in Nashville, TN!

We are looking for a ETL/ SSIS Developer with experience in healthcare who has been responsible for building and maintaining a company’s data warehouse and ETL processes. This person will work closely with our software and application development teams, database administrators and analysts to recommend database structures based on the respective data storage and retrieval needs. The ETL Developer will be responsible for constantly monitoring our database and immediately addressing database issues.

What you will do:
  •  Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions
  • Analyze database implementation methods to make sure they’re aligned with company policies and any external regulations that may apply.
  • Create data monitoring models for each product ahead of new releases
  • Develop database design documentation.
  • Identify and adopt enterprise data architecture patterns, concepts, approaches, and solutions in support of business needs.
  • Develop logical and physical data models for complex projects using both relational and other modeling techniques and approaches
  • Understand and adopt emerging data technologies
  • Develop Extract, Transform, and Load (ETL) specifications and mappings to support data conversion and integration
  • Develop and maintain procedures for tracking data sources, data lineage, data quality, completeness, redundancy vs replication, data dictionary, data models, metadata and master data.

Requirements
  • Min 5 Years hands-on experience in ETL/SSIS
  • Develop SQL stored procedures, functions, views, tables, triggers, ETL packages etc.
  • Build SSIS packages for DW and Data Marts
  • Review requirements and give development estimates
  • Experience building complex SQL queries from highly normalized DW tables
  • Experience troubleshooting data issues
  • Debug ETL failures and provide RCA and fixes
  • Maintain clean testable code with the support of dev team and architects

Colorado salary range - $20/hr to $125/hr


LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status