Systems Architect V

Summary Come join a company that strives for Extraordinary People and Exceptional Performance! Chenega Professional & Technical Services, LLC., a Chenega Professional Services’ company, is seeking a Systems Architect V to provide Enterprise Data Warehouse (EDW) support to the Office of Information Systems (SI) within the Drug Enforcement Administration (DEA). The Systems Architect V will serve as the lead for Data Modeling and Dimensional Analysis to support the design, development, and maintenance of DEA’s SQL Server-based EDW. 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 EDW development and operational support Provide technical support and guidance to other team members to include Sr. SQL Developers and Consultants. Follow Agile Scrum methodology to maintain the databases and generate scripts to load and retrieve data content. Develop scripts. Perform database support activities. Conduct performance tuning and database design, dimensional analysis, and modeling. Maintain and add to an extensive set of SSIS packages for ETL data manipulation. Maintain, enhance, and create enterprise and application-level reports using SSRS and other BI tools. Other duties as assigned. Qualifications Required to adhere to all government agency guidelines as it applies to COVID vaccine Attestation/Restrictions. Active Secret Clearance is required. Minimum of 15 years of experience in Dimensional Analysis in a Kimball Style Enterprise Data Warehouse of not less than 500 total tables and 100 million rows of data. Minimum of 10 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 3 years of experience with SSIS packages for data manipulation and loading. Minimum of 2 years of experience with the SQL Server 2012 environment. Effective communicator with all levels of stakeholders to include DEA executives and senior managers. Ability to work independently and part of a team. Excellent oral and written communication skills. Knowledge of, and prior experience with Git and Python. Demonstrated ability and desire to learn new technologies. 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 Kimball multi-dimensional data warehouse methodology highly desired. Ability to create reports with a solid understanding of a variety of BI data tools. Knowledge of, and prior experience with SSIS. Teleworking Permitted? Yes Teleworking Details 50% Telework: 3-days 1st week, 2-days 2nd week