MA CRE is an innovative technology company that specializes in providing cutting-edge solutions to clients in the real estate industry. We are currently seeking a highly experienced Senior SQL/Airflow Developer to join our growing team. The successful candidate will be responsible for designing, developing, debugging, and maintaining ETL pipelines and scripts on AWS infrastructure to support our data-driven initiatives.Key Responsibilities:Design, develop, and maintain scalable ETL pipelines and data processes using SQL, Airflow, DBT and other related technologies on AWS infrastructureDebug and optimize existing ETL processes in Airflow, AWS Lambda and Glue to improve performance, reliability, and data qualityCollaborate with cross-functional teams to gather requirements and implement robust data solutionsEnsure data integrity and consistency by developing and implementing data validation and error-handling strategiesMaintain and enhance our AWS infrastructure to support the efficient execution of ETL processesStay current with industry best practices, tools, and technologies to drive continuous improvement and innovation within the teamMentor and provide guidance to junior developers in the teamBachelor's degree in Computer Science, Engineering, or a related fieldA minimum of 8 years of experience in SQL development and AWS Redshift.Expertise in Apache Airflow, including the creation of custom operators and plugins and DBT.Strong experience in working with AWS services such as EC2, RDS, S3, and RedshiftIn-depth understanding of database design, optimization, and performance tuning, primarily with Postgres and Redshift.Knowledge of Python and its libraries for data manipulation and processingExperience with version control systems, such as GitExcellent problem-solving and debugging skillsStrong communication and collaboration skills, with the ability to work effectively across teamsNice to Have:Snowflake and Snowpipe experiencedata modeling experienceMoody's Analytics products are becoming an essential tool in the rapidly expanding Commercial Real Estate market. We deliver an integrated and holistic platform that automates critical processes and generates insights and recommendations to drive better decisions. Lenders, asset managers and brokers are some of our biggest customers. Our analytics provide key property performance indicators, research, and risk assessment, giving our customers a good understanding of their future cashflows. We have a team of brokerage and lending solutions experts as well as passionate sales, marketing and technology professionals who constantly strive to add value to our customers' experience.Moody's is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, gender, age, religion, national origin, citizen status, marital status, physical or mental disability, military or veteran status, sexual orientation, gender identity, gender expression, genetic information, or any other characteristic protected by law. Moody's also provides reasonable accommodation to qualified individuals with disabilities or based on a sincerely held religious belief in accordance with applicable laws. If you need to inquire about a reasonable accommodation, or need assistance with completing the application process, please email accommodations@moodys.com. This contact information is for accommodation requests only, and cannot be used to inquire about the status of applications. For San Francisco positions, qualified applicants with criminal histories will be considered for employment consistent with the requirements of the San Francisco Fair Chance Ordinance. This position may be considered a promotional opportunity, pursuant to the Colorado Equal Pay for Equal Work Act. Click here to view our full EEO policy statement. Click here for more information on your EEO rights under the law. Click here to view our Pay Transparency Nondiscrimination statement.Moody's is a developmental culture where we value candidates who are willing to grow. So, if you are excited about this opportunity but don't meet every single requirement, please apply! You may be a perfect fit for this role or other open roles. Moody's is a global integrated risk assessment firm that empowers organizations to make better decisions.At Moody's, we're taking action. We're hiring diverse talent and providing underrepresented groups with equitable opportunities in their careers. We're educating, empowering and elevating our people, and creating a workplace where each person can be their true selves, reach their full potential and thrive on every level. Learn more about our DE&I initiatives, employee development programs and view our annual DE&I Report at moodys.com/diversityFor US-based roles only: the anticipated hiring base salary range for this position is $108,500 to $179,600, depending on factors such as experience, education, level, skills, and location. This range is based on a full-time position. In addition to base salary, this role is eligible for incentive compensation. Moody's also offers a competitive benefits package, including not but limited to medical, dental, vision, parental leave, paid time off, a 401(k) plan with employee and company contribution opportunities, life, disability, and accident insurance, a discounted employee stock purchase plan, and tuition reimbursement.PDN-991b3c4b-f132-42dd-aaa8-b01b848dee1f