Why CC Pace? | CC Pace

Senior Data Analyst

Job Title
Senior Data Analyst
Job ID
27656525
Location
Washington,  DC 20005
Other Location
Description
Successful candidates for the Senior Data Analyst will demonstrate the following:
• Possess a strong sense of curiosity to identify, analyze, and resolve problems in connection with defined objectives and provide process improvement recommendations as a result.
• Ability to quickly and effectively adjust to change, new priorities, processes, requirements, and/or environments with a positive attitude.
• Must demonstrate the ability to work in a positive and constructive manner with others to achieve organizational and individual goals.
• Demonstrates and conveys information clearly and precisely using both written and oral means to inform, persuade, or compel others to action.

ESSENTIAL DUTIES AND RESPONSIBILITIES
• Performs complex data analysis and assists data analysts in support of ad-hoc and standing requests from internal and external requestors with little to no supervision
o Routinely writes complex SQL and PL/SQL queries to extract results for a wide variety of data requests
o Works with the requestor to develop and understand requests while tracking time and progress in the request tracking system
o Develops an appropriate methodology for collecting, analyzing, and presenting results
o Evaluates the findings thoughtfully and thoroughly and escalates them, as needed
o Documents approach used to retrieve and manipulate data in order to allow review and replication of work
o Creates accurate and professionally presentable reports for consumers of analysis, as needed
o Conducts presentations on analysis results including analyst’s conclusions on the accuracy, usefulness, and completeness of the data
o Applies standard statistical methodologies to determine sample sizes, errors rates, standard deviations, and other required data, as needed
o Performs peer reviews of other analysts’ analyses for accuracy and completeness.
• Supports a formal data quality program for the company programs to include reporting and analysis
o Creates, edits, and manages documents that describe the elements and flows of the data the company collects, transforms, and disseminates, as well as the quality standards and specifications the Data and Infrastructure Management department seeks to achieve with the data
o Performs assessments of data quality pursuant to standard methodologies and reports results using standard formats
o Oversees and performs risk assessments of various aspects of data quality consistent with risk management practices of the department
o Leads and participates in projects utilizing continuous improvement principles to identify, select, and implement changes to data processes that will improve the quality of data
o Develops and interprets data models such as ERD’s
o Creates, tests, validates, and documents corrections of data
• Acts as a liaison with key data suppliers and consumers
o Participates in regular meetings and communications with data suppliers and articulates the needs of the Market Information programs with respect to the quality and nature of the data supplied; seeks to build lasting relationships that will form the basis of continuous improvement over time
o Meets with key knowledge workers who consume Market Information data; documents and reports on their needs and usage of the data and applies that knowledge to guide the standards of quality the department should seek
• Provides input to management on decisions concerning Market Information projects by providing situation assessments, developing alternative solutions, evaluating risks, costs, and benefits, and making recommendations
• Works as part of the Agile development process to ensure the business requirements are understood and data quality standards are introduced on the front end of the process and tested prior to going into production
• Pursues ongoing skill and knowledge development to extend the range and depth of own knowledge and skills, within the scope of assigned duties; supports the development of other data analysts
• Performs other duties as assigned

EDUCATION/QUALIFICATIONS
• 5 years’ experience in information systems, computing, and experience with relational SQL and NoSQL databases, including Oracle, Postgres, and DynamoDB.
• At least 2 years experience with Business Intelligence tools such as Amazon QuickSight, Tableau, Power Bi, etc.
• Ability to write simple and complex queries in SQL and PL/SQL and related languages to extract data from the database.
• Experience with Python and Spark is a plus.
• Experience with AWS (Amazon Web Services) is a plus.
• Ability to develop and interpret data models and ERD’s is required.
​​​​​​• Experience in query performance tuning is preferred.
• Knowledge of financial markets or the municipal bond market is a plus.

Option 1: Create a New Profile