Macy's is looking for a Senior Developer to build solutions that support the Analytic Systems Solution stack, including Google Cloud Platform (GCP), SAS in a Linux environment, and Tableau Server/Desktop, to analyze large data sets for research, analytics, campaign management, reporting, and tactical and strategic decision-making.
Requirements
- Expertise in designing, building, and automating ETL processes to manage large and complex data sets efficiently.
- Hands-on experience with Google Cloud Platform, including BigQuery, Cloud Composer, and Apache Airflow, to deliver scalable data solutions.
- Strong proficiency in SQL, Unix Shell scripting, and Python; experience with SAS (BASE, MACRO, STAT) to support data analysis and automation.
- Skilled in RDBMS (Oracle, DB2), Hadoop ecosystem (HDFS, TEZ, MapReduce, Sqoop), and Spark/PySpark, with working knowledge of Zeppelin and Jupyter Notebook.
- Ability to perform data profiling, discovery, modeling, transformation, and process automation to support reporting and analysis.
- Experience using Tableau to develop reporting solutions and support business data requirements.
- Strong ability to translate complex business requirements into technical designs, identify trends and issues, and develop data-driven solutions.
Responsibilities
- Design, develop, and implement end-to-end solutions on Google Cloud Platform (BigQuery, Cloud Composer, Apache Airflow), with strong ability to translate business requirements into technical design plans.
- Automate, deploy, and support solutions scheduled on Crontab or Control-M, ensuring proper error handling, dependency controls, and necessary alerts; triage and resolve production issues while implementing preventive measures.
- Build rapid prototypes and proofs of concept to assess project feasibility.
- Document technical design specifications detailing how business and functional requirements are met; create operations run book procedures for each solution deployment.
- Identify and recommend improvements to analytics ecosystem solution design and architecture.
- Participate in product support activities such as patches and release upgrades; provide validation support for Google Cloud and SAS products, as well as related infrastructure, systems, or process changes impacting Analytics infrastructure.
- Contribute to the full SDLC framework using Agile/Lean methodology.
Other
- 6+ years of experience in Data Engineering, ETL Development, and Data Analytics.
- Candidates with a bachelor’s degree or equivalent work experience in a related field are encouraged to apply.
- Able to work a flexible schedule based on department and company needs.
- Excellent written, verbal, and presentation skills with proven ability to partner with Business Analysts, Product Managers, and cross-functional teams.
- Demonstrated ability to work independently with minimal supervision, manage multiple projects, prioritize tasks, and guide offshore resources when needed.
