FI Consulting
Senior Data Management Consultant
FI Consulting, Arlington, Virginia, United States, 22201
FI Consulting is seeking a full-time Senior
Data Management Consultant with 5+ years of professional experience, to help lead and advise our client on an ERP implementation.
For more than 20 years, financial institutions in the Federal, private, and public sectors have called on FI Consulting to address complex and high-stakes analytical challenges closely scrutinized by executives, auditors, regulators, and stakeholders. We help clients succeed by applying our core strengths in business applications of Data Engineering, Analytics, Modeling, and Business Architecture to gain insight into finances, loans, and performance; manage risk; and improve operations.
Position Overview:
Update and/or maintain the Data Management Strategy that considers all necessary activities to migrate data from current financial, procurement, and asset management systems to target systems.Participate in and/or facilitate Data Conversion/Data Clean-up working groups with stakeholders.Provide recommendations on data cleansing approaches and business rules across multiple lines of business.Track stakeholder validation of data clean-up and data cleansing.Develop and/or maintain data clean-up/data cleansing dashboards.Assist in the execution of all data conversion and data clean-up activities (e.g., data cleansing, mock conversion, data research, etc.) this may include:
Analyzing all source system data for anomalies that affect data integrity.Executing cleansing of data as determined by results of analysis. This may include the development and execution of database scripts.Integrating this progress with the Integrated Master Schedule.Identifying and implementing interim solutions to assist OCFO in improving and streamlining business processes to improve the quality of financial data before migration.Leveraging data warehouses and repositories to analyze CISA data and identify anomalies to be corrected.
Required Skills:
5+ years of experience in Data Analysis, preferably within an Accounting or Finance team.Strong understanding of Data Warehousing, Data Analysis, Data Profiling, Data Cataloging, Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data GovernanceProven analytics skills, including mining, evaluation, and visualizationTechnical writing experience in relevant areas including reports and presentationsAptitude and interest in learning other analytics tools and programming languagesExperience developing and maintaining dashboards and visualizationsExperience with migrating data to an integrated system which includes data cross-walking and data reconciliationAbility to handle large datasets, ensure data accuracy, and implement data governance practicesDeep understanding of table relationships, and ability to compile, manipulate, and aggregate dataStrong ability to identify trends and identify actionable insight and make informed decisions from dataPreferred Technologies:
SQL, Python, Excel VBA or other data query languagesPython, R, JavaScript, or other automation programming languagesExcel, Power BI, Tableau, or other data analysis and Visualization ToolsAzure, AWS, GCP, or other cloud providersKeys to Success in this Role:
Proficiency with federal financial management and accounting conceptsSelf-starter who can work with minimal supervision and oversee the data team activities and strategyDetail-oriented to ensure accuracy in data mapping, reconciliation, and reportingExperience working with cross-functional teams to ensure quality throughout the software development lifecycleHardworking individual with excellent communication skills, attention to detail, analytical mind, problem-solving aptitude, and strong organization skills who inspires teammates to reach their maximum potentialAdditional Requirements:
Authorized to work in the United States as a US Citizen. For this role, we are not able to hire any Permanent residents or sponsor or accept any visa holders including H1B or OPTSuccessfully pass a background investigation and drug screeningWho We Are:
FI Consulting is a 80+ person professional services firm that helps government and commercial financial institutions solve hard problems in data, analytics, modeling, and technology. Our professionals are specialists with expertise across a range of fields, for example:
Financial and economic modelingData analytics & visualizationFinancial products and marketsEconomics and statisticsBusiness process management and re-engineeringOur Company Values & Operates on:
A Commitment to Creating Value for our Clients and our EmployeesA Flat Management Structure that is Still Led by one of the Original FoundersAn Emphasis on Teamwork and CooperationEmployee Development and Career GrowthContinuous ImprovementAn Entrepreneurial Culture that Rewards Finding, Developing, and Owning Business
What is it really like to Work for Us?
You will work with a team of smart, talented people in a culture that is simultaneously driven, collegial, and supportive. We set high expectations for employees in the areas of project delivery excellence, building trusted client relationships, and continuous improvement. We insist on teamwork and collaboration.
FLSA Designation - This is an exempt position. FI Consulting is an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities. FI Consulting participates in E-Verify.
Data Management Consultant with 5+ years of professional experience, to help lead and advise our client on an ERP implementation.
For more than 20 years, financial institutions in the Federal, private, and public sectors have called on FI Consulting to address complex and high-stakes analytical challenges closely scrutinized by executives, auditors, regulators, and stakeholders. We help clients succeed by applying our core strengths in business applications of Data Engineering, Analytics, Modeling, and Business Architecture to gain insight into finances, loans, and performance; manage risk; and improve operations.
Position Overview:
Update and/or maintain the Data Management Strategy that considers all necessary activities to migrate data from current financial, procurement, and asset management systems to target systems.Participate in and/or facilitate Data Conversion/Data Clean-up working groups with stakeholders.Provide recommendations on data cleansing approaches and business rules across multiple lines of business.Track stakeholder validation of data clean-up and data cleansing.Develop and/or maintain data clean-up/data cleansing dashboards.Assist in the execution of all data conversion and data clean-up activities (e.g., data cleansing, mock conversion, data research, etc.) this may include:
Analyzing all source system data for anomalies that affect data integrity.Executing cleansing of data as determined by results of analysis. This may include the development and execution of database scripts.Integrating this progress with the Integrated Master Schedule.Identifying and implementing interim solutions to assist OCFO in improving and streamlining business processes to improve the quality of financial data before migration.Leveraging data warehouses and repositories to analyze CISA data and identify anomalies to be corrected.
Required Skills:
5+ years of experience in Data Analysis, preferably within an Accounting or Finance team.Strong understanding of Data Warehousing, Data Analysis, Data Profiling, Data Cataloging, Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data GovernanceProven analytics skills, including mining, evaluation, and visualizationTechnical writing experience in relevant areas including reports and presentationsAptitude and interest in learning other analytics tools and programming languagesExperience developing and maintaining dashboards and visualizationsExperience with migrating data to an integrated system which includes data cross-walking and data reconciliationAbility to handle large datasets, ensure data accuracy, and implement data governance practicesDeep understanding of table relationships, and ability to compile, manipulate, and aggregate dataStrong ability to identify trends and identify actionable insight and make informed decisions from dataPreferred Technologies:
SQL, Python, Excel VBA or other data query languagesPython, R, JavaScript, or other automation programming languagesExcel, Power BI, Tableau, or other data analysis and Visualization ToolsAzure, AWS, GCP, or other cloud providersKeys to Success in this Role:
Proficiency with federal financial management and accounting conceptsSelf-starter who can work with minimal supervision and oversee the data team activities and strategyDetail-oriented to ensure accuracy in data mapping, reconciliation, and reportingExperience working with cross-functional teams to ensure quality throughout the software development lifecycleHardworking individual with excellent communication skills, attention to detail, analytical mind, problem-solving aptitude, and strong organization skills who inspires teammates to reach their maximum potentialAdditional Requirements:
Authorized to work in the United States as a US Citizen. For this role, we are not able to hire any Permanent residents or sponsor or accept any visa holders including H1B or OPTSuccessfully pass a background investigation and drug screeningWho We Are:
FI Consulting is a 80+ person professional services firm that helps government and commercial financial institutions solve hard problems in data, analytics, modeling, and technology. Our professionals are specialists with expertise across a range of fields, for example:
Financial and economic modelingData analytics & visualizationFinancial products and marketsEconomics and statisticsBusiness process management and re-engineeringOur Company Values & Operates on:
A Commitment to Creating Value for our Clients and our EmployeesA Flat Management Structure that is Still Led by one of the Original FoundersAn Emphasis on Teamwork and CooperationEmployee Development and Career GrowthContinuous ImprovementAn Entrepreneurial Culture that Rewards Finding, Developing, and Owning Business
What is it really like to Work for Us?
You will work with a team of smart, talented people in a culture that is simultaneously driven, collegial, and supportive. We set high expectations for employees in the areas of project delivery excellence, building trusted client relationships, and continuous improvement. We insist on teamwork and collaboration.
FLSA Designation - This is an exempt position. FI Consulting is an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities. FI Consulting participates in E-Verify.