Job Title: Senior Data Engineer Consultant Company Name: JourneyTeam Job Url: https://journeyteam.prismhr-hire.com/job/1007108/senior-data-engineer?s=in&jr_id=69b9a96f06c1ba00c54ba9fd Job Description: The Senior Data Engineer Consultant plays a pivotal role in driving technical excellence and business value for our clients. Critical aspects of this role entail the ability to discover business requirements and work alongside our clients as you architect and implement modern data engineering solutions within the Microsoft ecosystem. You will also mentor others and lead the solution design and build process as you meet client expectations and project scope.  Key Responsibilities Help set vision, strategy and roadmap for JourneyTeam data engineering. Incorporate both Microsoft and industry best practices.   Architect and implement enterprise data strategies that align with client objectives including analytics, migrations and data integrations.  Collaborate with cross-functional teams, including business intelligence developers, Azure cloud administrators, business analysts, and others, to develop comprehensive data solutions.  Develop “best-in-class” data engineering solutions that provide data quality, reliability, automation, notification, scalability, modularity, security.   Design, develop, and optimize complex dimensional models for reporting (star schemas).  Lead out on design sessions with client teams, conduct workshops and training both internally and externally, including webinars.   Lead and mentor data engineers, provide technical guidance, share best practices, and foster a culture of continuous learning and growth.  Go-to resource for understanding client problems and responding with appropriate methods anchored around best practice, repeatable patterns, and “crush-it” mentality.   Diagramming and documentation champion.  Excellent leadership, communication, and project management skills.  Required Qualifications: Proven track record with at least 7+ years hands-on experience in data engineering, preferably within the Microsoft ecosystem.   3+ years’ experience working with Azure technologies, such as Data Factory, ADLS, Azure Databricks, Spark, Synapse Analytics, Azure SQL Database, Fabric.  Advanced SQL skills. Solid understanding of relational databases, transform logic and dimensional modeling techniques. Ability to write complex SQL.  Architectural design and experience building data orchestration and pipelines using metadata driven techniques.