Data Analyst II (Data Science and Automation Analyst) - ENT0006H
DESCRIPTION/RESPONSIBILITIES:
Develop medium to highly complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Work closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues. Work on multiple large complex projects/issues/enhancements as a team member or lead.
* Provide input in support of the strategic planning process and short and long term planning. Assist in establishing and maintaining standards for data quality and the development of data standards, policies and procedures. Work with IT teams to ensure compliance. Act as a gatekeeper for new data that do not meet the set business requirements.
* Gather and document the data needs of the organization. Work with business and vendor partners, and project delivery leads to gather reporting requirements. Interpret and document the data needs for the business.
* Collect, analyze and summarize data to support business decisions. Design reports to identify patterns and trends. Design, develop and deploy query parameters, layout, filters, and analytics for program information solutions. Ensure that the information is named properly and defined consistently across the organization. Provide data that is congruent and reliable and is easily accessible by the user. Identify opportunities for reuse of data across the enterprise. Validate data sources. Assist with management of all metadata associated with individual models. Manage the flow of information between departments.
* Translate business requirements into conceptual, logical and physical data model. Develop and maintain an integrated logical and physical data model. Assist in creating a framework for representing the data elements including the entities, relationships and attributes. Recognize and resolve conflicts between models, ensuring that data models are consistent with the enterprise model (e.g., entity names, relationships and definitions). Work closely with other IT groups to use the data models throughout the whole life cycle.
* Ensure and maintain a high level of data integrity by using tools to monitor and mass update data changes. Develop data profiling and preventative procedures to improve data quality. Monitor and resolve daily exception reports. Analyze data inaccuracies and recommend process improvements or system changes to enhance overall quality of the data. Communicate data integrity accuracy to the business, and escalates/communicates issues when necessary. Identify opportunities and support the development of automated solutions to enhance the quality of enterprise data. Analyze data issues and work with development teams for problem resolutions. Monitor data dictionary statistics, analyze reports of data duplicates or other errors to provide ongoing appropriate data reports. Identify problematic areas and conduct research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
* Research and resolve production problems/system abends.
* Assist with creating data quality metrics for identifying data related issues. Test and produce metrics and samples for further analysis. Identify opportunities for process improvements. Support the development of automated solutions that will enhance the quality of enterprise data. Develop and maintain technical documentation about the data.
* Assist in the coaching and training of customers in the use of business intelligence tools to enhance business decision-making capability.
* Other duties may be assigned.
All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.