Data Engineer

3 months ago

Overland, United States Clayco Full time

About Us

Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of building," providing fast track, efficient solutions for industrial, commercial, institutional, and residential related building projects.


The Role We Want You For

We are seeking a highly skilled and motivated Data Engineer to join our dynamic Data Analytics team in Overland, MO. As a Data Engineer at Clayco, you will play a vital role in designing, building, and maintaining data pipelines and complex data sets to support reporting, advanced analytics, and ad-hoc analysis. We are looking for a candidate with deep technical knowledge, a strong background in testing code, platform support, and data performance management. This position requires excellent communication skills to effectively collaborate with technical teams and translate business requirements into scalable data solutions.


The Specifics of the Role

  • Design, build, and maintain data pipelines from various source systems into Snowflake.
  • Analyze data elements, data flow, dependencies, and relationships from different systems and assist in designing conceptual, physical, and logical data models.
  • Develop complex data sets to fulfill diverse business needs in reporting, advanced analytics, and ad-hoc analysis.
  • Coordinate with third-party service providers for the construction and maintenance of data pipelines.
  • Execute and enable data migrations across systems, such as SQL Server to Snowflake or other cloud data platforms.
  • Develop and implement scripts for data hub maintenance, monitoring, and performance tuning.
  • Collaborate with data and business analysts to deploy and support a robust data quality platform.
  • Work with data and business analysts to deploy and support a comprehensive data cataloging strategy.
  • Assist various business and technical stakeholders with data-related technical needs and issues.
  • Collaborate closely with cross-functional teams to understand and transform business requirements into scalable and manageable data solutions.
  • Present solutions and options to leadership, project teams, and stakeholders, adapting the communication style to both technical and non-technical audiences.
  • Ensure adherence to documented design and development patterns and standards within the team.
  • Proactively monitor and resolve ongoing production issues.
  • Promote the approach of self-service data solutions and enable other teams with analytics solutions delivery through a 'Data as a Service' model.


Requirements

  • Hands-on experience in designing, developing, and implementing data solutions.
  • Advanced SQL knowledge with strong query writing and stored procedures skills.
  • Strong experience with relational databases such as SQL Server and Oracle.
  • Proficiency in object-oriented/object function scripting languages such as Python, Java, Scala, etc.
  • Basic knowledge and understanding of Azure cloud services.
  • Basic knowledge and understanding of stream-processing systems such as Storm, Spark-Streaming, etc.
  • Experience with data analysis, ETL, and workflow automation.


Some Things You Should Know

  • No other builder can offer the collaborative design-build approach that Clayco does.
  • We work on creative, complex, award-winning, high-profile jobs.
  • The pace is fast


