Short Description
Microsoft is seeking a Data Engineer who can design efficient and standardized, data structures, and database schemas.Job Description
- Design, architect, implement and support key datasets that provide structured and timely access to actionable business information with the needs of the end customer always in view
- Build ETLs/ELTs to take data from various telemetry streams, data lakes and supporting data sources and craft a unified dimensional or star schema data model for analytics and reporting
- Develop a deep understanding of vast data sources (existing on the cloud) and know exactly how, when, and which data to use to tackle particular business problems
- Design efficient and standardized, data structures, and database schemas
- Develop high performing and functional code
- Collaborate on delivering technical excellence across the organization
- Ability to lead a team of BI developers to ensure timely, accurate and within scope delivery of all sprint items
- Work with Business Engagement and Business stakeholders to understand the requirement, translate them into technical requirements, and partner with our PMs to plan delivery commitments
- Thought leadership, creation, and execution on new platform capabilities
- Continuously evaluate our processes and reporting to identify opportunities to improve, enhance, and automate existing and new deliverables
- Collaborate with various functions at Microsoft to develop sound business tools
- Establish and operate data quality assurance processes
- Bachelor's degree or equivalent experience
- 5+ years of experience working in BI projects including analytics, data warehousing applications.
- Mastery of Business Intelligence technologies
- SQL Server and Azure SQL Services
- SSAS, DAX, SQL, SSIS, PowerShell
- Cosmos, Azure Data Lake, Spark, Data Bricks
- Excel, Power BI, Power Query
- Experience managing technical BI/database development resources
- Knowledge of Microsoft data assets/systems preferred
- Ability to work independently and collaboratively with cross-functional teams
- Ability to manage multiple and competing projects/priorities
- Strong communication, cross-group collaboration and interpersonal skills
Data Engineer