Software Engineer - Senior

Marriott International, Inc.: Senior Software Engineer – Data Platforms (Multiple Positions) Bethesda, MD.

 

DUTIES:

• Develop, debug, and optimize Unix shell scripts to automate system administration tasks, streamline processes, and enhance system efficiency. Responsibilities include tasks such as file manipulation, data processing, system monitoring, and job scheduling.
• Design and implement scalable and secure system solutions for batch and streaming data ingestion pipelines using Snowflake Stream and AWS S3, ensuring robust data management and transfer.
• Re-engineer existing Business Intelligence data structures to enhance reporting capabilities. Author complex financial reports by crafting SQL queries across databases such as Snowflake, MySQL, and PostgreSQL.
• Establish data modeling standards to ensure consistency and efficiency across all data products. Document these standards and processes in Confluence for accessibility and governance.
• Identify and analyze innovative solutions for complex business requirements by evaluating various alternatives and providing recommendations to stakeholders, ensuring alignment with business goals.
• Collaborate with a dedicated team focused on developing cutting-edge cloud-based technologies for the next-generation Business Intelligence (BI) platform, driving innovation and efficiency.
• Facilitate business requirements analysis and functional design sessions, contributing to business presentations, communications, and documentation to bridge gaps between business objectives and technical implementation.
• Leverage Python for comprehensive data analysis, extracting raw data, performing in-depth customer product flow examinations, and contributing to the reporting systems.
• Define and support enterprise-scale cloud solutions in an agile development environment, adhering to best practices and ensuring solutions meet organizational needs.
• Lead Business Intelligence (BI) initiatives, establishing technical standards, designing the semantic data modeling layer, and publishing datasets using tools such as PowerBI and Dremio.
• Validate service provider deliverables and schedules, ensuring high-quality project outcomes by reviewing project plans and providing additional insights and recommendations for optimal results.
• Develop and maintain large-scale data pipelines and applications, focused on processing, transforming, and analyzing data for business intelligence and decision-making.
• Collaborate closely with development teams throughout the software development lifecycle, including requirement analysis, defect resolution, effort estimation, and acceptance testing, to ensure stability and functionality.
• Actively participate in agile ceremonies, such as Program Increment (PI) planning, daily stand-ups, sprint planning, and retrospectives. Convert roadmap features into epics and user stories within JIRA to maintain project focus and deliverable clarity.
• Work closely with the IT Architecture team to address functional requirements and design clarifications, ensuring that technical solutions align with business needs.
• Create comprehensive source-to-target mappings for data integrations, ensuring clarity for all project stakeholders. Document data quality standards and transformation rules to facilitate accurate and efficient integration processes.
• Configure and maintain Splunk for advanced log analysis and troubleshooting, and utilize Dynatrace for real-time application performance monitoring and optimization to ensure system reliability and efficiency.
• Software used:
• Application: Snowflake, Amazone Web Service, Azure Cloud Platform, NIFI.
• Programming Language: SQL, Unix Shell Scripting, Java Scripts, Python, Java, DAX, Power Query
• Reporting and Monitoring Tool: Power BI, Tableau, Dremio, Splunk, Dynatrace, Spreadsheet.
• Database: Oracle, MySQL, PostgreSQL, Amazon Aurora and Athena.
• Version Control: GIT
• Data Modeling: Erwin
• Incident management tool: Jira, ServiceNow.
• Documentation: Confluence.
  • 5 years of experience in business systems analysis or project management on software development projects.

 

REQUIREMENTS: Bachelor’s degree in Computer Science, Computer Engineering, Electrical/Electronic Engineering or related technical field followed by 7 years of progressively responsible experience with application design or development. Other required experience:

• 5 years of experience in Business Intelligence (BI), working with tools such as Power BI and Tableau to drive business insights and data visualization.
• 4 years of experience in business process re-engineering, focused on optimizing and enhancing operational efficiency.
• 4 years of experience using project management tool