Why Clayco?

  • Best Places to Work – St. Louis Business Journal, Los Angeles Business Journal, Phoenix Business Journal.
  • ENR – Top Midwest Contractors (#1), Top Design Build Contractors (#4), Top 400 Contractors (#23), ENR – Top Green Builders (#5).


Compensation and Benefits

  • Salary Range: Competitive Annual Salary based on qualifications, skills, training, experience, and location.
  • Discretionary Annual Bonus: Subject to company performance and individual contribution.
  • Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more

  • Entry-Level Civil Engineer

    2 weeks ago

    Overland Park, United States Olsson Full time

    Company Description We are Olsson, a team-based, purpose-driven engineering and design firm. Our solutions improve communities and our people make it possible. Our most meaningful asset is our people, and we are dedicated to providing an environment where they can continue to learn, grow, and thrive. Our entrepreneurial spirit is what has allowed us —...

  • Preconstruction Engineer

    1 month ago

    Overland, United States Clayco Full time

    About Us:Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Director, IT

    1 week ago

    Overland Park, United States EVERSANA Full time

    At EVERSANA, we are proud to be certified as a Great Place to Work across the globe. We’re fueled by our vision to create a healthier world. How? Our global team of more than 7,000 employees is committed to creating and delivering next-generation commercialization services to the life sciences industry. We are grounded in our cultural beliefs and serve...

  • Mechanical Engineer

    1 month ago

    overland park, United States TALENT Software Services Full time

    Are you an experienced Mechanical Engineer with a desire to excel? If so, then Talent Software Services may have the job for you! Our client is seeking an experienced Mechanical Engineer to work at their company in Overland Park, KS.Position Summary: In this role, you will have the opportunity to participate in and lead the engineering and design of the HVAC...

  • Senior Architectural Project Manager

    6 months ago

    Overland, United States Lamar Johnson Collaborative Full time

    About UsLamar Johnson Collaborative (LJC) is a team of high-energy professionals. We share a passion for design, a collaborative approach, and a casual culture. We solve challenges by leveraging the collective expertise and ingenuity of the best and brightest minds across development, design, and construction. Lamar Johnson Collaborative attracts a dynamic...

  • Entry-Level Engineer

    2 weeks ago

    Overland, United States SCS Engineers Full time

    Entry-Level EngineerLocation US-MO-OverlandCategory Early Career - Engineering and SciencePosition Type Full Time RegularWhat we are looking forSCS Engineers is looking for an engineer in the St. Louis office to perform various activities related to environmental consulting. You will have the opportunity to embrace teamwork, growth, and develop...

  • Mechanical Engineer

    2 weeks ago

    Overland Park, United States Talent Software Services Full time

    Mechanical Engineer 5 Job Summary: Talent Software Services is in search of a Mechanical Engineer for a contract position in Overland Park, KS. The opportunity will be six months with a strong chance for a long-term extension. Position Summary: In this role, you will have the opportunity to participate in and lead the engineering and design of the HVAC and...

  • Data Migration and Analytics Intern

    5 months ago

    Overland Park, United States Hill's Pet Nutrition Full time

    No Relocation Assistance Offered # 161611 - Overland Park, Kansas, United States Job Title: Data Migration and Analytics Intern Job Description: Position Overview: As a Data Migration and Analytics Intern, you will play a crucial role in our S/4HANA implementation project. You will work closely with our supply chain, data engineering, and...

  • Mechanical Engineer 5

    1 month ago

    Overland Park, United States System One Full time

    Buildings Mechanical Engineer, Data Centers (CFD), Hybrid Open to any office location. Job Responsibilities: In this role, you will have the opportunity to participate in and lead engineering and design of the HVAC and plumbing systems in various types of facilities. This position will focus on: - Design and construction activities, including...

  • Senior Preconstruction Engineer

    6 months ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Sr Data Scientist

    11 hours ago

    Overland Park, United States Disability Solutions Full time

    At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and...

  • Mechanical Engineer 5

    2 weeks ago

    Overland Park, United States Varite Full time

    Buildings Mechanical Engineer, Data Centers (CFD), Hybrid Pay Rate - $60-$65/hr on w2 Job Descriptions: In this role, you will have the opportunity to participate in and lead engineering and design of the HVAC and plumbing systems in various types of facilities. This position will focus on: Design and construction activities, including project delivery...

  • Buildings Mechanical Engineer

    2 weeks ago

    Overland Park, United States WIVERSE Full time

    Buildings Mechanical Engineer, Data Centers (CFD), Hybrid Open to any Client's office location. No Per diem- Must reside within 50 miles of a Client's office. Pay rate: W2 hourly Contract: 6+ MonthsRequired: HVAC Design CFD Data Centers Minimum 5 years' experience Job Responsibilities: In this role, you will have the opportunity to participate in and lead...

  • Mechanical Engineer 5

    2 weeks ago

    Overland Park, United States Tech Providers Full time

    Job Title : Mechanical Engineer 5 Location- Client Footprints location in all over USA (Hybrid) Duration: 6+ Months Contract Note : Candidate Must reside within 50 miles of a Client Footprints location office. Job Responsibilities: In this role, you will have the opportunity to participate in and lead engineering and design of the HVAC and plumbing...

  • Mid Test Engineer KS

    1 week ago

    overland park, United States TalentBurst Full time

    Position Summary We are currently looking for a Mid-level Test Engineer who is self-motivated, a critical thinker and with a strong technical background, to join the *** Radar Test Engineering Team in Overland Park, Kansas. This team is responsible for development and test of a next generation state of the art secondary radar system for the FAA, as well as...

  • Mid Test Engineer KS

    1 week ago

    overland park, United States TalentBurst Full time

    Position Summary We are currently looking for a Mid-level Test Engineer who is self-motivated, a critical thinker and with a strong technical background, to join the *** Radar Test Engineering Team in Overland Park, Kansas. This team is responsible for development and test of a next generation state of the art secondary radar system for the FAA, as well as...

  • Sales Planning Data Modeler

    1 month ago

    Overland Park, United States Disability Solutions Full time

    At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and...

  • Global Business Development Mgr

    1 month ago

    Overland Park, United States SPX Cooling Technologies, Inc. Full time

    Global Business Development Mgr - Data Centers & TechnologyLocation: Overland Park, Kansas (KS), US Building the people that build the world. With platforms in HVAC and Detection and Measurement, SPX Technologies builds innovative solutions that enable a safer, more efficient, sustainable world. Through our RiSE talent development framework, we Reach,...

  • Electrical Engineer II

    1 month ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Electrical Engineer

    2 months ago

    Overland Park, United States Jobot Full time

    Job DescriptionJob DescriptionGrowing Company/ $$$This Jobot Job is hosted by: Billy MewtonAre you a fit? Easy Apply now by clicking the "Apply Now" buttonand sending us your resume.Salary: $110,000 - $160,000 per yearA bit about us:The Electrical Engineer will be responsible for designing, developing, and testing electrical systems, control panels, and...