Data Engineer

4 weeks ago

Des Plaines, United States CareerBuilder Full time

As a Data Engineer your primarily responsible for maintaining and enhancing the Registrys data acquisition, integration, and ETL pipelines in support of both operational and business intelligence data stores. The incumbent is responsible for applying diverse data cleansing and transformation techniques as well as the ongoing management and monitoring of all Registry databases. This will include addressing issues pertaining to the ongoing operations and optimization of the data environment including performance, reliability, logging, scalability, etc. You will also provide support for the organizations database systems, warehouse, marts, and supporting applications.
You will also lead the efforts to develop a unified enterprise data model for the organization. As a Data Engineer you will also design, develop, and maintain high-performance data platforms on premise and in Microsoft Azure cloud-based environments including leading the development of a data warehouse environment to support the Registrys business intelligence roadmap. You will champion efforts that will ensure that the organizations business intelligence applications remain relevant for use by internal business groups by actively participating in strategy and project planning discussions. Work collaboratively with Registry participants and internal support teams, identify and implement changes that improve system performance and the user experience.
Design, develop, and maintain the ETL pipelines using SSIS that standardized raw data from multiple data sources and optimize both the operational and dimensional/star schema data model necessary for transactional systems and business intelligence applications. Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions aligning to an overall data architecture. Extract, transform, and load data to and from various data sources including relational databases, NoSQL databases, web services, and flat files. Produce various technical documents such as ER diagrams, table schemas, data lineage, API documents, etc.
Provide leadership and oversight on database architectural design for existing systems including database administration, performance monitoring, and troubleshooting. Provide complex analysis, conceptualize, design, implement, and develop solutions for critical data-centric projects. Perform dataflow, system and data analysis, and develop meaningful and useful presentation of data in downstream applications. Plan and implement standards, define/code conformed global and reusable objects, perform complex database design and data repository modelling.
Monitor ETL processes, system audits, dashboard reporting, and presentation layer functioning and performance. Proactively identify and implement procedures that resolve performance and/or data reporting issues. Support the optimal performance of the organizations data and BI systems. Monitor database performance, provide optimization recommendations, and implement recommendations. Follow the release cycles and implement on-time delivery of task assignments, defect correction, change requests, and enhancements. Troubleshoot and solve technical problems. Perform other responsibilities as assignment by management.

Requirements

3 years of relevant work experience in a data engineering role leveraging SQL, SSIS; including design and support of ETL routines that support the import of data from multiple data sources
2 years of experience with PowerBI
3 years of data warehousing experience including the design, development, and ongoing support of star or snowflake data schemas to support business intelligence applications
5 years of database administration or database development experience in a SQL or MySQL environment; knowledge of Microsoft technology stack; background in Azure Infrastructure as a Service environment desired
Experience working with both structured and unstructured data
Demonstrated understanding of Business Intelligence and data solutions including cubes, data warehouses, data marts, and supporting schema types (star, snowflake, etc.)
Data modeling experience in building logical and physical data models
Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS)
Strong technical planning skills with the ability to prioritize and multitask across a number of work streams
Polished presentation skills; experience creating and presenting findings to executive level staff
Strong written, verbal and interpersonal communication skills, with an ability to communicate ideas and solutions effectively
Must be highly collaborative with the ability to manage and motivate project teams and meet deliverables
Ability to build strong stakeholder relationships and translate complex technical concepts to non-technical stakeholders
Experience with Data Warehouse is a plus

