Sr. ETL Developer and Data Architect

4 weeks ago

Portsmouth, United States SigSauer Full time
Job DescriptionJob Description

Sr. ETL Developer and Data Architect

Remote

SIG SAUER, Inc. is a leading provider and manufacturer of firearms, electro-optics, ammunition, airguns, suppressors, remote controlled weapons stations, and training. For over 250 years SIG SAUER, Inc. has evolved, and thrived, by blending American ingenuity, German engineering, and Swiss precision. Today, SIG SAUER is synonymous with industry-leading quality and innovation which has made it the brand of choice amongst the U.S. Military, the global defense community, law enforcement, competitive shooters, hunters, and responsible citizens. Additionally, SIG SAUER is the premier provider of elite firearms instruction and tactical training at the SIG SAUER Academy and is named Headquartered in Newington, New Hampshire, SIG SAUER has over 3,200 employees across twelve locations in three states and is a certified Great Place to Work™. For more information about the company and product line visit: sigsauer.com.

Position Summary:
This position will report directly to the Senior Manager of ETL Development and Data Architecture on the Business Intelligence (BI) team. The Sr. ETL Developer and Data Architect will help the IT BI Team resolve existing capacity issues and design for the future. In this role, you will be responsible for working with a team of analysts, data scientists, and report developers. This role will focus on building 'true' data analytics, data science, and data engineering environment to support the IT organization. You will lead the efforts in building the back end to set the stage for a 'self-service' environment for our end users. You will also be responsible for defining and for extending the enterprise data model for new capabilities and will work with both onshore and offshore resources to achieve our goals.

Job Duties & Responsibilities:

  • Responsible for designing the overall architecture of the EDW.
  • Oversee the data modeling process, ensuring that the data structures support the analytical needs of the organization.
  • Lead the integration of data from various source systems into the EDW. This involves designing and developing ETL (Extract, Transform, Load) processes or ELT (Extract, Load, Transform) processes to move data into the warehouse while ensuring data quality and consistency.
  • Optimize the performance of the EDW. This includes tuning queries, designing indexes, partitioning tables, and implementing caching strategies to ensure fast and efficient data retrieval.
  • Ensure that data governance policies and security standards are implemented within the EDW.
  • Provide technical leadership to the data engineering team.
  • Build highly scalable solutions using micro-service architecture designed to democratize data to everyone in the organization.
  • Collaborate with business and IT stakeholders across the organization (e.g., business analysts, data scientists, IT managers) to understand their data needs and deliver solutions that meet those requirements.
  • Drive continuous improvement initiatives within the data engineering team and the EDW implementation.
  • Acts as a subject matter expert on data querying and analytics.
  • Identifies the most impactful use of data to solve complex problems.
  • Identify insights, opportunities and risks to the business, present findings, and recommendations to senior leadership.
  • Ensure that documentation related to the EDW implementation (e.g., data dictionaries, ERDs, technical specifications) is maintained and up to date and complies with internal standards and industry regulations.
  • Experience designing or developing a reporting semantic layer is a plus.
  • Experience with reporting tools such as IBM Cognos, SAP Business Objects, Tableau, or Microsoft Power BI is a plus.

Education and/or Experience:

  • 8+ years’ experience in a combination of business insights, advanced analytics, data analysis, statistics, strategy, and consulting.
  • 2+ years of experience as a project lead.
  • Bachelor’s degree in computer science, information systems, or data analytics is required.
  • Must be an experienced data warehousing professional with some leadership experience (7+ years).
  • Must be an experienced data architect (3+ years).
  • Must have experience building and architecting ETL data flows in at least 2 ETL tools such as SAP Business Objects Data Services (BODS), SQL Server Integration Studio (SSIS), Informatica, Ab Initio, IBM Infosphere DataStage (5+ years) or similar enterprise class ETL Tools.
  • Experience with big data platforms (Hadoop, GCP, AWS, Big Query, Azure) preferred.
  • Data visualization experience using tools such as Tableau or Microsoft PowerBI is a plus.
  • Demonstrate leadership and ability to earn respect and influence across functions/teams.
  • Client service mentality, adaptability, and willingness to collaborate openly with other functions.
  • Entrepreneurial mindset with ability to quickly digest, organize, and deliver requests with little oversight.
  • Experience with ETL and data warehouse concepts, preferably with an Oracle database or Microsoft SQL Server database.
  • Data modeling - Expertise in data model design with sensitivity to usage patterns and goals - schema, scalability, immutability, idempotency, etc.
  • Strong business acumen, preferably with experience working in a consumer product goods retail environment and / or in a manufacturing environment.
  • Excellent written and communication skills.

