Global IT Data Engineer Senior Specialist

4 weeks ago


Boston MA United States Boston Consulting Group Full time
WHAT YOU'LL DO
  • Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow.
  • Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.
  • Actively monitor and triage technical challenges in critical situations that require immediate resolution.
  • Evaluate viable technical solutions and share MVPs or PoCs in support of the research
  • Develop relationships with external stakeholders to maintain awareness of data and security issues and trends
  • Review work from other tech team members and provide feedback for growth
  • Implement Data Performance, Data security policies that align with governance objectives and regulatory requirements

YOU'RE GOOD AT
You have experience in data warehousing, data modeling, and the building of data engineering pipelines. You are well versed in data engineering methods, such as ETL and ELT techniques through scripting and/or tooling. You are good in analyzing performance bottlenecks and providing enhancement recommendations; you have a passion for customer service and a desire to learn and grow as a professional and a technologist.
  • Strong analytical skills related to working with unstructured datasets.
  • Collaborating with product owners to identify requirements, define desired outcomes and deliver trusted results.
  • Building processes supporting data transformation, data structures, metadata, dependency and workload management.
  • In this role, SQL is heavily focused. An ideal candidate must have hands-on experience with SQL database design. Plus, Python.
  • Demonstrably deep understanding of SQL (level: advanced) and analytical data warehouses (Snowflake preferred).
  • Demonstrated ability to write new code i.e., well-documented and stored in a version control system (we use GitHub & Bitbucket)
  • Extremely talented in applying SCD, CDC and DQ/DV framework.
  • Familiar with JIRA & Confluence.
  • Must have exposure to technologies such as dbt, Apache airflow, and Snowflake.
  • Desire to continually keep up with advancements in data engineering practices.
  • Knowledge of AWS cloud, and Python is a plus.

YOU BRING (EXPERIENCE & QUALIFICATIONS)
Essential Education
  • Bachelor's degree or equivalent combination of education and experience.
  • Bachelor's degree in information science, data management, computer science or related field preferred.
Essential Experience & Job Requirements
  • 5+ years of IT experience with major focus on data warehouse/database related projects
  • Must have exposure to technologies such as dbt, Apache Airflow, Snowflake.
  • Experience in data platforms: Snowflake, Oracle, SQL Server, MDM etc
  • Expertise in writing SQL and database objects - Stored procedures, functions, and views. Hands-on experience in ETL/ELT and data security, SQL performance optimization and job orchestration tools and technologies e.g., dbt, APIs, Apache Airflow, etc.
  • Experience in data modeling and relational database design
  • Well-versed in applying SCD, CDC, and DQ/DV framework.
  • Demonstrate ability to write new code i.e., well-documented and stored in a version control system (we use GitHub & Bitbucket)
  • Good to have experience with Cloud Platforms such as AWS, Azure, GCP and Snowflake
  • Good to have strong programming/ scripting skills (Python, PowerShell, etc.)
  • Experience around responsibility for analyzing and interpreting worker, candidate, or HR, Workday data, to provide valuable insights and support strategic decision-making.
  • Experience working with agile methodologies (Scrum, Kanban) and Meta Scrum with cross-functional teams (Product Owners, Scrum Master, Architects, and data SMEs)
  • Excellent written, and oral communication and presentation skills to present architecture, features, and solution recommendations

YOU'LL WORK WITH
  • Global functional product portfolio technical leaders (Finance, HR, Marketing, Legal, Risk, IT), product owners, functional area teams across levels
  • Global Data Product Portfolio Management & teams (Enterprise Data Model, Data Catalog, Master Data Management)
  • Consulting and internal Data Product Portfolio teams across BCG



  • Boston, MA, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow . Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical...


  • Boston, MA, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow . Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical...


  • Boston, United States Boston Consulting Group Full time

    WHAT YOU'LL DO The BCG Data Team is an integral part of BCG’s global operations. The team is responsible for developing and maintaining the BCG internal data platform. Our team consists of members from Boston, London, Munich, and New Delhi working together in a highly collaborative environment. We are responsible for setting the standards and guardrails...


  • Boston, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow. Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical situations that...


  • Boston, United States Boston Consulting Group Full time

    WHAT YOU'LL DO Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow. Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. Actively monitor and triage technical challenges in critical situations that...


  • Boston, MA, United States Ask IT Full time

    Position: Senior Data Analyst- STRICTLY LOCALS NEEDEDLocation: Boston, MA (Candidates from Rhode Island RI, New Hampshire NH, Connecticut CT and Massachusetts can be submitted)Position Type: 12+ MonthClient: State of Massachusetts/ Department of Conservation and RecreationMode of Interview: Direct F2FPrimary Skill : Data Analysis, process flow diagraming,...


  • Boston, MA, United States State Street Corporation Full time

    Role Description: State Street Global Advisors is seeking an experienced hands-on, dynamic and well connected data architect to join Technology team to participate in the design and implementation of large data initiatives. Main Duties and Responsibilities: End to end data architecture design & implementation including data ingestion, data modeling and...

  • DATA ENGINEER III

    1 week ago


    , RI, United States FM Global Full time

    FM Global is a leading property insurer of the world's largest businesses, providing more than one-third of FORTUNE 1000-size companies with engineering-based risk management and property insurance solutions. FM Global helps clients maintain continuity in their business operations by drawing upon state-of-the-art loss-prevention engineering and research;...


  • United, United States Saxon Global Full time

    Client: Vanguard Group Position: Senior Data Engineer Location: Malvern PA (Hybrid 2 Day's) Rate: $65 C2C Visa: No H1 Duration: 12+ Months • Interview Process:video,1- 2 step process. Coding challenges during 1st round. • When Interview: Week of 2/19, ASAP manager needs candidates right away • Years of Experience: 8+ years •...

  • Senior Data Engineer

    4 weeks ago


    Boston, MA, United States Selby Jennings Full time

    Overview: Our client, one of Boston's longest tenured private asset managers, is looking for a motivated Senior Data Engineer to join their Enterprise Data team to develop and support critical data processing and warehousing applications Responsibilities: Designing and implementing Python and SQL solutions Proficiency with data collection, data wrangling,...

  • Senior Data Engineer

    13 hours ago


    Boston, United States Storm2 Full time

    ⚡ Senior Data Engineer🎯 Series B FinTech Hyper Growth🌎 Boston, MA Hybrid💸 Salary: $140-180k base + equityCompany:Join a dynamic and rapidly growing fintech company backed by $130M in funding. The company is revolutionizing the financial industry with cutting-edge technology and innovative solutions. They have been recognized by Forbes Fintech 50...

  • Senior Data Engineer

    17 hours ago


    Boston, United States Storm2 Full time

    ⚡ Senior Data Engineer🎯 Series B FinTech Hyper Growth🌎 Boston, MA Hybrid💸 Salary: $140-180k base + equityCompany:Join a dynamic and rapidly growing fintech company backed by $130M in funding. The company is revolutionizing the financial industry with cutting-edge technology and innovative solutions. They have been recognized by Forbes Fintech 50...


  • Boston, MA, United States State Street Corporation Full time

    Job Description We are currently seeking an individual in Technology Development to join our SSGA Front Office IT development team for Fixed Income, Cash and Currency applications. The individual will be responsible for working on application development activities for existing applications and emerging projects to provide solutions and lead architecture and...


  • Boston, MA, United States Haemonetics Full time

    We are constantly looking to add to our core talent. If you are seeking a career that is challenging and rewarding, a work environment that is diverse and dynamic, look no further — Haemonetics is your employer of choice.Job DetailsThe Global Marketing for Structural Heart (SH) is responsible for developing and executing global SH marketing strategies....


  • Boston, MA, United States Syska Hennessy Group Full time

    Senior Mechanical Engineer – Critical Facilities Watch your work come to life in landmark projects around the world when you partner with Syska Hennessy Group! As a global leader in consulting, engineering, and commissioning services, we specialize in MEP, information and communication technology, architectural lighting, vertical transportation, and...


  • Phoenix, AZ, United States Nestlé IT Full time

    Sr. Specialist Network EngineerNestlé Information Technology is the digital arm of the world’s largest nutrition, health, and wellness company. With 150+ years in business, 2,000+ brands, and 270,000+ diverse team members—you’re joining an organization that’s revolutionizing food and championing global humanitarian efforts with technology at its...


  • Phoenix, AZ, United States Nestlé IT Full time

    Sr. Specialist Network EngineerNestlé Information Technology is the digital arm of the world’s largest nutrition, health, and wellness company. With 150+ years in business, 2,000+ brands, and 270,000+ diverse team members—you’re joining an organization that’s revolutionizing food and championing global humanitarian efforts with technology at its...


  • Boston, MA, United States Syska Hennessy Group Full time

    Senior Electrical Engineer – Critical FacilitiesWatch your work come to life in landmark projects around the world when you partner with Syska Hennessy Group! As a global leader in consulting, engineering, and commissioning services, we specialize in MEP, information and communication technology, architectural lighting, vertical transportation, and...


  • Boston, United States Fidelity TalentSource LLC Full time

    Job Description:Position Description: ***Applicants are permitted to work remotely from an at-home work site anywhere in the United States.*** Collaborates with customers, data engineers, architects, and analysts to support the development and implementation of data store and access capabilities from legacy (on-premise systems), analytical (Cloud), and...

  • Reverse Engineer

    3 weeks ago


    Boston, United States Motion Recruitment Partners LLC Full time

    ? Job Opportunity: Reverse Engineer - Data Restoration Specialist ? Location: Fully Remote ? Position: Reverse Engineer - Data Restoration Specialist About Us: We are a dynamic and innovative cybersecurity firm dedicated to providing cutting-edge solutions for organizations affected by ransomware attacks. Our team of experts specializes in reverse...