MDW Associates is seeking a Data Scientist to support the US Postal Services Inspector General's Office (OIG). The successful candidate will work to design and build large dataset Artificial Intelligence, Machine Learning and Data Analysis tools, and solutions.
This position is on-site 4 days a week at our USPS customer site in Arlington, VA.
The Data Scientist may perform a combination of some or all of the following duties:
- Work independently and within teams to use the necessary data extraction, manipulation, and aggregation techniques to prepare, clean, normalize, and validate data to complete varied projects and tasks.
- Research, design, and develop visualization solutions using a range of methods which support investigative and audit products.
- Design experiments, tests hypotheses, and build scalable models using data science and artificial intelligence (e.g. machine learning) methods.
- Design, develop, and adapt mathematical, statistical, econometric, and other analytical solutions for audit, investigation, research, and support functions.
- Lead artificial intelligence activities such as natural language processing, predictive analytics, and machine learning model development, training, evaluation, testing, refinement, deployment, and maintenance.
- Translate complex technical findings into an easily understood narrative.
- Prepare comprehensive documentation for requirements, test plans, user manuals, technical diagrams, and training materials.
- Develop project communications and maintain effective working relationships between project teams, stakeholders, and management.
- Provide advice on issues affecting projects, such as data access, quality, storage, and other related needs.
- Contribute to and present training and conference materials to large audiences.
- Independently perform comprehensive and efficient data collection and analysis of a variety of data sources to develop trends, descriptive statistics, or other insights.
- Use expert level knowledge to identify and develop sources of information from structured and unstructured data, criminal intelligence databases, public information sources, internal Postal Service databases, reference manuals, and audit and law enforcement reports.
- Independently research, extract, evaluate, interpret, and visualize data and information as actionable intelligence for auditors and investigators to detect, prevent, and respond to fraud, waste, and abuse.
- Use relational databases, data lakes, data lakehouses, and other data environments to create a variety of analytic products such as business intelligence tools, summary tables, comparison graphs, or temporal, association, and link analysis charts.
- Interact with other agencies and build relationships with peers to share information and learn the latest developments in analytical tools and techniques to effectively support the OIG with mission related work.
- Develop substantial knowledge of database applications and environments and share expertise with coworkers in support of agency goals and objectives.
- Perform analysis of data for Extraction, Transformation, and Load (ETL) strategies, pattern recognition, and application of analytical tools.
- Review, analyze, and modify existing products including coding, debugging, testing, and documenting.
- Provide guidance to coworkers on business and technical issues affecting projects, such as data access, data quality, storage capacity, and analytic tools and software.
- Assist with training and conference development which may include presentations to large audiences.
- Facilitate between business owners and end-users who need to communicate with database administrators and traditional IT support staff.
- Ensure that quality/security guidelines are followed.
- Coordinate with staff and customers to identify business and technical requirements.
- Produce written documentation and artifacts for all work completed, including the translation of user requirements into technical designs.
- Assist the organization in the development of programming and visualization solutions.
- Troubleshoot and provide support on existing projects or application efforts.
- Engineer data analytic solutions, including prototyping, proof of concept, and full implementation.
- Evaluate, assess, document, and test data security and continuity of operations for systems and programs.
- Ensure compatibility between equipment and software, analyze operational/systems requirements, support design reviews, and present technical briefings.
Required Experience/Skills:- 5+ years' experience and skill writing coding languages (such as SQL, Python, R, and Java Scripts).
- 3+ years' experience working with projects involving machine learning, natural language processing, robotics process automation, artificial intelligence, text and/or data mining, as well as statistical and mathematical methods.
- At least 1 years of experience working with AWS or Azure services such as Databricks, Data Factory, and Data Lake.
- Experience with Azure DevOps and/or GitHub to support continuous integration and delivery pipelines, and operate within Agile frameworks to iteratively deliver high-quality data products, machine learning models, and artificial intelligence solutions.
- Develop, manage, and optimize automated data pipelines to ensure data integrity, support reliable analytics workflows, and enable effective collaboration across teams.
- Integrate disparate and diverse data sources-including flat files, relational databases, and external systems-using techniques such as JDBC/ODBC connections, REST APIs, and web-scraping methods to support robust analytics and data-driven decision-making.
- Understand the concepts supporting relational databases, data warehousing, data governance, data access, data quality and related areas.
- Knowledge of ODBC connection strings, and other external data source connection protocols.
- Expert proficiency in common data science tools, including scripted languages (such as SQL, Python, R, and Java Scripts), Integrated Development Environment and analytics platforms, open-source solutions, commercial off-the- shelf tools and hardware-based capabilities to support the data analytic development process and creating models, dashboards, and reports.
- Knowledge and experience using advanced analytic techniques such as machine learning, natural language processing, robotics process automation, artificial intelligence, text and/or data mining, and statistical and mathematical methods.
- Knowledge and experience using business intelligence applications and reporting technologies/methodologies including Data Analytics Expressions (DAX), data Mash-up(M), and Microsoft Power Platform (e.g., Power BI, Power Apps, Power Automate, etc.).
- Knowledge of AWS or Azure Services, including Databricks, Data Factory, Data Lakehouses, and Data Lake.
- Knowledge of Extraction, Transformation, and Load (ETL) strategies, pattern recognition, and application of analytical tools.
- Proficiency in common data science tools and programming and scripting languages such as SQL, Python, R, and JavaScript with a proven ability to create solutions in complex environments, including the use of programming languages to create datasets, visualizations, and interactive reports in various business intelligence applications.
- Skill applying analytical techniques, methods, and processes to business problems demonstrated through a history of accepted modeling and analyses that resulted in meaningful business impact. These include working with unstructured or structured data and converting those data sets using a variety of analyses such as optimization, simulation, classical and spatial statistics, and/or programming languages.
- Skill using advanced analytic techniques such as machine learning, natural language processing, robotics process automation, artificial intelligence, text and/or data mining, and statistical and mathematical methods.
- Strong writing and documentation skills to capture collection of source data, methodology from business rules, and visualization deployment from a myriad of sources and interactions with various stakeholders.
- Strong relational database and querying languages experience.
- Strong verbal and written communication skills.
- Must be able to work effectively in a team environment.
- Understand and follow a software development lifecycle (analysis, design, development, coding, testing, debugging, and documenting).
Desired Experience/Skills:- Specialized experience working with programming languages (e.g., Python), business intelligence tools (e.g., Power BI), and analytics platforms (e.g., Databricks).
- Knowledge and experience in the law enforcement and/or audit industry
- Knowledge and experience using cloud computing platforms such as Azure
- Knowledge and experience with relational databases and structured query language (SQL)
- Experience working with contract, procurement, and accounts payable (AP) data to identify trends, anomalies, and potential risks in support of contract oversight activities.
- Experience using PySpark/PySpark SQL to process, transform, and analyze large-scale datasets.
Education Requirement(s):- Bachelor's degree in Computer Science, Information Technology, Data Analytics, or related field.
Security Requirement(s):- Public Trust - Candidates for this position must be submitted for a background investigation in order to satisfy government requirements.
Additional InformationWe offer a competitive and comprehensive benefits and compensation package for our employees, including but not limited to:
- Health
- Dental
- Vision
- Group Life Insurance/Long Term Disability/Short Term Disability
- Retirement/401(k)
- Flexible Leave Policy
