BCforward - Richmond, VA
posted 4 months ago
BCforward is currently seeking a highly motivated ETL Developer for an opportunity in Richmond, VA. The ETL Developer will play a pivotal role in managing data extraction, transformation, and loading processes. This position involves developing, implementing, and maintaining change control and testing processes for modifications to databases. The ETL Developer will also be responsible for developing and maintaining database stored procedures, views, and functions that support reporting data models, as well as producing ad-hoc queries to develop reports that support business needs. In this role, the ETL Developer will coordinate with team members to set up audit processes and develop mappings using Java transformations. Performance tuning, query tuning, and data profiling are also key responsibilities. The ETL Developer will contribute to the planning of work programs and review, develop, and modify best practices and technical solutions. Additionally, this position provides supervision to a team of Developers, managing work assignments of internal staff and ensuring adherence to procedures, protocols, and standards. The ideal candidate will have deep knowledge of coding languages such as Java, XML, and SQL, along with solid project management skills. They should be well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW. The ETL Developer must be adept at writing complex SQL queries, using data transformation functions, and applying business logic to cleanse, aggregate, and format data. Handling data quality issues and ensuring the integrity of the data throughout the ETL process is also crucial. Strong analytical thinking and troubleshooting skills are essential for the proper functioning of the system.