Sr Data Architect

Be part of the team that drives our company forward, transforming ideas into real-world tools and platforms that support the business and spur innovation.

Remote, NH

CONNECTION

<p><strong>At Connection, our purpose is simple: we connect people with technology. From hardware&mdash;PCs, printers, servers, and more&mdash;to cutting-edge cloud, cybersecurity, and professional IT services, we design, build, and support the IT solutions that thousands of companies, schools, and government agencies rely on every day. We like to think of ourselves as the IT Department for our customers&rsquo; IT Department. Our company started out almost 40 years ago with two employees and a phone line. Today we&rsquo;re a Fortune 1000 IT solutions partner operating in 174 countries around the world&mdash;still driven by that startup mentality and guided by our original purpose.</strong></p> https://www.connection.com/

keywords: position summary,position details,what we do,who we are,why you should join us,leadership,create,collaboration,data,other duties,experience,proficiency,skills

Full Time

Overview: <strong>What We Do:</strong><br /><br />We calm the confusion of IT by guiding the connection between people and technology. If a customer is looking for a better way to manage their warehouse inventory, equip their workforce, or secure their data, we make it happen. All it takes is finding the right combination of tech hardware, software, cloud solutions, and support services. That&rsquo;s what we do. We&rsquo;re the IT Department&rsquo;s IT Department.<br /> <br /><strong>Who We Are:</strong><br /><br />Our team is made stronger by a multitude of backgrounds, experiences, and perspectives. It&rsquo;s what makes Connection unique&mdash;what drives us to innovate and create technology solutions that stand apart from the crowd. We&rsquo;d love for you to be a part of that fabric, to share your ideas and experiences with a team that thrives on fresh thinking, creativity, and helping others.<br /> <br /><strong>Why You Should Join Us:</strong><br /><br />You&rsquo;ll find supportive teammates and a rewarding career at Connection&mdash;plus great benefits. We take pride in supporting employees with a total rewards package that provides financial, emotional, and physical resources for you and your family. Our compensation, 401k plans, medical insurance, and other benefits are progressive and competitive. We value the importance of our employees&rsquo; emotional well-being. To support employees, we provide free therapy visits, mental health coaching and tools, and meditation resources. You&rsquo;ll also enjoy a generous paid time off package that includes not only vacation and sick time, but also Wellness and Volunteer Time Off days. <br /> <br /><br />Working under general supervision of the Director, Applications Integration and Development, the Senior Data Architect utilizes deep, diverse technical experience to navigate the challenge of pushing the organization to envision forward-thinking solutions that meet or exceed our key business performance measures. The Sr Data Architect works closely with technology and business leadership to develop strategies that challenge current thinking, processes, and rules. The Sr Data Architect works across all enterprise domains to drive architecture and design runways that result in implemented business solutions. The Sr Data Architect owns the strategy, design, and implementation of data migration and integration plans across multiple projects. Ownership includes the data migration and integration process throughout the entire project implementation. Provides level-of-effort estimates for data migration and/or data transformation solutions.
Responsibilities: <br /> <ul> <li>Leads the development of current and target state data eco-system architectures covering all aspects of data including data ingestion, data transformation, data warehouse, data analytics, data platform, data management, data security, and AI/ML</li> <li>Develops and implements an overall organizational data strategy that is in line with business processes.</li> <li>Collaborates with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts</li> <li>Manages end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.</li> <li>Defines standards for naming, describing, governing, managing, modeling, cleansing, enriching, transforming, moving, storing, searching, and delivering all data within the enterprise. Builds high-quality data pipelines driving analytic solutions.</li> <li>Coordinates with the data science and analytics teams to identify future needs and requirements.</li> <li>Identifies data sources, both internal and external, and works out a plan for data management that is aligned with organizational data strategy.</li> <li>Creates fault-tolerant, timely, and optimized pipelines for data ingestion powering the company&rsquo;s business analytics. Evangelizes best practices with the engineering, infrastructure, and analyst teams for building data models, pipelines, and materialized views. Standardizes governed access to data across teams and builds tooling to reuse queries.</li> <li>Creates and tests physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency.</li> <li>Researches new technologies, data modeling methods and information management systems to determine which ones should be incorporated into company data architectures and develop implementation timelines and milestones.</li> </ul>
Requirements: <br /> <ul> <li>10+ years of experience in IT platform implementation in a technical and analytical role</li> <li>5+ years of experience with data architecture, data warehousing, and data governance</li> <li>3+ years of design and implementation experience in Data Lake/Hadoop platform implementation</li> <li>3+ years of experience with agile methods, developing end-to-end lifecycle software management, integration testing, and CI/CD automation tools</li> <li>Thorough understanding of database systems and software with an in-depth understanding of database structure principles</li> <li>Proven experience in Azure Data &amp; Storage including Data Factory and Synapse Analytics, Snowflake</li> <li>Experience with Business Intelligence and data visualization tools.</li> <li>Proven experience with designing Data Warehouse Schemas as well as Data Mart schemas (Dimensional Model)</li> <li>Expertise in various data platforms including SQL Server, Oracle, NoSQL, and Open-Source database systems.</li> <li>Experience in designing data pipelines to consume structured/non-structured data in real-time/batch processing, including on-prem and cloud solutions.</li> <li>Experience gathering and analyzing system requirements</li> <li>Experience developing a data strategy and working within and influencing the associated policies.</li> <li>Proficient with database modeling and management tools, such as Erwin or Rational Rose.</li> </ul>