Job Information
GCG Sr. Data Engineer - Chicago, IL in Chicago, Illinois
Overview
GCG is looking to add a Data Engineer to our corporate IT team. In this role, you will serve as a subject matter expert on Microsoft SQL Server and the Azure Data platform . You will analyze and propose solutions to complex data gathering or transformation problems. In addition, you will lead and provide technical guidance and mentorship to other team members as well as stakeholders throughout the business.
This position can be hybrid based in our Chicago, IL headquarters, or fully remote for exceptionally qualified candidates.
What you'll do
Participate in the solution development process, including planning and monitoring solution development efforts, coordinating activities with other team members, and reviewing deliverables and communicating status to management
Design, develop, document, and support ETL/ELT and quality-control for data warehousing efforts
Develop complex SQL queries and stored procedures
Educate and transfer knowledge to other team members to further refine best practice delivery for all stakeholders
Build SQL queries, procedures, and tables; convert them into leverageable data cubes within Power BI
Collaborate with third-party vendors and internal team members to maintain a scalable BI architecture in a high pace of change environment with a particular focus on acquisition-related data
Develop processes and procedures to migrate data from acquired companies' systems to the primary BI environment
Review use cases, edge cases, and other requirements documentation for clarity, completeness, and ensure proper detail is included to enable accurate estimates and quality development
Build and maintain data validation procedures to ensure BI information is accurate and timely
Setup, track, and provide monthly reporting and analysis on BI KPIs for usage and adoption
Work within a prioritized portfolio of Project & Enhancement requests and provide accurate estimates on time to completion
What you'll bring
Bachelor’s degree in Computer Science, and/or related program or equivalent work experience
Experience working with, building, and maintaining an Enterprise Data Warehouse and related ETL processes
5+ years of hands-on experience in Microsoft SQL Server, including SSIS Tabular, SSIS, and SSRS
Experience designing and implementing data architectures in Azure including Azure Data Factory, Azure/Managed Instance SQL Server, Azure Logic App, and Azure Analysis Services
Strong background in Microsoft SQL, stored procedures, and RDBMS concepts
Experience balancing support, analysis and project work responsibilities
Knowledge and understanding of functional business areas and their ERP generated datasets: e.g., General Ledger (GL), Accounts Payable, Accounts Receivable, Sales Orders, Purchasing and Inventory
Experience working with MS Power BI or other similar analytic & presentation layer platform creating data structures and/or cubes
Previous experience working with manufacturing and wholesale business models and datasets, as well as Merger & Acquisition activity with a focus on the resulting data integration work
Experience with automated scripting of data validation checks as information moves through layers of an EDW
Proven ability to prioritize work and expectations in a dynamic environment with multiple stakeholders and competing priorities
Advanced analytical skills to troubleshoot and resolve system problems
Excellent verbal and written communication skills
What we offer
Competitive annual salary and bonus based on company and individual performance
Robust and affordable benefits options, including medical, dental, vision, life insurance, short and long-term disability insurance, and more
PTO plan with company paid holidays (7)
401K with employer contribution
An employee-centric company that values and truly appreciates our most important asset: You
About GCG
At GCG, We Make Connections Possible through a nationwide network of facilities providing the wire, cable, automation, and associated products that ensure connections among families and friends, co-workers and customers, and the industrial equipment used across the country. Serving a wide variety of industries, our experienced teams are Service-oriented, Responsive, and Values-Focused .
GCG is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
These duties and responsibilities listed above are judged to be "essential functions" in terms of the Americans With Disabilities Act, or ADA. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Furthermore, the above statements are intended to describe the general nature and level of work being performed by a person in this position. They are not to be construed as an exhaustive list of all duties that may be performed by such a person.
#LI-Hybrid
#LI-AS1
Job Locations US-IL-Chicago
ID 2024-1401
Category Information Technology
Position Type Regular Full-Time
GCG
- GCG Jobs