Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now


Job Title Senior ETL Developer
Location Lafayette, LA
Department Corporate / Administrative & Support
FLSA Status Non-Exempt
Reports to BI Team Lead

About our Business Intelligence Team

Do you love technology? We sure do! With over 4,000 employees and rapid growth in our future, there is no shortage of development challenges and opportunities in our company. You will be a part of a broad and varied IT ecosystem that is rapidly maturing. We work with a strong group who truly cares about proper development methods, continuous education, and personal growth and learning. Here are some of the benefits of a data scientist career at Acadian:

  • Active debate about software design
  • Frequent experimentation with tools and architecture
  • Education, training, and conferences
  • Focus on business intelligence working with dedicated IT support teams: Network, DBA, Infrastructure, Application Development/Analysts, Security, Service Desk, and Telecom
  • Professional, ergonomic, and custom office equipment
  • Employee gym down the hall
  • Weekly telecommuting and flexible scheduling
  • Dedicated office for your team

Most importantly, everything we do in IT directly contributes and supports the critical life-saving efforts provided by this company every day.

Job Description

The Senior ETL Developer would need to have at least 6 years of experience. This candidate will help work on a wide range of analytics, business intelligence, data warehouse initiatives. They will be primarily responsible for implementing ETL processes. 

The ETL Developer should be well versed in the design of ETL and database developments, as well as maintaining and supporting the production jobs. This candidate should be able to work collaboratively with other team members, as well as customers for operational support.


Primary Responsibilities

  • Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse
  • Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process
  • Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations
  • Documents ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance 
  • Integrates ETL development with existing projects to maximize object reuse
  • Create, execute, and document unit test plans for ETL and data integration processes and programs
  • Maintain the current build and deployment pipeline
  • Conduct performance tuning on existing ETL process and SQL queries
  • Troubleshoot data issues and defects to determine root cause
  • Keep up-to-date with latest technology trends
  • Communicate results and ideas to key decision makers
  • Interpret business requirements into technical and/or functional documentation and solutions
  • Understand and follow formal project methodologies and change control processes


Tools We Use

  • Visual Studio
  • SQL Server Management Studio
  • RedGate SQL Change Automation, TeamCity, and OctopusDeploy
  • Safari Books Online & PluralSight

Required Qualifications/Experience

  • Minimum 3 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools (SSIS)
  • 3+ years of experience working with high volume databases
  • Bachelor's degree in Computer Science, Information Systems or equivalent


Privacy Policy

CandidateCare ©2013-2019 powered by Avesta