Data Engineering

3 weeks ago

Rosemont, United States 360-TSG (Tech Staffing Group) Full time

Contract to Hire

|

360-tsg

|

United States Posted On 04/01/2019

Job Information

Industry Health Care Work Experience 5+ years Location Rosemont Job Opening ID ZR_131_JOB City Rosemont State/Province IL Zip/Postal Code 60018 Job Description

We are once again working with an exciting organization, they are looking for a Data Engineer to join their team.Your responsibilities will involve maintaining and enhancing the Registry’s 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 includes addressing issues pertaining to the ongoing operations and optimization of the data environment including performance, reliability, logging, scalability, etc. This position will also provide support for the companies database systems, warehouse, marts, and supporting applications.

Your will also lead the efforts to develop a unified enterprise data model for the organization. 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 Registry’s business intelligence roadmap. 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. You will work collaboratively with Registry participants and internal support teams, identify and implement changes that improve system performance and the user experience.

You will design, develop, and maintain the ETL pipelines using SSIS that standardize 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 data flow, 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 modeling.

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 organization’s 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

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

Data warehousing experience including the design, development, and ongoing support of star or snowflake data schemas to support business intelligence applications

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

#J-18808-Ljbffr

  • IT Manager, Data Architecture

    4 weeks ago

    Rosemont, United States Martin-Brower Full time

    Employer: The Martin-Brower Company LLC Job Title: Manager, Data Architecture & Engineering Worksite: 6250 N River Road, Rosemont, IL 60018. Description: Manage a team of direct reports, responsible for the overall design and delivery of Global Certified Data solutions. Manage the company's Global Data Warehouse and all associated data pipelines and/or...

  • AI Engineer

    2 weeks ago

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

    1 day ago

    Rosemont, United States The LaSalle Group 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...

  • Boomi Engineer

    1 day ago

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

  • Boomi Engineer

    2 days ago

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

  • Development Engineer

    4 weeks ago

    Rosemont, Illinois, United States Signify Netherlands B.V. Full time

    We're looking for a talented Development Engineer to join our LED Electronics R&D team in Rosemont, IL.Working for Signify means being creative and adaptive. Our culture of continuous learning and commitment to diversity and inclusion creates an environment that allows you to build your skills and career. Together, we're transforming our industry.As the...

  • Boomi Engineer

    7 days ago

    Rosemont, United States Culligan International Full time

    Job Description Job Description Culligan International, a global leader in water filtration technology, is seeking a skilled Boomi Engineer to join our team. This remote, full-time role focuses on enhancing and maintaining our data integration infrastructure. Responsibilities include documenting integrations, maintaining processes, enforcing standards, and...

  • Boomi Engineer

    3 weeks ago

    Rosemont, United States Culligan International Company Full time

    Job DescriptionJob DescriptionCulligan International, a global leader in water filtration technology, is seeking a skilled Boomi Engineer to join our team. This remote, full-time role focuses on enhancing and maintaining our data integration infrastructure. Responsibilities include documenting integrations, maintaining processes, enforcing standards, and...

  • Boomi Engineer

    2 weeks ago

    Rosemont, 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 of Engineering

    7 days ago

    Rosemont, United States Vantedge Medical Full time

    Vice President of EngineeringFull-time / PermanentAbout 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 such as Robotic Assisted...

  • Vice President of Engineering

    1 week ago

    Rosemont, United States Vantedge Medical Full time

    Vice President of EngineeringFull-time / PermanentAbout 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 such as Robotic Assisted...

  • Vice President of Engineering

    1 week ago

    Rosemont, United States Vantedge Medical Full time

    Vice President of EngineeringFull-time / PermanentAbout 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 such as Robotic Assisted...

  • Vice President of Engineering

    4 days ago

    Rosemont, United States Vantedge Medical Full time

    Job DescriptionJob DescriptionJob Title: Vice President of EngineeringLocation: Rosemont, IL (Hybrid) 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...

  • IT Desktop Engineer Level 3

    2 weeks ago

    Rosemont, United States Culligan International Company Full time

    Job DescriptionJob DescriptionThe 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,...

  • Azure Cloud Engineer

    5 days ago

    Rosemont, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Cloud Engineer role I posted here on LinkedIN, I appreciate it. If you have read my JD's before, you will remember that I like to add some humor to these things (life is too short to not laugh once in a while). If you are new to my JD's, if you see something in here that makes you chuckle...that was the intent....

  • Azure Cloud Engineer

    1 month ago

    Rosemont, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Cloud Engineer role I posted here on LinkedIN, I appreciate it. If you have read my JD's before, you will remember that I like to add some humor to these things (life is too short to not laugh once in a while). If you are new to my JD's, if you see something in here that makes you chuckle...that was the intent....

  • Azure Cloud Engineer

    6 days ago

    Rosemont, United States RSM Solutions Full time

    Thank you for stopping by to take a look at the Cloud Engineer role I posted here on LinkedIN, I appreciate it. If you have read my JD's before, you will remember that I like to add some humor to these things (life is too short to not laugh once in a while). If you are new to my JD's, if you see something in here that makes you chuckle...that was the intent....

  • Azure Cloud Engineer

    4 weeks ago

    Rosemont, United States RSM Solutions, Inc Full time

    Thank you for stopping by to take a look at the Cloud Engineer role I posted here on LinkedIN, I appreciate it. If you have read my JD's before, you will remember that I like to add some humor to these things (life is too short to not laugh once in a while). If you are new to my JD's, if you see something in here that makes you chuckle...that was the intent....

  • IT Systems Engineer

    21 hours ago

    Rosemont, United States Culligan International Full time

    Job Description Job Description As IT Systems Engineer, you will enable Culligan’s businesses across North America through the exceptional deployment and operation of modern technology. This role is responsible for business enablement, systems strategy, capacity management, performance management, preventive maintenance, diagnosing complex issues, and...

  • IT Systems Engineer

    5 days ago

    Rosemont, United States Culligan International Company Full time

    Job DescriptionJob DescriptionAs IT Systems Engineer, you will enable Culligan’s businesses across North America through the exceptional deployment and operation of modern technology. This role is responsible for business enablement, systems strategy, capacity management, performance management, preventive maintenance, diagnosing complex issues, and...