The Senior Technical Data Analyst work may include the following:
- Ability to recommend the most suitable methods of data extraction and comparison.
- Ability to identify and understand the different data formats and structures used in
each source system.
- Develop and generate reports that effectively and clearly present the comparison of
data converted from Infor Lawson to Oracle Cloud Fusion HCM.
- Create reports to highlight differences in matched data and the absence of data from
the source to the destination.
- Create reports to identify data that is in Lawson but not in HCM as well as the reverse,
data in HCM not in Lawson.
- The data from the HCM Oracle cloud conversion will be validated against the source
Lawson tables.
- Tailor the reports to allow Functional users to easily understand the highlighted data
differences
- Ensure that all data is reviewed, not just subsets of the data.
- Document what tables and fields are being compared
- Document any limitations of the comparison
- Assist functional users in the review of the comparison reports
- Work with MCPS resources to resolve any issues that arise during the project.
- Keep the client informed of progress and any roadblocks.
- Attends meetings where reporting and analytics expertise is needed and represents the
department in both internal and external settings.
Place of Performance
Work under this SOW shall be primarily performed remotely. There may be on-site travel as deemed necessary by the Director.
Required knowledge, skills, and abilities must include:
7 or more years of data analyst and/or relational database administrator experience
working on large enterprise-wide implementation projects.
5 or more years of experience working with large volumes of data from on-premise
and cloud platforms.
- Experience translating business requirements into data requirements.
- Experience in gathering and reviewing/comparing data from multiple sources, including but not limited to Oracle databases using Lawson LBI, or SQL, Excel spreadsheets, and vendor generated reports.
- Experience in creating complex pivot tables using Excel for data comparisons.
- Experience in creating programs for data validation using SQL.
- Expert experience with database query and merging datasets using Microsoft Excel.
- Ability to design, generate and validate results of analyses of complex data sets, and facilitates reporting to improve operational outcomes.
- Ability to develop and maintain quality control standards and data reconciliation techniques for internal and external reporting.
- Experience in developing and implementing algorithms for data analysis and modeling.
- Ability to evaluate and select appropriate software tools, frameworks, and technologies.
- Ability to identify patterns in data and communicate the findings clearly.
- Design and execute effective data visualization strategies for presenting complex data.
- Experience in managing complex projects and tasks while paying close attention to details.
- A keen focus on customer-satisfaction and team collaboration.
- Detail-oriented, highly organized, and excellent oral and written communication and human relations skills.
- Excellent analytical, problem-solving, and decision-making skills, leveraging both logic and creativity