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, 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,...

  • Senior Data Engineer

    16 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

    21 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 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...


  • 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...

  • Reverse Engineer

    3 weeks ago


    Boston, United States Motion Recruitment 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...


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

    WHAT YOU'LL DO BCG has a real estate portfolio of more than 4M square feet across 90+ cities, with significant real estate activity as we grow and diversify as a business and evolve our workplace of the future. Our workplaces help our people feel productive, healthy, and proud to work at BCG. We provide BCG employees, clients and guests with world...


  • 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...


  • Boston, United States Selby Jennings Full time

    Your Skillset: Possession of a Bachelor's degree or higher in Computer Science, Management Information Systems, Business Information Systems, Mathematics, or a related field.7 or more years of experience in data engineering, with a track record of holding senior and leadership roles within peer firms. Proficient in utilizing agile methodologies and modern...


  • Boston, Massachusetts, United States Selby Jennings Full time

    Your Skillset: Possession of a Bachelor's degree or higher in Computer Science, Management Information Systems, Business Information Systems, Mathematics, or a related field.7 or more years of experience in data engineering, with a track record of holding senior and leadership roles within peer firms. Proficient in utilizing agile methodologies and modern...

  • Data Engineer

    4 weeks ago


    Boston, Massachusetts, United States Northeastern University Full time

    The College of Social Sciences and Humanities is a leader in the Experiential Liberal Arts. The College is strongly committed to fostering excellence through diversity and enthusiastically welcomes applications from members of groups underrepresented in higher education administration.The College's schools, departments, and programs—with disciplines...

  • Data Engineer

    3 weeks ago


    Boston, United States Northeastern University Full time

    The College of Social Sciences and Humanities is a leader in the Experiential Liberal Arts. The College is strongly committed to fostering excellence through diversity and enthusiastically welcomes applications from members of groups underrepresented in higher education administration. The College’s schools, departments, and programs—with...


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

    WHAT YOU'LL DO BCG has a real estate portfolio of more than 4M square feet across 90+ cities, with significant real estate activity as we grow and diversify as a business and evolve our workplace of the future. Our workplaces help our people feel productive, healthy, and proud to work at BCG. We provide BCG employees, clients and guests with world...