Senior Data Engineer
Location:
Atlanta, GA (onsite)
Duration:
6+ Months
About the Role:
This role offers the opportunity to leverage the latest AWS and Big Data technologies and work closely with our Business Intelligence team to enhance our decision-making capabilities.
What You Will Do
- Work with Business analysts and BI team to develop data solution and documentation.
- Analyze features and user requirements to create user stories, design specifications and provides effort estimation for development.
- Data profiling to understand source data grain, enhance or modify existing data model
- Develop business intelligence and data warehousing solutions to meet business needs.
- Expert in building Data Modeling, Data Marts, Data warehouses and ETL jobs.
- Experience defining systems strategy, developing systems requirements, designing, and prototyping, testing, training, defining support procedures and implementing practical business solutions under tight deadlines
- Design and maintain logical, conceptual, and physical data models
- Develop technical specifications to meet functional requirements for reporting and analytics.
- Ensures timely delivery in compliance with specifications and project plans.
- Write complex SQL code (including stored procedures, functions, performance optimization).
- Develop well designed, flawless, secure, testable, and efficient code.
- Build and modify data pipelines and ETLs for loading source system data into the data warehouse for further reporting and analysis.
- Maintain, monitor and troubleshoot existing ETL jobs, BI models and reports.
- Develop standard reports and dashboards based on business requirements.
- Troubleshoot, fix and explain failures/errors in data or dashboards.
- Develop unit test plans and perform unit testing for robustness, including edge cases, usability, and general reliability
- Develop and maintain technical development standards, implement best practices, and create support processes and documentation
- Apply critical thinking to solve complex problems and communicate effectively with various teams at different levels.
Who You Are (Basic Qualifications)
- 8+ years Experience in modeling BI solutions for data from SAP ERP modules like FI, CO, FSCM, PP, MM, PM , QM etc.
- Experience implementing SAP HANA Analytics, plus SAP S/4 HANA, BOBJ
- Strong understanding of Data Warehousing, Data Modelling, HANA modeling, HANA studio; hands on experience in SAP HANA
- Good Understanding of ABAP, SQL based coding principles, table functions, performance tuning
What Will Put You Ahead
- Experience in an Agile environment, git, DevOps / CICD experience
- Administration of SAP Enterprise HANA, SLT Replication server and SDI configuration, maintenance
- Experience in AWS, Glue, Python, Spark, Redshift and other AWS services like Step function, Lambda etc.
- Experience with SSAS tabular model, Power BI dashboards and other data visualizations, actions, bookmarks, paginated reports, Power BI Report Server (PBRS), DAX Queries
