Data Engineer

4 weeks ago


Lakewood, United States Three Pillars Recruiting Full time
Job Summary:

We are seeking a highly skilled Data Engineer with extensive experience in SQL Server, Python, and ETL processes to join our team at Three Pillars Recruiting. The ideal candidate will have a deep understanding of data management, data transformation, and optimization techniques to support large-scale databases and data pipelines.

Key Responsibilities:

ETL Development and Maintenance:

Design, implement, and maintain ETL processes to move and transform data from source systems to data warehouses or data lakes, ensuring data integrity and performance.


Data Warehousing:
Develop and optimize data warehouse architectures, including the creation of star/snowflake schemas, dimensional models, and maintaining historical data.

Database Performance Tuning:
Monitor and tune database performance, optimizing SQL queries, indexes, and configurations to ensure maximum performance and minimal downtime.

Data Integration:

Work with various data sources, including relational databases (SQL Server, PostgreSQL), NoSQL databases, APIs, and flat files, to ensure seamless data integration into the data warehouse or data pipeline.


Database Administration:
Manage and maintain SQL Server databases, performing tasks such as backup, restore, and disaster recovery planning.

Automation:

Develop scripts and workflows using Python (or other scripting languages) to automate routine tasks, data pipelines, and monitoring systems.


Data Quality and Validation:
Implement data quality checks, validation rules, and error handling to ensure data accuracy across systems.

Collaboration:

Work closely with business stakeholders, data analysts, and other engineers to understand data requirements, troubleshoot issues, and provide technical guidance.


Required Skills & Qualifications:
Experience: 3+ years of experience in Data Engineering or a similar role.

Technical Expertise:
o Strong proficiency with SQL Server, including SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).

o Advanced SQL query optimization and performance tuning experience.

o Experience with Python for data processing, automation, and scripting tasks.

o Strong understanding of ETL processes, data modeling, and data warehousing techniques.


o Experience with cloud platforms (Azure, AWS, or Google Cloud) and cloud-based data warehousing (e.g., Snowflake, Redshift, BigQuery) is a plus.


Tools & Technologies:
o Experience with version control systems (Git, GitHub, etc.).

o Familiarity with job scheduling tools (Airflow, Apache NiFi, etc.).

o Familiarity with BI tools like Power BI or Tableau is a plus.

Problem-Solving:
Strong analytical and problem-solving skills, particularly with data issues and performance bottlenecks.

Communication:

