US Tech Solutions
Job Title:
Data Analyst Specialist Location:
1551 Park Run Drive, McLean, Virginia, 22102 Duration:
6 Months
Position Overview Investments & Capital Markets Division is currently seeking an experienced Financial/Data Analyst Senior for a large strategic financial project. The candidate will support project management activities and initiatives, with a focus on financial & capital reporting and forecasting. This role will entail project management activities as well as complex data analysis, reconciliations, and testing. In addition, the candidate’s duties will include activities throughout the development lifecycle and production support, coordinating directly with key business areas and IT partners.
Required Qualifications Must have 5+ years of hands-on experience with data transformation and reconciliation. Must be advanced in Excel. Must have advanced querying experience and have worked with SQL. Ideal candidates should have experience in the finance industry (accounting), experience with general ledgers/sub ledgers, mortgage accounting or mortgage security experience, data testing, data reconciliation for analysis. Experience with mortgage security accounting.
Role & Responsibilities
Outstanding proficiency with Excel for data analysis of complex datasets, data quality validation, data reconciliations, and data transformation for inputs and outputs of forecasting processes
Collect and write detailed data transformation and financial process requirements
Create high-quality and high-complexity project deliverables, focused on requirements, reconciliations and test results
Create and maintain technical, process and data-related documentation
Support acceptance testing; create and execute test cases, reconciliations and regressions; analyze and reconcile complex test results using Excel and SQL
Improve and automate validations and input preparation processes
Maintain, update and track development features and stories in JIRA
Troubleshoot, track and resolve project issues, project dependencies and configuration changes
Lead the analysis, requirements and testing of financial reports using SQL and advanced Excel
Perform complex data and reports analysis involving financial, forecasting and risk data
Create engaging and detailed materials including user guides, specification documents, release notes and testing results
Support a variety of project management activities, including control requirements and execution, issue troubleshooting and analysis, data conversion and cataloging, and user training.
Qualifications
Degree in accounting, quantitative finance, statistics, mathematics, economics, data analytics or a related quantitative field preferred, with at least 5 years of relevant work experience.
Extensive experience using advanced Excel efficiently is required
Experience working with large data sets and relational databases
Outstanding quantitative, analytical, and problem-solving skills
Excellent presentation, communication and writing skills
Ability to use SQL to query and display large data sets while maximizing the performance of workbooks
Proven experience writing SQL to query complex data structures and working with analytics
Expertise with financial statements and general ledger/subledger data is strongly preferred
Ability to translate complex business requirements into technical specifications
Experience working with different databases and understanding of data and financial reporting concepts
Experience with implementing or modifying financial systems or applications, preferably related to accounting functions
Strong data and financial analytical skills; Ability to quickly understand complex financial concepts; Mortgage industry experience preferred
About US Tech Solutions US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr
Data Analyst Specialist Location:
1551 Park Run Drive, McLean, Virginia, 22102 Duration:
6 Months
Position Overview Investments & Capital Markets Division is currently seeking an experienced Financial/Data Analyst Senior for a large strategic financial project. The candidate will support project management activities and initiatives, with a focus on financial & capital reporting and forecasting. This role will entail project management activities as well as complex data analysis, reconciliations, and testing. In addition, the candidate’s duties will include activities throughout the development lifecycle and production support, coordinating directly with key business areas and IT partners.
Required Qualifications Must have 5+ years of hands-on experience with data transformation and reconciliation. Must be advanced in Excel. Must have advanced querying experience and have worked with SQL. Ideal candidates should have experience in the finance industry (accounting), experience with general ledgers/sub ledgers, mortgage accounting or mortgage security experience, data testing, data reconciliation for analysis. Experience with mortgage security accounting.
Role & Responsibilities
Outstanding proficiency with Excel for data analysis of complex datasets, data quality validation, data reconciliations, and data transformation for inputs and outputs of forecasting processes
Collect and write detailed data transformation and financial process requirements
Create high-quality and high-complexity project deliverables, focused on requirements, reconciliations and test results
Create and maintain technical, process and data-related documentation
Support acceptance testing; create and execute test cases, reconciliations and regressions; analyze and reconcile complex test results using Excel and SQL
Improve and automate validations and input preparation processes
Maintain, update and track development features and stories in JIRA
Troubleshoot, track and resolve project issues, project dependencies and configuration changes
Lead the analysis, requirements and testing of financial reports using SQL and advanced Excel
Perform complex data and reports analysis involving financial, forecasting and risk data
Create engaging and detailed materials including user guides, specification documents, release notes and testing results
Support a variety of project management activities, including control requirements and execution, issue troubleshooting and analysis, data conversion and cataloging, and user training.
Qualifications
Degree in accounting, quantitative finance, statistics, mathematics, economics, data analytics or a related quantitative field preferred, with at least 5 years of relevant work experience.
Extensive experience using advanced Excel efficiently is required
Experience working with large data sets and relational databases
Outstanding quantitative, analytical, and problem-solving skills
Excellent presentation, communication and writing skills
Ability to use SQL to query and display large data sets while maximizing the performance of workbooks
Proven experience writing SQL to query complex data structures and working with analytics
Expertise with financial statements and general ledger/subledger data is strongly preferred
Ability to translate complex business requirements into technical specifications
Experience working with different databases and understanding of data and financial reporting concepts
Experience with implementing or modifying financial systems or applications, preferably related to accounting functions
Strong data and financial analytical skills; Ability to quickly understand complex financial concepts; Mortgage industry experience preferred
About US Tech Solutions US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr