IT Manager, Data Warehousing

Job Description Presidio, Where Teamwork and Innovation Shape the Future AtPresidio, we're at the forefront of a global technology revolution, transforming industries throughcutting-edge digital solutions and next-generation AI. We empower businessesand their customersto achieve more through innovation, automation, and intelligent insights. The Role Presidio IT Manager, Data Warehousing to join our team in a remote capacity We are developing a data warehouse to support our rapidly growing business including SQL databases, d365 data, and Salesforce data. As an IT Manager, Data Warehousing, you will be responsible defining future state data architectures, platforms and integrations that will bring you into contact with a diverse array of stakeholders from each department and product development team. You will work directly with our product development teams to develop advanced analytics and dashboards. In this role you will influence the definition of our Cloud-centric future state operational and analytic data architectures, ultimately helping us provide our business partners with the data and analytic tools they need to optimize and grow their operations. Travel Requirements This position does not require any travel/ In this role you will be expected to travel up to 10% Responsibilities Include - Experience in leading data strategy initiatives including the architecture of modern cloud-based data platforms with technologies such as DataVerse/Data Lakes, ETL/ELT, Modern Data Warehouses and Analytics. - Experience with tools and frameworks of the business intelligence ecosystem that supports real-time analytics and advanced scenarios such as delta update, change tracking, and access performance. - Accountable for leading data analytics, data warehousing, data auditing and other data projects. - Design and configuration of data movement, streaming and transformation (ETL) technologies. - Effectively analyze data for insights and identify structural or data integrity issues. - Shepherding, care and feeding of data warehouse platform and develop plans for remediating identified gaps. - Provide technical database expertise and problem-solving support to resolve Database Management issues and assist in the monitoring of database performance. - Development of the communication plan to the business groups by building presentations of the warehouse structure, creating templates to obtain data, documentation of warehouse model and contents. - Lead and provide mentoring to other team members in the researching of Data Warehouse best practices. Required Skills - Design, implementation and operations of SQL Server, Azure SQL, Azure SQL DW, Data Lake Store (Azure and AWS), Synapse, Azure Data Factory, SSIS, LogicApps, and Alteryx - Functional knowledge of programming scripting and data science languages such as JavaScript, PowerShell, Python, SQL, .NET, Java, Perl, SAS, R, etc. - CI/CD delivery using code management, configuration management and automation tools such as GitHub, Azure DevOps, Jenkins, Maven, etc. - Delivery using modern methodologies especially SCRUM Agile, Waterfall, etc. - Multi-system data integration using industry standards such as Boomi. Professional Experience - Bachelor's Degree or the equivalent work experience and/or military experience - 10 years of experience in leading data strategy engagements involving the architecture of modern data platforms with technologies such as DataVerse/Data Lakes, ETL/ELT Automations and Cloud - Knowledge of cloud security controls including tenant isolation, encryption at rest, encryption in transit, key management, vulnerability assessments, application firewalls, SIEM, etc. - In-depth knowledge of Azure technologies including Azure Data Factory and Synapse - Relevant certifications such as Azure Data Engineer Associate or Azure Solutions Architect Expert preferred. Your future at Presidio JoiningPresidiomeans stepping into aculture of trailblazersthinkers, builders, and collaboratorswho push the boundaries of what's possible. With our expertise inAI-driven analytics, cloud solutions, cybersecurity, and next-gen infrastructure, we enable businesses to stay ahead in an ever-evolving digital world. Here,your impact is real.Whether you're harnessing the power ofGenerative AI, architecting resilientdigital ecosystems, or drivingdata-driven transformation, you'll be part of a team that is shaping the future. Ready to innovate Let's redefine what's nexttogether. About Presidio At Presidio, speed and quality meet technology and innovation. Presidio is a trusted ally for organizations across industries with a decades-long history of building traditional IT foundations and deep expertise in AI and automation, security, networking, digital transformation, and cloud computing. Presidio fills gaps, removes hurdles, optimizes costs, and reduces risk. Presidio's expert technical team develops custom applications, provides managed services, enables actionable data insights and builds forward-thinking solutions that drive strategic outcomes for clients globally. For more information, visit www.presidio.com.