Southeastern Pennsylvania Transportation Authority
Senior Data Modeler (9273)
Southeastern Pennsylvania Transportation Authority, Phila, Pennsylvania, United States, 19117
Senior Data Modeler
The Senior Data Modeler is responsible for designing and implementing a robust and scalable data architecture. The role will work closely with business users, business analysts, product teams, development teams, and other data professionals to define and execute a comprehensive data architecture. The data modeler will identify the current data management challenges and address data modeling, data quality and data integrity issues. The ideal candidate will have a strong understanding of data modeling best practices, metadata management and data governance. The role works with Data Governance team to ensure compliance with policies, security standards, and regulatory requirements. Also works with AI/ML engineering team to capture features and data sets required for predictive models, AI/ML use cases. Specific Responsibilities
Collaborates with business users, business analysts, product teams, data and analytics engineers and others to understand data requirements and translate them into effective and efficient data models. Develops conceptual, logical, and physical data models, ensuring alignment with best practices and data governance standards. Optimizes data models for performance, scalability, and ease of use reporting. Defines and adheres to the best practices for data modeling and naming conventions. Conducts gap analysis of the current data landscape and identify areas for improvement. Contributes to the development and maintenance of data dictionaries and metadata repositories. Participates in data mapping and data lineage activities to ensure data integrity and traceability during the data migration process. Identifies and resolves data modeling issues and provide recommendations for improvements. Contributes to the creation of semantic layer that enables self-service analytics. Facilitates data model review sessions with data and analytics engineering teams and others to assess and validate the proposed data model meets the business requirements. Facilitates collaborative analysis and design sessions by leveraging strong written and verbal communication skills to ensure clear understanding and alignment among stakeholders. Performs other duties as assigned. Qualifications and Experience
Bachelor's degree in Computer Science, Information Technology or related field required. 10+ years of experience in architecting and building enterprise data models for both operational and analytical systems required. 5+ years of experience in data modeling tools like Erwin, ER Studio. Experience with multi-user modeling tool is preferred. 3+ years of data architecture experience in cloud data platforms (AWS, Azure) required. Expertise in conceptual, logical, physical data modeling and normalization, de-normalization techniques required. Established data architectures for relational and non-relational databases as well as dimensional modeling for data analytics required. Experience in integrating data models with BI tools and Data Catalogs preferred. Hands on experience with cloud data platforms like Snowflake, Databricks, AWS Redshift, Azure Synapse required. Strong proficiency in SQL, including writing complex queries for data analysis, data profiling, data validation and reconciliation required. Ability to analyze the structure and reverse engineer data models from various data formats like XML, JSON, AVRO, etc., required. Familiar with ETL/ELT tools and BI tools required. Understanding of data privacy regulations (e.g., GDPR, CCPA) and best practices for data security required. Experience working with Agile/Scrum methodologies required. Ability to communicate complex data architecture concepts and practices to both technical and non-technical stakeholders required. Excellent problem-solving skills, with a proactive and solution-oriented approach required. Stay abreast of the latest techniques and technologies relevant data modeling and cloud-based data platform required. Why Join Our Team? Enjoy Outstanding Benefits!
Comprehensive Healthcare Coverage Medical, prescription, dental, and vision plans with little to no employee premiums. Retirement Security Participate in a Defined Benefit Pension Plan and a 457B Deferred Compensation Plan to build your financial future. Work-Life Balance Enjoy paid parental leave, generous vacation time, and paid holidays to recharge and spend time with loved ones. Employee Wellness Access wellness programs and resources to support your physical, mental, and emotional well-being. Invest in Your Growth We offer tuition reimbursement to support your education and career advancement. Student Loan Assistance Our positions qualify for the Public Service Loan Forgiveness (PSLF) program, helping you manage and reduce student debt. Free Travel Perks Receive a FREE SEPTA Transportation Pass, giving you unlimited access to all SEPTA services! Join us and take advantage of these incredible benefits while making a difference in your community!
Join the Best in Transit! Apply Today
Click Apply Now and take the next step in your engineering career with SEPTA!
The Senior Data Modeler is responsible for designing and implementing a robust and scalable data architecture. The role will work closely with business users, business analysts, product teams, development teams, and other data professionals to define and execute a comprehensive data architecture. The data modeler will identify the current data management challenges and address data modeling, data quality and data integrity issues. The ideal candidate will have a strong understanding of data modeling best practices, metadata management and data governance. The role works with Data Governance team to ensure compliance with policies, security standards, and regulatory requirements. Also works with AI/ML engineering team to capture features and data sets required for predictive models, AI/ML use cases. Specific Responsibilities
Collaborates with business users, business analysts, product teams, data and analytics engineers and others to understand data requirements and translate them into effective and efficient data models. Develops conceptual, logical, and physical data models, ensuring alignment with best practices and data governance standards. Optimizes data models for performance, scalability, and ease of use reporting. Defines and adheres to the best practices for data modeling and naming conventions. Conducts gap analysis of the current data landscape and identify areas for improvement. Contributes to the development and maintenance of data dictionaries and metadata repositories. Participates in data mapping and data lineage activities to ensure data integrity and traceability during the data migration process. Identifies and resolves data modeling issues and provide recommendations for improvements. Contributes to the creation of semantic layer that enables self-service analytics. Facilitates data model review sessions with data and analytics engineering teams and others to assess and validate the proposed data model meets the business requirements. Facilitates collaborative analysis and design sessions by leveraging strong written and verbal communication skills to ensure clear understanding and alignment among stakeholders. Performs other duties as assigned. Qualifications and Experience
Bachelor's degree in Computer Science, Information Technology or related field required. 10+ years of experience in architecting and building enterprise data models for both operational and analytical systems required. 5+ years of experience in data modeling tools like Erwin, ER Studio. Experience with multi-user modeling tool is preferred. 3+ years of data architecture experience in cloud data platforms (AWS, Azure) required. Expertise in conceptual, logical, physical data modeling and normalization, de-normalization techniques required. Established data architectures for relational and non-relational databases as well as dimensional modeling for data analytics required. Experience in integrating data models with BI tools and Data Catalogs preferred. Hands on experience with cloud data platforms like Snowflake, Databricks, AWS Redshift, Azure Synapse required. Strong proficiency in SQL, including writing complex queries for data analysis, data profiling, data validation and reconciliation required. Ability to analyze the structure and reverse engineer data models from various data formats like XML, JSON, AVRO, etc., required. Familiar with ETL/ELT tools and BI tools required. Understanding of data privacy regulations (e.g., GDPR, CCPA) and best practices for data security required. Experience working with Agile/Scrum methodologies required. Ability to communicate complex data architecture concepts and practices to both technical and non-technical stakeholders required. Excellent problem-solving skills, with a proactive and solution-oriented approach required. Stay abreast of the latest techniques and technologies relevant data modeling and cloud-based data platform required. Why Join Our Team? Enjoy Outstanding Benefits!
Comprehensive Healthcare Coverage Medical, prescription, dental, and vision plans with little to no employee premiums. Retirement Security Participate in a Defined Benefit Pension Plan and a 457B Deferred Compensation Plan to build your financial future. Work-Life Balance Enjoy paid parental leave, generous vacation time, and paid holidays to recharge and spend time with loved ones. Employee Wellness Access wellness programs and resources to support your physical, mental, and emotional well-being. Invest in Your Growth We offer tuition reimbursement to support your education and career advancement. Student Loan Assistance Our positions qualify for the Public Service Loan Forgiveness (PSLF) program, helping you manage and reduce student debt. Free Travel Perks Receive a FREE SEPTA Transportation Pass, giving you unlimited access to all SEPTA services! Join us and take advantage of these incredible benefits while making a difference in your community!
Join the Best in Transit! Apply Today
Click Apply Now and take the next step in your engineering career with SEPTA!