Trail Blazer Consulting - Washington, DC
posted 3 months ago
The Senior ETL Developer position is focused on leveraging advanced ETL (Extract, Transform, Load) processes and SSRS (SQL Server Reporting Services) to build and maintain reports and data from the CAD/RMS system. The ideal candidate will be responsible for modernizing and transforming data to enhance the usability of reports and dashboards, ensuring that the data is accurate, reliable, and accessible to stakeholders. This role requires a deep understanding of data warehousing concepts and the ability to design, develop, and maintain SSRS reports based on specific business requirements. In this position, the Senior ETL Developer will collaborate closely with business analysts and stakeholders to gather and analyze reporting requirements, ensuring that the solutions developed meet the needs of the organization. The role involves building ETL processes to extract, transform, and load data from various sources into a data warehouse or data mart, as well as creating and optimizing SQL queries and stored procedures for effective data extraction and transformation. Additionally, the Senior ETL Developer will be tasked with developing and implementing data cleansing and validation processes to ensure data accuracy and integrity. They will design and implement data models and schemas that support reporting and analytics needs, monitor and optimize SSRS report performance, and troubleshoot any issues related to SSRS reports, ETL processes, and data quality. Documentation of technical specifications, data mappings, and ETL workflows is also a critical part of this role, along with providing technical support and training to end-users on SSRS reports and data access tools.