Sonepar USA is an independent family-owned company with global market leadership in B2B distribution of electrical products and related services. We are a member of the Sonepar Group, the world's largest privately-held electrical distributor. In the USA, we are represented by 15 locally managed electrical and industrial distributors with over 700 locations and coverage in all 50 states.
Sonepar is hiring a Data Architect to work closely with our infrastructure and application development teams. The Data Architect will recommend architecture and database structures based on the storage and retrieval needs within the company. The Data Architect will be responsible for building, optimizing, and maintaining conceptual and logical database models and the respective architecture.
Ultimately, the Data Architect will develop database solutions to ensure company information is stored effectively and securely. Ideally, the Data Architect would be familiar with storage techniques for effective use with predictive analysis and data visualization. Hands-on experience with Microsoft SQL Server is also required.
Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Owns and makes contributions in architecting, designing and planning BI / AI solutions, configuring services, aggregating data from multiple sources into a data repository
Guides technology teams in creating and deploying solutions that cater to various business needs.
Performs architectural reviews of BI / AI & analytics solutions
Applies architectural and engineering concepts to design solutions that meet operational requirements such as scalability, security, reliability, flexibility, availability and manageability
Able to clearly evaluate, articulate, and illustrate designs that further the understanding of data storage and retrieval architectures
Assist the development manager with implementing clear and concise coding standards as well as code reviews
Bachelor's degree in computer science, information science, or similar fields
3-5+ years' experience in a data analysis or management role
Strong knowledge of SQL Server Profiler
Understanding and application of execution / explain plans, stored procedures, and triggers
Experience with database analysis, database modeling, design, and implementation especially for data lakes / data marts / data warehouses
Data transformation support and management through MS SQL SSIS / DTS, Informatica, or similar technology
Experience in working across multiple production and development environments
Proven ability to work in distributed systems
Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
In-depth understanding of database structure principles
Knowledge of data mining and segmentation techniques
Solid verbal, written, and presentation communications skills
Team player who is passionate about data architecting and wants to evangelize the knowledge and its application across the teams
401K Plan, Health Insurance (medical, dental, and vision), Paid Vacation, Paid Sick, Paid Personal, Paid Holidays, Flexible Spending Accounts (Health, Transit, and Dependent Care), Employee Assistance Program, Employee Discounts and more.
Sonepar USA is an equal opportunity employer. M/F/Disability/Veteran
Business Unit: Sonepar
Job Location Philadelphia, Pennsylvania, United StatesPosition TypeFull-Time/Regular
Hagemeyer North America