Data Analyst

Data Analyst
MUST BE LOCAL to DC/MD/VA  Overview
DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, the U.S. Navy, state and local government and commercial clients in health care, technology, and financial services industries.
The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.
We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make your vision a reality.
Project Description
DRT is seeking a candidate with hands-on experience in data analytics and data visualization. Job Summary
The candidate will be highly skilled in conducting data mining, exploratory analysis, data engineering, predictive analysis, statistical analysis, and uses scientific techniques to correlate data into graphical, written, visual and verbal narrative products. The ideal candidate is familiar with creating reports, tables, figures, and geospatial visualizations to analyze flood insurance rating plans. The candidate will assist FEMA in validating geospatial and Catastrophic Modeling (CAT) inputs from multiple data sources to conduct risk rating analysis. Responsibilities
• Experience handling, manipulating, and analyzing large scale datasets with Python or R. This includes filtering data to discover trends, highlighting outliers, and presenting final products to the team and to leadership
• Demonstrate ability to manage large data projects in an effective and organized manner. This includes clean data management for future use by the team and others i.e. logical folder structures, consistent naming conventions, clear documentation of processes, etc.
• Demonstrate experience in processing large scale datasets to create histograms, charts, and other statistical visualizations of data to gain a better understanding of the data
• Ability to analyze and manipulate CSV data geospatially with desktop ArcGIS
• Experience handling raster and vector datasets; clipping, merging, intersecting, rasterizing, vectorizing etc.
• Experience exporting GIS layers for use by other team members
• Demonstrate an understanding of various Coordinate Reference Systems and possess experience transforming between different CRS formats
• Experience with the Python libraries GeoPandas, Shapely, Rasterio, GDAL
• Experience developing GIS visualizations with ArcGIS or QGIS to present informational map graphics such as heatmaps for point-based data and color ramps for Digital Elevation Models (DEMs)
• Experience creating and using virtual environments with Anaconda or something similar.
• Validate GIS inputs for CAT models
• Write scripts in Python to analyze various datasets
• Develop geospatial visualizations of rating plans
• Conduct analysis to draw insights from generate model outputs
• Conduct Fragility Curve Analysis using Phyton
• Investigate discrepancies between expected outputs
• Support annual rate reviews and development of appropriate rate and rule revisions, and revisions to actuarial statistical plans
• Provide catastrophic modeling support, including the design and review of models in support of various National Flood Insurance Program (NFIP) activities
• Ad-hoc exploratory analysis
• Cause of Loss statistical model building
• Prepare location data baskets for input into CAT models Required Experience
• Experience using desktop ArcGIS
• Proficiency in Python or R with emphasis in data science
• Proficiency in geospatial modeling, spatial statistics, and data analysis in Python
• Experience with geospatial libraries (GeoPandas, Shapely, Rasterio, GDAL)
• Statistical modeling experience
• Minimum of 3 years of experience with GIS data and geospatial visualization libraries
• Undergraduate-level knowledge of statistical and mathematical concepts required Preferred Experience
• Catastrophic Modeling experience a plus
• Experienced with SQL database querying and manipulation
• Demonstrate understanding of Generalized Linear Models (GLMs)
• Possess an understanding of mathematical and statistical concepts used to gain better understanding of datasets; mean, standard deviation, variance, etc.
• Experience using R (preferred) and/or SQL software for data analysis
• Knowledge and understanding of catastrophe models (highly desirable)
• Proficiency with Microsoft Office (Excel, Access), VBA, and other programming languages is a plus
• Experience with vector and raster geospatial data Education and Training
• Bachelor's degree in a related quantitative field (e.g., mathematics, statistics, engineering, economics, computer science, data science)
DRT's culture is reflective of our core values: Professionalism:  Be a leader and someone your customers and colleagues can count on by taking ownership and accountability for your work. Demonstrate a solution-oriented mindset and bias for action. Show empathy, dignity, and respect for each other. Be "high minded", maintain a calm demeanor when dealing with ambiguity or adversity and stay out of the fray (i.e., avoid drama). Quality:  Do things right and do the right thing. Pursue excellence in your work by delivering quality services and products that provide high value and return on investment (ROI). Teamwork:  Work with each other, the customer, and DRT. Demonstrate flexibility, a positive attitude and willingness to work collaboratively to help others and share information. Customer Mission Focused: Commit to customer success and strive to exceed expectations by understanding the mission, executing the customer's vision, and solving challenges to drive results and achieve mission goals. Build meaningful customer relationships by asking thoughtful questions, listening, and operating transparently. Growth Mindedness:  Commit to company, team, and personal growth. Embrace an entrepreneurial spirit by actively seeking opportunities to support new customer projects and/or solve problems. Actively work to improve your skills, learn to be comfortable with ambiguity, and be resourceful and willing to figure things out and add value. Our culture fosters teamwork and transparency, empowering you to do great work. Our talented employees drive the success of the company – so our leadership is devoted to your success.  We respect you as an individual.  We recognize your contributions.  We invest in your professional growth.  Join us and let's continue to build your career together.
Currently due to the remote working status of the federal government, most DRT employees are teleworking from home and leveraging video conferencing along with other virtual productivity tools. Under normal circumstances, most of our positions are required to report onsite. However, DRT has not yet determined when employees will be required to return to their onsite workspaces. Please be aware that at the time a date is determined to return to the worksite, the requirement of this position may be to report in person to the work location.
DRT Strategies, Inc. (DRT) celebrates diversity and is proud to provide Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetics, disability, or protected veteran status. In addition to federal law requirements, DRT complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.