LGG INDUSTRIAL
LGG INDUSTRIAL is a solutionsdriven national distributor of hoses gaskets and conveyor products. Our skilled colleagues serve customers in various industrial segments to improve their operations and reduce their total cost of ownership. With locations across the United States and Canada we aim to deliver consistent service and support across North America.
We desire to create an employeecentric place to work a place where you can develop your skills and grow as a professional. We provide training and advancement opportunities to build a career and lifework integration to keep you at your best.
Our philosophy is that the success of our business is directly dependent upon the health and safety of our associates. We focus on maintaining a safe work environment and strive to achieve zero injuries through our safetyfirst culture. For more information please visit www.lggindustrial
ABOUT THIS OPPORTUNITY
Role Profile
Position: Senior Data Developer
Job Location: Pittsburgh PA
Operating Business: LGG Industrial
Job Type: FullTime
Status: Exempt
Job Title: Senior Database Developer / DBA
Summary of the Role
The Senior Database Developer / DBA will play a pivotal role in understanding the companys data ecosystem and related applications to support the enterprise data warehouse business intelligence ERP and integrated systems. This position will also take full responsibility for managing and administering the companys database servers and ensuring the smooth operation of the data supply chain.
Responsibilities
- Lead the development of Enterprise Data Systems and Enterprise Data Models supporting the ERP project and other critical systems.
- Design and develop advanced SQL queries data table structures stored procedures and functions to support both business processes and integrated systems.
- Review optimize and maintain database code for performance addressing any bottlenecks.
- Recommend and implement changes to relational data models to resolve issues with data warehouses master data and data mart environments.
- Develop and maintain database/data solutions for Enterprise Data Warehouse (EDW) Power BI and other integrated systems.
- Administer and maintain the organizations data supply chain supporting systems such as ERP CRM Workday Active Directory SharePoint EDI VMI and others.
- Take ownership of database server management and administration previously handled by a thirdparty vendor.
- Improve and enforce data governance DevOps change control and testing processes.
- Collaborate with business stakeholders to understand requirements and deliver endtoend data solutions.
- Ensure high standards of data quality and address datarelated issues across the enterprise.
Skills and Abilities
- 8 years working as a database developer database administrator or in a related role.
- Advanced proficiency in SQL Server and database programming.
- Extensive experience with Data Warehousing Master Data Management and Business Intelligence disciplines.
- Expertise in managing dataintensive business applications (ERP CRM etc. and ensuring their integration and functionality.
- Strong troubleshooting and problemsolving skills including the ability to identify and resolve performance bottlenecks in SQL code and database systems.
- Proficiency with SSIS and strong plus
Personal Attributes
- Strong interpersonal and communication skills with the ability to document and present complex ideas in userfriendly language.
- Highly selfmotivated and detailoriented with a strong desire to contribute to team success.
- Exceptional analytical conceptual and problemsolving abilities.
- Customer serviceoriented with a focus on delivering effective and scalable solutions.
- Proven ability to prioritize and execute tasks in a dynamic business environment.
Qualifications
- 5 years of experience working as a database developer database administrator or BI developer.
- 5 years of handson experience with Microsoft SQL Server and TSQL.
- Bachelors degree in Information Technology or a related field or equivalent work experience.
Total Rewards
- Competitive compensation plan
- Health Benefits: medical dental vision short term and longterm disability
- 401k with company match
- Paid time off
Equal Opportunity Employer
It is our policy to employ qualified persons without regard for race creed color national origin nationality ancestry age sex marital or domestic partnership status sexual orientation or disability. Individuals are considered for employment promotion or training solely on their ability to perform the essential functions of the position.
Required Experience:
Senior IC