Data Wranlger

Key Responsibilities

• Wrangle data from a wide variety of data sets and assemble into normalized and enriched data assets that enables new insights, solutions, and visualizations.
• Perform and document data profiling, quality assessment, source consolidation, aggregation, and other data manipulation efforts to understand data formats, source systems, and file sizes.
• Develop simple, dependable automated reports and dashboards to surface key metrics that deliver information that is digestible and visually appealing.
• Gather data set requirements from business analytics stakeholders to support downstream analysis.
• Acquire, transform, map, and load data into a variety of data models.
• Document assigned data asset and dashboard architectures.
• Create, update, and maintain documentation and procedures for sourcing, analyzing, and preparing internal reporting and presentations.
• Ensure the highest quality and integrity of data sources.
• Responsible for building and maintaining complex data assets that allow analytics professionals to develop advanced business analytics and drive strategic business decisions.
• Work closely with operational leaders, business partners, and analytics teams to source, transform, validate, and organize data from multiple systems into trusted reporting and analytic solutions.
• Ensure data accuracy, integrity, and accessibility while identifying opportunities for automation and process improvement.
• Support Federal Employee Program (FEP) performance management, operational oversight, compliance monitoring, and informed decision-making through the development of reporting assets, dashboards, and data models.

Requirements & Tech Stack

• SQL
• Microsoft Excel (formulas, pivot tables, data visualizations)
• Relational databases

Qualifications

Required

• Bachelor’s degree in a quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering, or economics.
• Less than 1-year hands-on experience or internship in a role pulling reports and analyzing data.
• Experience with data discovery, profiling, cleansing, standardization, and data quality management.
• Ability to quickly learn new data sources and programming languages.
• Basic knowledge or experience with relational databases.
• Detail-oriented, self-motivated, excellent communicator, strong analytical/technical orientation.
• Natural curiosity, and ability to drive business decisions and solutions.
• Proactive self-starter with effective time management skills and the ability to organize and prioritize projects or tasks.

Preferred

• Experience working with large data sets and spreadsheets.
• Experience gathering and documenting business requirements.
• Experience of cross-functional activity in complex organizations with a strong emphasis on influencing and collaboration.
• Hands-on data analysis of databases and files using SQL dialects and programming languages (e.g., Python, Scala, Spark, etc.).
• Experience with business intelligence/reporting/analytics platforms such as MS Power BI and Tableau, etc.
• Proven ability to mine and query data across structured and unstructured data sets.