IT Manager, Data Warehousing

Description SEIZE THE OPPORTUNITY TO BE A PART OF SOMETHING GREAT Presidio is on the leading edge of a technology-driven movement to transform the way business is done, for our customers and our customers' customers. Joining Presidio means immersing yourself in a culture of self-starters, collaborators and innovators who make real, lasting change in the marketplace via cutting-edge technology and business solutions. At Presidio, we know that it's our people that make the connections happen. WHY YOU SHOULD JOIN US? You will set your career on track for outstanding achievement with a company that knows no limits. Presidio is a leading a global digital services and solutions provider focused on Digital Infrastructure, Business Analytics, Cloud, Security & Emerging solutions. THE ROLE: IT Manager Job Summary: As an internal IT Manager with Presidio , 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 is a remote position. In this role you will be expected to travel up to 10%. Job Responsibilities: 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: Hands on experience with 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. Experience with CI/CD delivery using code management, configuration management and automation tools such as GitHub, Azure DevOps, Jenkins, Maven, etc. Delivery experience using modern methodologies especially SCRUM Agile, Waterfall, etc. Experience with multi-system data integration using industry standards such as Boomi. Extensive experience with enterprise data architecture for transactional systems, analytical platforms, data integration and large-scale data migration. Knowledgeable in multiple data management disciplines such as: Data governance, master data management, data integration, data modeling, SQL and relational database technologies, data warehousing, business intelligence, and analytics. In-depth knowledge of Azure technologies including Azure Data Factory and Synapse Innovative, passionate people leader able to assess, recruit, develop talent and manage high performance teams. Passion for working with the business to find innovative, cutting-edge solutions to improve revenue, control costs and facilitate continuous improvement across all business functions. Strong communication, leadership and influencing skills; ability to work independently in highly ambiguous environments, with both technical and business groups internally and externally. Experience with visualization using technologies such as Power BI, Tableau, and Qlik. Experience leading diverse teams, including the use of third-party resources. Familiarity with sales / supply chain data for VAR/services driven international company. Education and Experience: Bachelor's degree or the equivalent work experience and/or military experience 10 years of experience or more 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. Relevant certifications such as Azure Data Engineer Associate or Azure Solutions Architect Expert preferred. ABOUT PRESIDIO Presidio is committed to Diversity, Equity, and Inclusion at the highest levels and has strengthened its drive to build and drive systemic DEI change process across all levels of the organization. Cultivating a culture of inclusion where the expression of all our differences are valued, celebrated, and add to our collective achievements. Presidio is a global digital services and solutions provider accelerating business transformation through secured technology modernization. Highly skilled teams of engineers and solutions architects with deep expertise across cloud, security, networking and modern data center infrastructure help customers acquire, deploy and operate technology that delivers impactful business outcomes. Presidio is a trusted strategic advisor with a flexible full life cycle model of professional, managed, and support and staffing services to help execute, secure, operationalize and maintain technology solutions. We serve as an extension of our clients' IT teams, providing deep expertise and letting them focus on their core business. Presidio operates in 40 US offices and offices in Ireland, London, Singapore, and India. For more information visit: http://presidio.com Presidio is an Equal Opportunity / Affirmative Action Employer / VEVRAA Federal Contractor. All qualified candidates will receive consideration for this position regardless of race, color, creed, religion, national origin, age, sex, citizenship, ethnicity, veteran status, marital status, disability, sexual orientation, gender identification or any other characteristic protected by applicable federal, state and local statutes, regulations and ordinances. To read more about discrimination protections under Federal Law, please visit: https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf If you have any difficulty using our online system and need an accommodation in the job application process due to a disability, please send an email to recruitmentpresidio.com for assistance. Presidio is a VEVRAA Federal Contractor requesting priority referrals of protected veterans for its openings. State Employment Services, please provide priority referrals to recruitmentpresidio.com. RECRUITMENT AGENCIES PLEASE NOTE: Agencies/3 Parties may not solicit to any employee of Presidio. Any candidate information received from any Agency/3 Party will be considered a gift and property of Presidio, unless the Agency/3 Party is an Authorized Vendor of Presidio with an up-to-date Presidio Contract in hand signed by Presidio Talent Acquisition. No payment will be made to any Agency/3 Party who is not an Authorized Vendor, nor has specific approval in writing from Presidio Talent Acquisition to engage in recruitment efforts for Presidio. LI-PH1 Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)