What are the responsibilities and job description for the Senior Database Developer position at LGG Industrial?
LGG INDUSTRIAL
LGG INDUSTRIAL is a solutions-driven 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 employee-centric 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 life-work 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 safety-first culture. For more information, please visit www.lggindustrial.com
ABOUT THIS OPPORTUNITY
Role Profile
Position : Senior Data Developer
Job Location : Pittsburgh, PA
Operating Business : LGG Industrial
Job Type : Full-Time
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 company's 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 company’s 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 organization's 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 third-party vendor.
Improve and enforce data governance, DevOps, change control, and testing processes.
Collaborate with business stakeholders to understand requirements and deliver end-to-end data solutions.
Ensure high standards of data quality and address data-related 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 data-intensive business applications (ERP, CRM, etc.) and ensuring their integration and functionality.
Strong troubleshooting and problem-solving 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 user-friendly language.
Highly self-motivated and detail-oriented, with a strong desire to contribute to team success.
Exceptional analytical, conceptual, and problem-solving abilities.
Customer service-oriented 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 hands-on experience with Microsoft SQL Server and T-SQL.
Bachelor’s 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 long-term disability
401-k 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.