#J-18808-Ljbffr

  • Data Engineer

    1 day ago

    Des Plaines, Illinois, United States GTI Energy Full time

    General SummaryGTI Energy, the nation's leading research, development, deployment, and training organization serving energy markets, has an opportunity for a Data Engineer/Analyst in our Research & Engineering group. The Data Engineer will collaborate with a team of engineers and scientists to deliver technological solutions for energy projects. This role...

  • AI Engineer

    4 weeks ago

    Des Plaines, United States CareerBuilder Full time

    LaSalle Network is partnering with a global distribution company to identify an AI Engineer to join their team. The AI Engineer role within IT Service Delivery is responsible for the global delivery and evolution of the enterprise AI solution. Additionally, this role will provide direction and design for automation services and implementing generative AI...

  • AI Engineer

    2 weeks ago

    Des Plaines, United States The LaSalle Group Full time

    LaSalle Network is partnering with a global distribution company to identify an AI Engineer to join their team. The AI Engineer role within IT Service Delivery is responsible for the global delivery and evolution of the enterprise AI solution. Additionally, this role will provide direction and design for automation services and implementing generative AI...

  • Boomi Engineer

    23 hours ago

    Des Plaines, United States LaSalle Network Full time

    LaSalle Network has partnered with a water systems treatment company in their search for a Boomi Engineer. As a Boomi Engineer, you will play a pivotal role in designing, developing and implementing integration solutions using the Boomi platform. Working closely with cross-functional teams, you will be responsible for understanding business requirements and...

  • Construction/Civil Engineer

    3 weeks ago

    Des Plaines, United States J Terry & Associates Full time

    Job DescriptionJob Description JOB DESCRIPTION: This sub family is responsible for designing and planning civil engineering projects such as roads, airports, bridges, harbors, dams, irrigation systems, pipelines, and power plants. Duties may include analyzing maps, blueprints, drawings, tests, and aerial photographs on soil composition, terrain, hydrological...

  • Design Engineer I

    24 hours ago

    Des Plaines, United States Geberit International AG Full time

    The function of a Design Engineer is to lead projects, perform product engineering, support implementation of production systems, support internal and external customer product inquiries, and perform engineering research. ESSENTIAL DUTIES & RESPONSIBILITIES Leads and manages projects by planning, communicating, and tracking task execution Clarifies project...

  • Sr Data Engineer

    4 days ago

    Des Moines, United States The Principal Financial Group Full time

    Were looking for a Sr Data Engineering Leader to join our Enterprise Data & Analytics department. In this role, youll lead the Workforce Data Team and help bring modern engineering capabilities to drive enterprise strategy! Provide data engineering Data Engineer, Engineer, Data, Technical

  • General Engineer

    1 day ago

    Des Plaines, United States Federal Aviation Administration Full time

    Summary Serves as a General Engineer in the Operations Engineering Support Group organization under the minimal direction of a manager or more experienced engineer. Plans and accomplishes highly complex and challenging projects/programs and other work activities. May act as a principal technical specialist or as a project/program manager or team...

  • Senior QA Engineer

    7 days ago

    Des Plaines, United States eTeam Full time

    Strong QA foundation and ability to perform Integration testing, back-end testing, database validation skills (Mongo DB), Web service/API testing experience(POSTMAN/SoapUI), End to End and Regression testing experience. Test Management , Defect management, Test Data management Advanced knowledge of test engineering practices within an Agile SDLC methodology....

  • Boomi Engineer

    7 days ago

    Des Plaines, United States Culligan Full time

    Specific Job Function: The Boomi Engineer will play a critical role in maintaining and enhancing the data integration landscape at Culligan. Key responsibilities include: Documenting new and legacy system integrations. Maintaining and monitoring deployed integration processes. Enforcing company standards across all delivered integrations. Providing...

  • Vice President, Engineering

    1 week ago

    Des Plaines, United States Vander-Bend Manufacturing, Inc Full time

    Job DescriptionJob DescriptionVice President of EngineeringFull-time / Permanent About Us:Vantedge Medical is the premier metals-based med-tech solutions partner from concept to full-scale manufacturing. We are at the forefront of precision engineering and innovation, specializing in the development and manufacturing of vital components for medical markets...

  • Engineer - Building Equipment Research

    21 hours ago

    Des Plaines, United States GTI Full time

    General Summary GTI Energy, the nation's leading research, development, and training organization serving energy markets, has an opportunity for a Senior Engineer within its Research and Engineering Group in Des Plaines, IL. The qualified candidate will perform R&D functions in collaboration with senior staff in the design and evaluation of advanced heating,...

  • Principal Engineer

    1 day ago

    Des Plaines, United States GTI Full time

    General Summary GTI Energy, the nation’s leading research, development, and training organization serving energy markets, has an opportunity for a Principal Engineer within the Research and Engineering Group. The qualified candidate will perform R&D functions in collaboration with senior staff, with a strong focus on commercial heating, ventilation, and...

  • IT Desktop Engineer Level 3

    6 days ago

    Des Plaines, United States Paragon Water Full time

    Responsibilities: The Desktop Engineer is a critical member of the North American IT Team providing support to internal employees.This individual will be responsible for maintaining the desktop and laptop infrastructure, along with associated applications.This is an internal customer-facing role, and requires excellent prioritization, responsiveness, and...

  • Senior Quality Engineer

    4 weeks ago

    Des Plaines, Illinois, United States ITW Full time

    Job Description Position Summary: The Quality Engineer will report to the Plant Manager and will be responsible for analyzing customer returns and developing written corrective action reports as well as providing quality engineering support for the facility, emphasizing defect prevention and continual improvement. Responsibilities and Authority: Support...

  • Sr. Software Engineer

    5 days ago

    Des Plaines, United States Martin-Brower Full time

    Overview: Martin Brower is a global supply chain leader that provides smart, sustainable solutions for customers across 18 countries. We are dedicated to creating an outstanding work environment for our team of 12,500+ employees, who combine our expertise with the latest technologies to deliver unmatched value for our customers. Responsibilities: Pay...

  • Pilot Operations Process Engineer

    7 days ago

    Des Plaines, United States Gas Technology Institute Full time

    ** Pilot Operations Process Engineer** **Job Category****:** Research & Development **Requisition Number****:** PILOT001366 Showing 1 location **Job Details** **Description** **General Summary** Gas Technology Institute (GTI), a leading research and development organization serving energy markets, is seeking an Engineer to support pilot and demonstration...

  • Systems Engineer

    2 weeks ago

    Des Moines, United States Sovereign Technologies Full time

    Systems Engineer – Data Security – 150291 Location: St. Louis, MO Categories: Database Security, Security This is a direct hire position in St. Louis, MO.You will operatethe information security systems related to database and other data security management systems.The person in this position: Administers, monitors, maintains, and troubleshoots the data...

  • Sr. Software Engineer

    3 weeks ago

    Des Plaines, United States CareerBuilder Full time

    Pay Transparency Statement: The compensation philosophy reflects the Company's reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs. This role may also be eligible to participate in a...

  • Scientist (Documentation/Change Control)

    3 days ago

    Des Plaines, United States Collabera Full time

    Job DescriptionJob DescriptionThis onsite role is to review aging technical projects and determine if activities have been completed.This role will require no lab work and will require implementing Documentation and Change Control activities related to technical projects.Requires attention to detail and willingness to contact different departments to track...