SQL Data Engineer - Main stress is on full stack data engineer i.e. ETL + Cube development on Microsoft Azure tech stack.

Location: Preferably Gurgaon / Hyderabad

Duration – 12 months

Rate - $15/hr.

Work Experience

• 7+ years’ development experience on end to end BI development – Backend Data Engineering
• 5+ of SQL Server development experience writing complex stored procedures, triggers, views, etc.
• Strong experience on Big Data Technologies especially on Azure – Azure Databricks, Azure Datawarehouse / Azure Data Lake / Azure Synapse, Spark, with strong foundation in SQL
• Strong understanding of BI areas.  Ability to work in large, complex development BI projects
• Demonstrated experience in end to end development – Cubes, ETL, Data Integration
• Cube development experience is mandatory
• Knowledge of at least one programming language (e.g. Python, C#) is preferred
• Experience on PowerBI is preferred
• Strong Analytical and troubleshooting skills
• Excellent coding and debugging skills.
• Able to work independently to implement a solution with minimal guidance
• Ability to communicate with Business and developers accordingly.
• Ability to work independently or with minimal supervision.
• Sever as a consultant through the lifecycle of the project and facilitate resolution of any issues/open items by getting relevant teams involved.
• Strong communication skills in both written and spoken English.
• Excellent communication skills and ability to work under continual deadline constraints are necessary, show agility towards meeting business needs

Responsibilities

1. 1. Work on complex BI ecosystems and design / develop solutions based on BI Data technologies based on Azure
   2. Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.
   3. Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
   4. Design and code ETL / Build Data Pipelines and build / modify Cubes
   5. Design and code high quality database solutions within a fast-paced sprint release cycle
   6. Manage errors gracefully. Document code and work completed.
   7. Conduct thorough unit testing of code and document the unit test cases.
   8. Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
   9. Provide support as needed throughout Test and User Acceptance Testing phases.
   10. Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
   11. Provide client communication as appropriate to project.
   12. Be able to translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle large volume data sets that are typical with BI solutions.
   13. Assist in architectural design reviews and ensure technology stack selection is relevant
   14. Ensure development and testing follow industry standards