Responsibilities

Data Solution Consulting & Delivery

Activity participate in the agile planning process by understand data consumers' needs and technical (not just an order taker must be proactive and think critically)
- Must align requirements to stories and turn them into work items
Develop data models (landing), ingestion and integration solutions consistent with existing design patterns
- Develop solutions that maximize automation, orchestration and efficiently use the data management toolset
- Ensure new solutions align to data management best practices
Perform QA and data validation of new solutions
Contribute to knowledge base with complete documentation of solutions

Steady State Support

Monitoring of data pipelines and reporting of performance trends
Ongoing support (includes break/fix) & enhancement of production data pipelines

Key Skills / Technologies

Required

Demonstrated success in implementing ETL and data solution
SQL Expert (including table and view creation, functions & stored procedures)
Data modeling (conceptual, logic and physical)
Strong experience with:
- MS SQL Server
- Azure Data Factory
- Visual Studio
Demonstrated ability to work with on-premise and cloud technology (e.g., APIs), and various data formats (XML, Excel, json, text)
Experience with Excel; i.e., data analysis and validation
Strong time manage skills and Agile experience

Desired

Experience with PowerShell a plus
Azure Data PaaS solutions (Storage accounts, Automation) a plus
Experience with Azure DevOps and ServiceNow
Basic experience presenting data with Power BI and PowerPoint

Required Skills : Azure, Data factory, SQL,

Basic Qualification : SQL background w/ experience doing stored procedures, functions/history tables/xml, etc. Good communication. Data pipeline enhancement

Additional Skills : SQL background w/ experience doing stored procedures, functions/history tables/xml, etc. Good communication. Data pipeline enhancementLarge corporation w/ endless opportunity. 1-round interviews. Next in line to a lead architect. Opportunity for extension within organization internally, opportunity for contract extension year-to-year based on performance. Smaller team.

Background Check :Yes

Drug Screen :Yes

Notes

Selling points for candidate :Large corporation w/ endless opportunity. 1-round interviews. Next in line to a lead architect. Opportunity for extension within organization internally, opportunity for contract extension year-to-year based on performance. Smaller team.

Project Verification Info

Exclusive to Apex :Yes

Face to face interview required :No

Candidate must be local :No

Candidate must be authorized to work without sponsorship ::No

Interview times set : :No

Type of project :Development/Engineering

Master Job Title :Dev: SQL Server Reporting

Sr. Data Engineer

Job description