Title: Lead Data Engineer LOCAL INDIANA CANDIDATES ONLY - HOME ADDRESS REQUIRED Job Description:We are seeking a qualified candidate for the role of Data Warehouse Engineer. The client is just getting started with their data warehouse and dashboarding strategies. We have a strong understanding of the data but are looking for expertise in getting that data into our Azure Synapse subscription. Through another project the data warehouse has been created. The clients data strategy is to make our data more actionable by making it more accessible. We are seeking an individual who can guide and educate an IT Data Team, a Database Team and collaborate with an Infrastructure Team on effective designs.The essential functions of this role are as follows: Work with various IT teams (data, database and infrastructure) in analyzing the agencys use of the data warehouse. Provide guidance and education on warehouse environments using industry standards and best practices. Research leading edge capabilities, within the Indiana Office of Technology purview and guidelines, to determine the best solution for the overall environment. Set technology architectural direction, delivering assessment recommendations. Develop a project/implementation plan for setting up the warehouse including ideal data pipelines and other data and visual interfaces. Follow through on setting up the agencys warehouse environment as per the agencys initiative. Configure and setup Azure Synapse with correct structure. Participate with Data Analyst(s) as needed to define minimal viable data assets in support of the visual needs. Review and provide architectural guidance for all analytic solutions. Advise management as needed of any shortcomings with current tools and/or approaches related to the business initiatives