This site uses cookies. To find out more, see our Cookies Policy

Data Architect in Philadelphia, PA at Sonepar USA

Date Posted: 10/19/2018

Job Snapshot

Job Description

Data Architect

 

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.

Summary:

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. 

Responsibilities:

  • 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

Qualifications:

  • 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

Benefits:

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

CHECK OUT OUR SIMILAR JOBS

  1. Architect Jobs
  2. Systems Engineer Jobs