Job description
United States, Georgia, Atlanta
Information Technology
02-May-2023
Ref #: 20491
LinkedIn Tag: #LI-JM2
How you'll help us Keep Climbing (overview & key responsibilities)
Delta IT is on a journey of transformation. We are changing the way we do business from top to bottom. As leaders with vision within Delta, we strive to build important and innovative solutions and are looking for team members to help us realize our vision.
Delta employees are problem solvers, doers, innovators.
We are proactive.
We are collaborative.
We deliver impact to our customers.
Join us on our transformation journey in becoming a best-in-class IT organization at the world's best airline!
The Senior Data Engineer, Modeler to join our Enterprise Data team. This position is responsible for building, modifying, modernizing the conceptual, logical, and physical data models used in Enterprise Data databases. The position also requires establishing and maintaining effective partnerships with the Business and IT stakeholders.
We are looking for someone with strong analytical and organizational skills to transform data into insights, distill requirements, and develop processes. The candidate should have excellent communication skills, business maturity, and feel comfortable in a fast-paced environment.
Responsibilities
- Understand the data needs of the company for ingestion, migration, storage, and access
- Work with business teams to gather requirements for the database design and model
- Collaborate with the Enterprise Data team and business teams to define requirements, then design and build database models
- Design and build conceptual, logical, and physical data models in accordance with companys data standards
- Apply relational and dimensional models for raw ingestion and curated/semantic layers
- Create Physical Data Structures (DDLs) and corresponding metadata
- Creating and maintaining data reference architecture architectures and integration patterns
- Updating knowledge by tracking and understanding emerging large data and modeling practices and standards
Benefits and Perks to Help You Keep Climbing
Our culture is rooted in a shared dedication to living our values Honesty, Integrity, Respect, Perseverance, and Servant Leadership every day, in everything we do. Exploring a career at Delta gives you a chance to see the world while providing great Benefits to help you keep climbing along the way:
- Competitive salary, industry-leading prot sharing, and 401(k) with generous direct contribution and company match
- Comprehensive health & wellness Benefits including medical, dental, vision, short/long term disability and life Benefits
- Domestic and International Flight privileges for employees and eligible family members
- Career development programs are available for your long-term career goals
- Access to subsidized and vetted Backup Care for children, adults, and pets through Care.com
What you need to succeed (minimum qualifications)
- 7 or more years of experience in Information Technology or related technical capacity
- Expert in concepts and principles of data modeling
- Knowledge of entity relationship, dimensional modeling, big data, enterprise data, and physical data models
- Knowledge of relational databases and data architecture computer systems, including SQL Familiarity
- Ability to design, build, and develop a new product, technology, or service from feasibility through to production
- Familiarity with data modeling software such as SAP PowerDesigner, Microsoft Visio, E/R Studio or Erwin Data Modeler
- Must have hands-on experience with cloud platforms; AWS preferred
- Knowledge of big data platforms such as Teradata, Oracle DB, DB2, AWS Aurora, AWS Athena, etc.
- Experience using Python and/or PowerShell scripting for data processing
- Strong attention to detail
- Excellent communication with both technical and business stakeholders
- Ability to work in a fast-paced environment
- Ability to work both independently and as part of a team
- Understanding of the business and the ability to assess and address risk without negatively impacting the business
- Embraces diverse people, thinking and styles
- Consistently makes safety and security, of self and others, the priority
- Where permitted by applicable law, must have received or be willing to receive the COVID-19 vaccine by date of hire to be considered for U.S.-based job, if not currently employed by Delta Air Lines, Inc.
- Is at least 18 years of age and has authorization to work in the United States.
What will give you a competitive edge (preferred qualifications)
- Bachelors or masters degree in Information Technology, Computer Science, Mathematics, Engineering, Information Systems, or equivalent
- In-depth understanding of ETL and data ingestion processes used in large scale data warehouses
- Knowledge of data architecture principles for on-prem and cloud solutions
- Flexibility to adapt and plan for changing business objectives
- Solid Understanding of Agile/Scrum development methodologies
- Experience translating business outcome requirements into data model requirements
- Ability to adapt communication style for technical and business audiences
< Go back
smogtown13.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, smogtown13.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, smogtown13.com is the ideal place to find your next job.