Sr Analyst, Data Quality & Modeling

Founded in 1898 and headquartered in Chicago, IL, GATX Corporation (NYSE: GATX) is an industry leader with 125+ years of success—success that is powered by our people. We are proud of our high-performance culture, hard-working and enthusiastic management team, and beautiful office space in the Willis Tower.

At GATX, we hire the best and offer our employees a dynamic, energetic, collaborative environment to enable them to make an impact from day one. Enjoy the perks and benefits of a global company with the close-knit culture and community of a much smaller one. In the same way we strive to empower our customers to propel the world forward, we are dedicated to providing our people with the tools and resources they need to advance in their careers.

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.

Data Quality

• 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.

Data Analysis

• 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.

Data Modeling

• 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.
• Timing in this activity is expected to be split evenly between Cloud Analytics Platform and GATX Custom Applications, however, shifts due to projects can be expected.

Responsibilities:

Data Quality

• 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.

Data Analysis

• 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.

Data Modeling

• 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.
• Timing in this activity is expected to be split evenly between Cloud Analytics Platform and GATX Custom Applications, however, shifts due to projects can be expected.
•  

The Senior Analyst, Data Quality & Modeling will interact with the Data Governance Organization (including Data Owners), Data, Analytics, Reporting and Integration (DARI) and other technical IT teams.  Secondary business interactions will occur as part of application and BI Development.  All interactions will require effective interpersonal and communications skills. The individual in this role must also be able to create and present plans, recommendations, and decisions in a professional, clear, and concise manner. The role is a cross-functional position that requires a smart, motivated, self-starting individual who is comfortable with ambiguity, capable of consensus-building, and able to navigate significant complexity. The incumbent must also be able to execute quality processes consistently with attention to detail and repeatability.  This role requires that the incumbent investigate and stay abreast of technical and practical industry information related to data administration, data quality, and metadata management practices, tools and platforms.  Additionally, they should regularly work to recommend and institute best practices as appropriate.

Education and/or Experience Required:

• 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.

Other:

• Occasional travel is expected 
• Occasional work on nights and weekends to support the production environment and meet project demands and deadlines.