SIGN IN
Lead Data Quality & Modeling jobs in United States
cer-icon
Apply on Employer Site
company-logo

GATX · 1 day ago

Lead Data Quality & Modeling

GATX Corporation, founded in 1898 and headquartered in Chicago, IL, is an industry leader known for its high-performance culture. The Lead, Data Quality & Modeling role involves ensuring data accuracy and consistency while supporting data model design for various platforms, ultimately enhancing the reliability and quality of the company's data resources.
IndustrialFinanceTransportationVenture CapitalFinancial Services
check
Comp. & Benefits
check
H1B Sponsor Likelynote

Responsibilities

Support Data Owners through data quality rule establishment and management
Promote compliance with data administration standards, policies, and procedures
Promote and develop data sharing strategies
Perform repository management
Establish and ensure compliance with data naming standards
Perform data quality reviews and recommend and institute improvements
Understand and execute 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
Perform data quality (DQ) checks for production Data Assets to ensure accuracy, completeness, consistency, and timeliness
Support adherence to 'QA' (quality assurance) processes ensuring they are applied to all DARI Data Assets, reports, and dashboards
Work closely with developers to ensure performance to DQ metrics, and accuracy and completeness of technical metadata and lineage
Implement DQ monitoring processes to identify and address data inconsistencies, duplicates and inaccuracies
Perform data cleansing and remediation activities, in accordance with GATX strategy, to improve data quality across systems
Serve as liaison between Data Owners and Data Engineers to effectively implement data quality rules and standards
Create and perform training on various Data Quality elements as necessary
Create standard documentation to ensure best practices are followed and maintain efficiency, as needed
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
Assess, analyze, and refine requirements as part of defined projects and initiatives
Focus should be on both long-term initiatives and rapid, simple changes where business value can be achieved
Assist in post-implementation continuous improvement efforts and production support
Provide technical knowledge and solutions for current ETL and Reporting tools
Provide data analysis and problem resolution for production data warehousing / data mart issues, including the most complex technical problems
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
Consolidate/transcribe multiple logical application and ERP data models into an enterprise-wide data model and analytic model
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 enterprise-wide data model
Work with Architects and Business Analysts to generate data models and implement data modeling concepts to satisfy business requirements
Coordinate 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
Ensure continued improvement in the reliability and quality of GATX’s information architecture in support of the operational, informational and analytic needs of the business
Maintain 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
Support the creation and tuning of SQL queries and database objects (views) in support of both application development and analytic efforts

Qualification

Advanced SQLData ModelingData Quality ManagementETL ToolsBusiness IntelligenceOracle PL/SQLMicrosoft Office SuiteInterpersonal SkillsProject ManagementProblem-Solving

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 7 years of related experience in a corporation of comparable size and complexity to GATX
Minimum of 7 years of experience working with advanced SQL including the ability to write advanced queries, views, and performance tuning of queries
Minimum of 6 years of experience working with Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) database design patterns
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
Must be able to understand and translate application and business requirements into logical data models and apply appropriate normalization techniques
Must possess an in-depth knowledge of systems development life cycle, entity relationship diagrams and other logical data modeling techniques, as well as technical data management concepts, tools, and techniques
Must possess an in-depth knowledge of enterprise data modeling techniques including dimensional and third normal form modeling
Demonstrated experience building and tuning data models for both transactional applications and analytic / business intelligence systems
Demonstrated experience in data resource function related tools (ETL, Erwin, Hackolade, Toad, Reporting/Query) required
Solid working knowledge of relational databases, specifically Oracle
Project management skills. Understanding and application of project management, estimating, forecasting, planning, scheduling and risk management concepts and techniques

Preferred

Experience writing Oracle PL/SQL is optional but strongly desired
Experience in Postgres is a desirable
Experience in Business Intelligence tools such as Power BI
Knowledge and experience in applying structured problem-solving practices; formal training relevant certification is desirable

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.

Company

GATX

twittertwitter
company-logo
GATX is an equipment finance company based in Chicago, Illinois.

H1B Sponsorship

GATX has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
2020 (1)

Funding

Current Stage
Public Company
Total Funding
$400M
2025-10-23Post Ipo Debt· $400M
1987-11-05IPO

Leadership Team

M
Max Epstein
Founder
Company data provided by crunchbase