CGI - Fairfax, VA
posted 3 months ago
CGI Federal is seeking a motivated and customer-oriented ETL Developer to support a large federal client. This role involves designing, implementing, and managing ETL processes and data integration to generate valuable business insights. The position is based in our Fairfax, VA office, with a hybrid working model acceptable. In this role, you will be responsible for the design and development of ETL processes to extract data from various sources, transform it according to business requirements, and load it into target databases or data warehouses. You will develop and maintain ETL scripts, stored procedures, and functions, ensuring data integrity, consistency, and quality throughout the ETL process. You will also generate new business insights through data extraction, storage, transformation, analysis, and visualization of diverse data sets. This includes analyzing data using data mining, machine learning, and statistical algorithms available in commercial off-the-shelf (COTS) tools such as SAS and SPSS, as well as building analytical solutions using programming languages like R and Python. Your responsibilities will also include collecting and transforming structured, unstructured, relational, and NoSQL data using ETL and ELT tools, and developing custom code using programming languages. You will need to understand and use distributed methods such as MapReduce that scale to multi-Terabyte sized data collections. Additionally, you will apply data discovery and data visualization tools like Tableau and Trifacta to develop compelling, actionable, and useful data stories. Collaboration with data subject matter experts, business stakeholders, and management will be essential to prioritize business and information needs.