Excellent verbal and written communication skills, with the ability to explain complex data processes to both technical and non-technical stakeholders.


  • Data Engineer

    3 weeks ago


    Lakewood, New Jersey, United States Three Pillars Recruiting Full time

    At Three Pillars Recruiting, we are seeking a highly skilled Data Engineer to join our team. The ideal candidate will have extensive experience in SQL Server, Python, ETL processes, data warehousing, and database performance tuning. Key Responsibilities:Design, implement, and maintain ETL processes to move and transform data from source systems to data...

  • GCP Data Engineer

    4 weeks ago


    Lakewood, United States Onix Networking Full time

    About OnixOnix is a leading cloud consulting company that helps businesses unlock the full potential of their technology with cloud-powered solutions, best-in-class services, and innovative data migration products.With over 20 years of cloud experience, Onix delivers exceptional results for its customers by leveraging its depth of technology expertise,...

  • Enterprise Manager

    2 weeks ago


    Lakewood, United States Parker Hannifin Corporation Full time

    Enterprise Manager - Data Architecture & Engineering Location: CLEVELAND, OH, United States Job Family : Information Technology Job Type : Regular Posted : Jul 22, 2024 Job ID: 50774 Back to Search Results Job Description Apply Now > Save Job Job Saved Position Summary: Global responsibility for establishing and maintaining 'Enterprise Data' spanning...

  • GCP Data Engineer

    3 weeks ago


    Lakewood, Washington, United States Onix Networking Full time

    About Onix:Onix is a trusted cloud consulting company that helps businesses unlock the full potential of their technology with cloud-powered solutions, best-in-class services, and innovative data migration products.We leverage our 20+ years of cloud experience, depth of technology expertise, and IP-driven data and AI solutions to deliver exceptional results...

  • Senior Data Architect

    4 weeks ago


    Lakewood, United States Onix Networking Full time

    About Onix Networking: Onix Networking is a trusted cloud consulting company that helps businesses unlock the full potential of their technology with cloud-powered solutions, best-in-class services, and innovative data migration products.We have over 20 years of experience in cloud consulting, with a depth of technology expertise and IP-driven data and AI...

  • Data Scientist

    2 months ago


    Lakewood, United States VORTO Full time

    Job Description About VORTOWe are building software which enables businesses to be more economically and environmentally sustainable by digitally transforming the supply chain. As an AI Engineer at VORTO you will define the frontier of logistics optimization, supply prediction, and demand prediction. About the RoleAre you ready to join a dynamic software...


  • Lakewood, New Jersey, United States Remington & Vernick Engineers Full time

    Job SummaryWe are seeking a highly skilled Engineering Technician to join our team at Remington & Vernick Engineers. As an Engineering Technician, you will play a critical role in the review of various development projects, ensuring that they meet the highest standards of quality and safety.Key ResponsibilitiesPrepare cost estimates for commercial and...


  • Lakewood, New Jersey, United States Remington & Vernick Engineers Full time

    Job SummaryRemington & Vernick Engineers is seeking a highly skilled Project Manager/Engineer to join our team in Lakewood, NJ. As a key member of our engineering team, you will be responsible for managing multiple infrastructure projects affecting local infrastructure and land use in a variety of work environments.Key Responsibilities:Prepare cost estimates...

  • Project Engineer

    4 weeks ago


    Lakewood, United States Nooter Construction Company Full time

    Job Title: Project EngineerAs a Project Engineer at Nooter Construction Company, you will play a critical role in the success of our projects. We are seeking a highly skilled and experienced professional to join our team.Key Responsibilities:Perform calculations, draft CAD drawings, and transfer engineering data to aid field staff and craft in making...

  • Field Engineer

    4 weeks ago


    Lakewood, California, United States Nooter Construction Full time

    Job SummaryAs a Field Engineer at Nooter Construction, you will play a critical role in ensuring the successful execution of construction projects. Your primary responsibility will be to perform calculations, draft CAD drawings, and transfer engineering data to aid field staff and craft in making required equipment modifications, installing new equipment,...


  • Lakewood, United States Seneca Holdings Full time

    Great Hill Solutions is part of the Seneca Nation Group (SNG) portfolio of companies. SNG is the federal government contracting business wholly owned by the Seneca Nation. SNG meets mission-critical needs of federal civilian, defense, and intelligence community customers across a variety of domains. The SNG portfolio receives shared services support from its...

  • Bridge Engineer

    4 weeks ago


    Lakewood, United States Jobs for Humanity Full time

    Job SummaryWe are seeking a highly motivated Bridge Engineer to join our team at Michael Baker International. As a key member of our transportation infrastructure team, you will be responsible for planning, designing, and analyzing data on civil engineering projects such as bridges, retaining walls, tunnels, dams, and drainage structures.Primary...

  • Electrical Engineer

    3 weeks ago


    Lakewood, United States Komo Machine, Inc. Full time

    Job DescriptionJob DescriptionWe are seeking an Electrical Engineer to become an integral part of our team! You will assist in the research, design and development of electrical components and systems. Responsibilities:Develop and install electrical components and systems Assess and modify existing power distribution systemsTroubleshoot relay and...

  • Project Engineer

    2 months ago


    Lakewood, United States Kirby Company Full time

    Position Summary The Project Engineer is responsible for leading projects within operations that drive improvement in the manufacturing process and are significant in scale. This includes implementing improved manufacturing technologies and resourced materials, upgrading existing processes, leading Lean improvement events, and specific safety, quality, or...


  • Lakewood, New Jersey, United States Perma Pure Full time

    Job Title: Manufacturing EngineerPerma Pure, a leading manufacturer of high-performance moisture management products, seeks an experienced Manufacturing Engineer to join our team. As a key member of our production team, you will be responsible for ensuring the effective application of validation protocols, equipment and process validations, and process...


  • Lakewood, Ohio, United States CSA America Testing & Certification LLC Full time

    Product Safety EngineerCSA America Testing & Certification LLC is seeking a highly motivated and detail-oriented Product Safety Engineer to join our team in Cleveland. As a Product Safety Engineer, you will play a critical role in ensuring the safety and compliance of products with global and regional standards.Key Responsibilities:Evaluate products against...


  • Lakewood, United States GQR Full time

    Title: Validation Engineer II (Pharma)Job Status: Full-time direct hireLocation: Lakewood, New JerseyOnsite expectation: 5 days a weekCompensation: $89,000 to $92,000 DOENote: This role is not set up for Visa sponsorship, visa transfer after OPT, or third-party C2C.Candidate is responsible for duties associated with qualifying manufacturing and packaging...

  • Senior Civil Engineer

    4 weeks ago


    Lakewood, United States SmithGroup Full time

    SmithGroup is a leading design firm that combines research, data, and technology with innovation and creativity to deliver resilient and inclusive spaces that address our clients' most pressing challenges.Our teams create exceptional design solutions for healthcare, science and technology, workplace, mixed-use, higher education, cultural, waterfront, parks...

  • Quality Engineer II

    6 days ago


    Lakewood, United States ICONMA, LLC Full time

    Our Client, a Global Power Technology Leader company, is looking for a Quality Engineer II for their Lakewood, NY location. Responsibilities: Research and test the design, functionality and maintenance of products, equipment, systems and processes and develop quality standards. Ability tread and interpret blueprints, and evaluate product integrity and...


  • Lakewood, United States Remington & Vernick Engineers Full time

    Job SummaryWe are seeking a highly skilled and experienced Project Manager/Engineer to join our team at Remington & Vernick Engineers. As a key member of our infrastructure development team, you will be responsible for managing multiple engineering projects affecting local infrastructure and land use in various work environments.Key ResponsibilitiesPrepare...