Data Engineer with SQL and Azure -Redmond, WA Remote

Data Engineer With SQL And Azure

Location: Redmond, WA – Remote

Position Type: Contract

US Citizen, Green Card, TN, GC EAD and H4 EAD only. No third-party agencies corp to corp.

Job Description:

• 9+ years development experience.

• 7+ of SQL Server development experience writing complex stored procedures, triggers, views, etc.

• Strong understanding of BI areas. Ability to work in large, complex development BI projects including the proactive identification of issues and coordination of resolutions.

• Expertise in T-SQL, DW Concepts, Tabular Cube.

• Must have strong experience with Azure – Azure Data Lake / Azure Data Factory.

• Experience with Power BI

• 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.

• Strong communication skills in both written and spoken English.

• Working knowledge on Cosmos / Big Data Platforms (Azure, Databricks) is recommended.

• Excellent communication skills and ability to work under continual deadline constraints are necessary.

Responsibilities:

• Work on complex BI ecosystems and design / develop solutions based on SQL SSIS, Azure Databricks, SQL SSAS

• Design and develop PL / SQL procedures / ETL jobs with optimized processing time

• Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.

• Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.

• Design and code high quality database solutions within a fast paced sprint release cycle

• Proficiency in creating visualizations / reports / dashboards based on business requirements

• Manage errors gracefully. Document code and work completed.

• Conduct thorough unit testing of code and document the unit test cases.

• Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.

• Provide support as needed throughout Test and User Acceptance Testing phases.

• Create Technical Design Specification documentation that clearly articulates the design and code being implemented.

• Provide client communication as appropriate to project.

• 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.

• Assist in architectural design reviews and ensure technology stack selection is relevant.

• Ensure development and testing follow industry standards.