Senior BI/ETL Director Posted Aug 12
iStaff , Duluth, GA
Looking for an Innovative Company? Here's an amazing and unique opportunity where a 100-year-old company goes mobile and is seeking a Sr. ETL Developer. Great company culture, benefits, strong employee retention, cutting edge technologies, and an opportunity to come in and grow.

This is a direct hire opportunity and an absolutely fantastic benefits package awaits including low cost insurance premiums, matching 401k, lucrative PTO and much more including a flexible and family-friendly atmosphere.

As a member of the Data Architecture and Reporting team, the BI/DW ETL Developer is responsible for loading the brand-new data warehouse efficiently. The developer is responsible for data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs. This role includes analysing and understanding the data transformation rules required to extract and transform and load the new Data Warehouse. The developer is responsible for ETL automation and developing the framework to include restartability, error handling, notifications, etc. This position works closely with other DAR team members and other IT functional teams to analyze, create, implement, and support ETL mappings.


Design the system components for the extract/transform or conversion of data from source systems to the target application

Design system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target application

Construct the extract/transform, transfer and audit components of a data warehousing system or data conversion programs through the use of extract development tools or custom developed procedures

Define and manage the data load procedures; facilitate the change data capture

In addition to developing new mappings/ETL jobs, also responsible for automation, monitoring and supporting mappings, and re-designing if required to make them run faster and more reliable

Develop a framework which can scale from batch based ETL to event-driven ETL architecture

Handle XML and web service as data source in ETL jobs

Define and implement ETL development standards and procedures

Define and implement ETL tool configuration

Ensure ETL quality through inspections and knowledge sharing

Strong analysis and design skill

Strong experience with Business Intelligence and data warehousing design principles and industry best practices.

Deep understanding of relational database design concepts and SQL programming


Hands on working experience of at least 5 years' experience working with data profiling tools like Information Analyzer or Informatica Data Explorer and/or other ETL tools

Ability to design and develop complex ETL mappings, sessions, workflows and identify areas of optimizations

Ability to read and/or design logical and multi-dimensional data models

Experience with MS SQL Server 2016

Strong communication skills (both oral and written) and the ability to work effectively in a team environment are required

Experience with relational, multidimensional and OLAP techniques and technology


A degree in Computer Science, a related discipline, equivalent work experience of 5+ years overall IT or the equivalent combination of education, training and experience from which comparable skills can be acquired

To expedite review of your Resume, when submitting for this position, please ensure your Resume highlights the above duties/qualifications that you legitimately have experience in/possess and email directly or through this job board. For fastest consideration, please do NOT apply through the iStaff website.

ABOUT iStaff:

Founded in 1995, iStaff offers combined experience of over 30 years of industry experience and demonstrated success in our IT recruiting and sales staff that has the expertise to source candidates with unique and hard to fill skill sets. Headquartered in Atlanta, GA, our IT recruiting division focuses on contract, contract to permanent and permanent placement opportunities on a national basis.

Employment Type: Permanent
Work Hours: Full Time

Pay: $115,000 to $125,000 USD
Pay Period: Annual

Click here to apply - Please mention that you saw the job on DotnetThread