Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

ETL Developer

Expired Job

CTG Madison , WI 53701

Posted 4 months ago

CTG has a new opportunity for an ETL Developer. This is a DIRECT HIRE position with our HealthCare client.

The ETL Developer is responsible for the development, enhancement and effective operations of data movement between various systems using ETL methodologies. Responsible for leading company database development efforts and coordinating with business users, 3rd party data providers, and internal developers to maximize the usage and value of company data assets.

Location: Madison, WI

Develop, maintain and administer system databases and EDW
Create logical links between databases to create an Enterprise Data Warehouse. This may be accomplished by utilizing various SQL tools.
Design, implement, maintain, and deploy SSIS packages.
Functions as a primary contributor in designing, coding, testing and debugging ETL to create a seamless data flow.
Supports overall strategy as it relates to database and data warehouse development.
Monitor, troubleshoot and analyze ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical staff, and end-users. Effectively communicate findings.
Performance tune in-house and third-party databases as required. This will include creating and re-organizing indexes, optimizing job schedules, and creating stored procedures and functions.
Plan, define, and create new databases using database normalization techniques.
Set up and maintain user security for databases and connected applications.
Interact with IT staff, and vendor support personnel to define and resolve systems-related problems.
Track and document actions and results in accordance with IT change control methodology.
Work closely with Project Managers, Programmers, and Web Developers to ensure a high level of database integrity.
Actively participate with IT staff in preparing and implementing backup and disaster recovery procedures and processes of mission critical databases.
Analyze and implement techniques to optimize system utilization, database performance and maintain established service levels.
Work with business units/data owners to classify database data for appropriate security, backup, and performance characteristics.
Generate automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the data warehouse.
Create database code requirements for all data warehouse data migrations and business unit and SQL-server projects via programming and the various SQL languages.
Identify and resolve data integrity issues between the data warehouses and the original data sources.
Create and maintain data dictionaries and database diagrams for complex in-house databases.
Provide on-call support for problem resolution of database-related issues.


Bachelors degree in Computer Science, Engineering, MIS, or comparable work experience
5+ years of relevant experience with computers, computer systems, and servers.
Expert SQL Server knowledge of T-SQL and OLTP topics such as normalization, data types, query tuning, indexing, constraints, and query plans, etc.
Experience with SQL 2008+
Experience with SSIS and ETL development required
SQL Reporting Services (SSRS) or comparable reporting tools experience.
Experience with Healthcare analytics and EDI.
Experience with software deployment, version control, and build automation preferred. Competencies


To be considered for this opportunity apply to this requisition using the link provided. For additional information please contact Kim Pilik at or .

CTG (NASDAQ: CTG) provides industry-specific IT services and solutions that address the business needs and challenges of clients in high-growth industries in North America and Western Europe.

CTG also provides strategic staffing services for major technology companies and large corporations. Backed by more than 50 years of experience and proprietary methodologies, CTG has a proven track record of reliably delivering high-value, industry-specific staffing services and solutions to its clients. CTG has operations in North America, Western Europe, and India.

CTG's greatest asset is its people, and as such, we are committed to providing employees programs and processes to support their performance, hone their skills, and advance in their careers. This commitment is reflected by CTG being named a Best Places to Work in Healthcare company by Modern Healthcare (2013-2016) in North America, and a Best Workplace in the United Kingdom (2013), Belgium (since 2007), and Luxembourg (since 2011).
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity/Affirmative Action Employer and strong advocate of workforce diversity. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

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
Business Objects Developer I (14250)

Sundial Software

Posted 2 days ago

VIEW JOBS 12/14/2018 12:00:00 AM 2019-03-14T00:00 <p><strong>Sundial Software is currently recruiting for a Business Objects Developer for a one year minimum contract with annual renewal.</strong></p><p><strong>Data Warehouse Developer I (14250) Description</strong></p><p>This contract position in the DCF Business Intelligence Section will provide advanced Business Objects universe design and report development expertise for our divisional customers. An advanced skill set in Business Objects universe design and report development is required. This individual will follow standards to design, develop, test and implement reports and documentation. The selected contractor is required to show proof of experience in designing and implementing Business Objects universes and reports. Preference will be given to qualified candidates with Xcelsius and/or Dashboard 4 experience. <br /><br />The individual in this position will: <br /><br />&bull; Be responsible for development and support of enterprise level applications using Business Objects. <br />&bull; Work with enterprise wide business and IT senior management to understand reporting and data analysis needs. Work with customers gathering requirements for reports and dashboards. Have extensive experience working with WebI Business Objects tool. <br />&bull; Be principally responsible for designing Business Objects universe layer for business intelligence solutions. Optimize the performance of Business Objects applications. <br />&bull; Have mastery level understanding of Business Objects security administration. <br />&bull; Have expert level knowledge of Business Objects universe configuration (parameter settings, etc.) and universe design aspects (loops, contexts, aliases, cardinality, etc.) <br />&bull; Work interactively with both technical and non-technical staff to build Business Objects universe layer that adheres to underlying data model and effectively delivers data to end users. <br />&bull; Have extensive experience in working within a Business Intelligence environment and knowledge of data warehouse dimension database design <br />&bull; Stay abreast of releases / patches for Business Objects. Act as Business Objects subject matter expert for fellow technologists as well as end users. <br />&bull; Understand logical and physical data modeling and methods for optimizing the Business Objects universe against the physical model. <br />&bull; Typically have 3 to 5 years of experience with enterprise level database management systems, business intelligence tools and systems. </p> Sundial Software Madison WI

ETL Developer

Expired Job