Sr Analyst, Data Quality & Modeling

GATX • Chicago, IL

19h • Hybrid

About The Position

The Senior Analyst, Data Quality & Modeling is a hybrid role and is responsible for identifying and resolving issues in data accuracy, reliability, and consistency as well as supporting design of data models for both the Cloud Analytics Platform and GATX Custom Applications. They will support the Director, Data Management & Governance, in ensuring that data sources and designs meet business requirements and are compliant with vision, standards, and guidelines set forth by Data Governance and the overall IT organization. The incumbent will support continued improvement in the reliability and quality of GATX’s data resources in support of the operational, analytic and information needs of the business. The incumbent is also responsible for performing business and data analysis (BA/DA) activities related to the management of information resources required to support the business objectives of the organization. These activities include ensuring standardized data names and definitions, maintaining models in a repository, and determining data sources. They will be a contributor in the development of databases and other data structures to minimize redundancy and maximize the compatibility of data among data stores. This includes supporting data modeling, data design, and developing requirements and design specifications for new and existing operational, data warehousing and analytic solutions. This role will support and influence the Data Governance program and practices through their IT and business interactions.

Requirements

• Bachelor’s degree in Computer Science, Engineering or other relevant technical discipline required; concentrations in Data Management, Reporting/Analytics and Data Warehousing preferred.
• Minimum of 2 years related experience in a corporation of comparable size and complexity to GATX.
• Proficient in the use of Microsoft Office Suite, including Word, Excel, PowerPoint (Teams and SharePoint a plus).
• Excellent interpersonal skills with the ability to communicate at all levels of the organization.
• Significant experience in developing and testing complex Oracle PL/SQL procedures.
• Knowledge and experience in applying structured problem-solving practices; formal training and/or relevant certification is desirable.
• Must be able to understand and translate application and business requirements into logical data models and apply appropriate normalization techniques.
• Must possess a familiarity with enterprise data modeling techniques including dimensional and third normal form modeling.
• The ability to support data engineers in their efforts to tune data models that support analytics and reporting.
• Experience or aptitude in building and tuning data models for transactional applications including the development of custom views and tables required for performant applications.
• Demonstrated experience in data resource function related tools (ETL, Erwin, Hackolade, Toad, Reporting/Query) required.
• Solid working knowledge of relational databases, specifically Oracle.
• Experience in Business Intelligence tools such as Power BI.
• Understanding of custom built as well as COTS (Commercial, off-the-shelf) systems and technology.
• Occasional travel is expected
• Occasional work on nights and weekends to support the production environment and meet project demands and deadlines.

Responsibilities

• Support Data Owners through data quality rule establishment and management.
• Perform repository management.
• Ensure compliance with data naming standards.
• Perform data quality reviews and recommend improvements.
• Understand and support technical knowledge of data administration, data quality, and metadata practices.
• Support the usage, activities, and quality of the platform, and its metadata via meetings and daily work to improve data governance metrics.
• Support adherence to “QA” (quality assurance) processes ensuring they are applied to all DARI Data Assets, reports, and dashboards.
• Propose DQ monitoring processes to identify and address data inconsistencies, duplicates and inaccuracies.
• Serve as liaison between Data Owners and Data Engineers to propose data quality rules and standards.
• Work with business representatives to understand the current and desired business processes at GATX.
• Understand business processes and how underlying applications/data can support and enable related processes.
• Support the assessment, analysis, and refinement of requirements as part of defined projects and initiatives.
• Assist in post-implementation continuous improvement efforts and production support.
• Provide technical knowledge and solutions for current ETL and Reporting tools.
• Provide support for data analysis and problem resolution for production data warehousing / data mart issues.
• Maintain close communication with business counterparts and IT staff involved in the resolution of challenging data problems.
• Work with IT and business counterparts in the development and maintenance of data and analytic solutions for the enterprise.
• Support development of logical and physical data models for analytics and custom, business-facing applications.
• Enhance and maintain the technical metadata repository.
• Work closely with Business Application Development teams and Data Warehousing teams in the performance of project-specific data tasks pertaining to the analytic and application data models.
• Support new data development to ensure that it is consistent and well-integrated with existing data structures.
• Coordinate enhancements and maintenance of data changes.
• Perform data analysis and design and create business object and logical data models working with other IT and Data, Analytics, Reporting and Integration (DARI) team members.
• Develop a strong technical knowledge of data administration, data quality, and metadata practices in accordance with IT and DARI Data Governance policies.

Benefits

• This role may be eligible to participate in the Company’s short-term incentive plan, the details of which will be provided to the applicant upon hire.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees