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 GCGAt 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 county. 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