Working Conditions:

  • Able to lift up to 25 pounds.
  • Must wear Personal Protective Equipment (PPE) in designated areas.

SIG SAUER, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

  • Business Intelligence Analyst II

    1 week ago

    Portsmouth, United States Lonza America Inc Full time

    Business Intelligence Analyst II (US2367) Job Description: The Business Intelligence Analyst II is a versatile role which works closely alongside other data experts, such as Architects or Engineers, to deliver data and analytics solutions; primarily in the form of dashboards, reports and KPIs. The BI Analyst II frequently interacts with stakeholders across...

  • Sr. Analyst, Master Data Management

    1 month ago

    Portsmouth, United States SigSauer Full time

    Job DescriptionJob DescriptionSr. Analyst, Master Data ManagementMust reside in Mountain or Pacific Time zoneSIG SAUER, Inc. is a leading provider and manufacturer of firearms, electro-optics, ammunition, airguns, suppressors, remote controlled weapons stations, and training. For over 250 years SIG SAUER, Inc. has evolved, and thrived, by blending American...

  • Cloud Solutions Architect

    7 days ago

    Portsmouth, Virginia, United States Bottomline Full time

    We are seeking a Cloud Solutions Architect to drive innovation and growth within our organization.Bottomline Technologies is at the forefront of facilitating critical business transactions. Our mission is to assist clients in optimizing their financially driven operations while fostering robust relationships with customers and partners through a...

  • Head of Data Insights

    3 months ago

    Portsmouth, United States Lonza Full time

    Today, Lonza is a global leader in life sciences operating across three continents. While we work in science, there’s no magic formula to how we do it. Our greatest scientific solution is talented people working together, devising ideas that help businesses to help people. In exchange, we let our people own their careers. Their ideas, big and small,...

  • Solutions Architect

    4 weeks ago

    Portsmouth, United States Bottomline Full time

    We are looking for a Solution Architect (SA) to innovate, win and grow with us!Bottomline Technologies powers mission critical business transactions. We help our customers optimize financially oriented operations and build deeper customer and partner relationships by providing a trusted and easy to use set of cloud-based digital banking, fraud prevention,...

  • Solutions Architect

    3 weeks ago

    Portsmouth, United States Bottomline Full time

    We are looking for a Solution Architect (SA) to innovate, win and grow with us!Bottomline Technologies powers mission critical business transactions. We help our customers optimize financially oriented operations and build deeper customer and partner relationships by providing a trusted and easy to use set of cloud-based digital banking, fraud prevention,...

  • Sr. Mobile Developer

    1 day ago

    Portsmouth, United States Market Street Talent, Inc. Full time

    Could you be a good fit? We are looking for the best, highly skilled Senior Mobile Application Developer to join the team of our exceptional client located in the greater Portland ME area. This is a fully remote role. Benefits:RemoteHealthcare Medical including HSADental and Vision Insurance401kWhat will your day look like? As a Senior Mobile Application...

  • Sr. Mobile Developer

    24 hours ago

    Portsmouth, United States Market Street Talent, Inc. Full time

    Could you be a good fit? We are looking for the best, highly skilled Senior Mobile Application Developer to join the team of our exceptional client located in the greater Portland ME area. This is a fully remote role. Benefits:RemoteHealthcare Medical including HSADental and Vision Insurance401kWhat will your day look like? As a Senior Mobile Application...

  • Functional Architect

    2 months ago

    Portsmouth, Virginia, United States Amadeus Full time

    Job TitleFunctional ArchitectAbout Your Business Area/Department:Amadeus Hospitality provide world class products to support the needs of our clients. We provide Central Reservation Systems, Sales & Catering solutions, Guest service and communication items and more. The Functional Architect team provides ways for these tools to communicate to other Property...

  • Manager, Engineering

    3 months ago

    Portsmouth, United States Liberty Mutual Insurance Full time

    Pay Philosophy The typical starting salary range for this role is determined by a number of factors including skills, experience, education, certifications and location. The full salary range for this role reflects the competitive labor market value for all employees in these positions across the national market and provides an opportunity to...

  • Cyber Data Scientist

    3 weeks ago

    Portsmouth, United States Centripetal Networks Full time

    Job DescriptionJob DescriptionDo you want to be at the forefront of intelligence-driven cybersecurity research?We at Centripetal are innovators of disruptive cybersecurity solutions.  Our CleanINTERNET managed service operationalizes billions of threat indicators in real-time to prevent over 90% of known threats against enterprise networks.  Our customers...

  • Business Intelligence

    1 week ago

    Portsmouth, United States Sprague Full time

    Sprague is growing, and we need your energy to make it happen! Sprague is passionate about delivering diverse products and programs that warm, power and move the world. We keep homes warm through Northeastern winters and hospitals cool through summer. We help small businesses focus on serving their communities, and our renewable fuels keep our country's...

  • BI Developer

    1 month ago

    Portsmouth, United States ConvenientMD Full time

    Job DescriptionJob DescriptionWho We Are At ConvenientMD, we’re on a mission to make good health more convenient for all – working to improve how patients and providers experience healthcare in New England. To support this belief, we’re building a team of dedicated professionals who genuinely care about improving lives, are passionate about work that...

  • Sr. Manager of DevOps

    2 months ago

    Portsmouth, United States Market Street Talent, Inc. Full time

    Could you be a good fit? We are looking for the best, highly skilled Senior Manager of DevOps to join the team of our exceptional client for a full time opportunity located in Portsmouth, NH.Benefits:Healthcare MedicalDental and Vision InsuranceLife InsuranceShort Term Disability401k plan with company matchWhat will your day look like? As a Senior Manager of...

  • Data Quality Analyst

    2 weeks ago

    Portsmouth, Virginia, United States FedPoint Full time

    FedPoint FedPoint, a leading third-party benefits administrator is seeking a meticulous and proactive Data Quality Analyst to join our dynamic team. This role is crucial in maintaining the accuracy of premium and enrollment data feeds and reports. As a Data Quality Analyst, you will handle data reconciliations, resolve discrepancies, manage system changes,...

  • Maintenance Developer

    3 months ago

    Portsmouth, United States ITA International, LLC Full time

    Overview ITA International leverages subject matter expertise, data analytics and technology to make what may seem impossible, possible. ITA is seeking a Maintenance Developer to join the team in Portsmouth, VA. Responsibilities - Provide Planned Maintenance Support Services (PMSS) services and support for C5ISC’s assets and systems for...

  • Investment Data Specialist

    7 days ago

    Portsmouth, United States Prime Buchholz Full time

    Job DescriptionJob DescriptionDescription:The JobThe Information Group is an evolving department tasked with centralizing vital data relied upon by all teams at the firm. As an essential part of the Information Group, the Investment Data Specialist is responsible for aggregating and reporting investment manager and market data while maintaining accuracy and...

  • Senior Network Engineer

    2 weeks ago

    Portsmouth, United States Omada Technologies Full time

    A Sr. Network Engineer is expected to work in both pre-sales and post-sales engineering roles at Omada Technologies, seeing a project through from an initial design to implementation and documentation. As such, the Sr. Network Engineer will have not only good technical skills, but also will have excellent communication and inter-personal skills. She/He/They...

  • Senior Network Engineer

    2 weeks ago

    Portsmouth, United States Omada Technologies Full time

    A Sr. Network Engineer is expected to work in both pre-sales and post-sales engineering roles at Omada Technologies, seeing a project through from an initial design to implementation and documentation. As such, the Sr. Network Engineer will have not only good technical skills, but also will have excellent communication and inter-personal skills. She/He/They...

  • Curriculum Development Specialist

    2 days ago

    Portsmouth, Virginia, United States Portsmouth Public Schools Full time

    Job Title: Secondary Science CoordinatorCompany: Portsmouth Public SchoolsJob Summary:The Secondary Science Coordinator is a key leadership role responsible for providing strategic direction and support to the development and implementation of the science curriculum program for the school division. This position involves collaborating with teachers, staff,...