Sr SQL Developer

Summary Come join a company that strives for Extraordinary People and Exceptional Performance! Chenega Professional & Technical Services, LLC., a Chenega Professional Services’ company, is looking for an experienced and motivated Senior SQL Developer to be part of DEA’s enterprise data warehouse development team. You will work in a collaborative team environment to design, develop and enhance DEA’s enterprise data warehouse. Our company offers employees the opportunity to join a team where there is a robust employee benefits program, management engagement, quality leadership, an atmosphere of teamwork, recognition for performance, and promotion opportunities. We actively strive to channel our highly engaged employee’s knowledge, critical thinking, and determination to innovate scalable solutions for our clients.  Responsibilities Responsible for SQL Script development and creation of SSIS packages for ETL work. May write reports or facilitate data access by other means as needed, to include SSRS, PowerBI, etc. Conducts performance tuning and database design, dimensional analysis, and modeling. Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) data manipulation. Maintain, enhance, and create enterprise and application-level SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools. If requested, the EDW team will leverage SQL Server Analysis Services (SSAS) for performance purposes. Supports the review of database systems from non-Concorde applications in other DEA offices Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions. Other duties as assigned. Qualifications Required to adhere to all government agency guidelines as it applies to COVID vaccine Attestation/Restrictions. Bachelor’s degree in IT, Computer Engineering, or a related discipline. Minimum of eight (8) or more years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, packages and triggers. Minimum of two (2) or more years of experience with SSIS packages for data manipulation and loading. Minimum of two (2) or more years of experience with the latest SQL Server environment, (2012 or newer). Demonstrated ability to work independently and with others. Knowledge of, and experience within, an Agile development environment. Knowledge of, and ability to use, MS Team Foundation Server or Azure DevOPs Ability to write efficient SQL queries as well as demonstrated ability to interpret legacy scripts. Knowledge of, and prior experience with multi-dimensional data models. Ability to create reports with a solid understanding of a variety of BI data tools. Knowledge of, and prior experience with SSIS. Knowledge of Kimball data warehouse methodology highly desired. Knowledge of, and prior experience with Git and Python. Demonstrated ability and desire to learn new technologies. Teleworking Permitted? Yes Teleworking Details 50% telework.