It Engagements - Washington, DC
posted 3 months ago
Hi Greeting from IT Engagements. We IT Engagements is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. We have an immediate opening for the below position with one of our premium clients. The position is for a Senior ETL Developer located in Washington, D.C. This is a long-term contract role that requires extensive experience working with crime data from the PremierOne CAD/RM system. The Senior ETL Developer will be responsible for developing, building, and maintaining reports and data from the CAD/RMS system using SSRS (SQL Server Reporting Services) and ETL (Extract, Transform, Load) processes. The role involves modernizing and transforming data to enhance the usability of reports and dashboards. Key responsibilities include designing, developing, and maintaining SSRS reports based on business requirements, building ETL processes to extract, transform, and load data from various sources into a data warehouse or data mart, and collaborating with business analysts and stakeholders to gather and analyze reporting requirements. Additionally, the developer will create and optimize SQL queries and stored procedures for data extraction and transformation, develop and implement data cleansing and validation processes to ensure data accuracy and integrity, and design and implement data models and schemas to support reporting and analytics needs. Monitoring and optimizing SSRS report performance and data loading processes, troubleshooting and resolving issues related to SSRS reports, ETL processes, and data quality, and documenting technical specifications, data mappings, and ETL workflows are also critical aspects of this role. The Senior ETL Developer will provide technical support and training to end-users on SSRS reports and data access tools.