Data Architect (3984-034)

Hagemeyer North America Philadelphia , PA 19107

Posted 3 months ago

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

Job Location Philadelphia, Pennsylvania, United StatesPosition TypeFull-Time/Regular

Apply


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
IT Senior Data Architect

Fulton Financial Corporation

Posted 1 week ago

VIEW JOBS 11/7/2018 12:00:00 AM 2019-02-05T00:00 Overview At Fulton Financial Corporation, the Data organization works with various data technologies to better manage our data and provide a platform to democratize data and analytics across the enterprise. This position is responsible for researching, analyzing, designing, and delivery of data architecture solutions to match business and IT strategy. He/she will drive architecture engagement models and be an ambassador for partnership and delivery with the business and with strategic vendors. He/she will develop architectural patterns to meet requirements and develop standardized architectural artifacts to capture the design. He/she will effectively communicate complex technical concepts to team members and work with large and varied technical and project teams. Office space available in East Petersburg, PA and Philadelphia, PA As a condition of employment, individuals must be authorized to work in the United States without sponsorship for a work visa by Fulton Financial Corporation currently or in the future. Responsibilities * Senior Data Architects work on a broad range of projects as well as provide technical oversight for other members of a project team. * Work with business product owners to understand business requirements and use cases * Create technical and business solutions architectures (logical and physical) * Resolve questions during design and implementation of architecture * Evaluate tools for use case fit, perform vendor/tool comparisons and present recommendations * Contribute to the capability roadmaps for data platforms * Review schemas, data models and data architecture for big data and traditional environments * Prototype solutions for specific use cases * Advise peers and business partners on fit-for-use and technical complexities * Partner with other technical leaders for solution alignment with strategy and standards * Define corporate data architecture and related standards for data integration architecture, data warehouse and business intelligence architecture, taxonomies and namespaces, data modeling tools and standards, metadata standards and requirements. * Perform architecture design, data modeling, and implementation of platform architecture and analytic applications. * Work with Data Governance team to design and manage reference data and master data programs. * Define and maintain architectural patterns in support of data governance. * Establishing metadata management policies and procedures. * Provide regular advice, direction and support to data analysts with hands on demonstrations of proper techniques and disciplines across all functions. * Deliver these functions using industry best practices with a thorough understanding of the full systems development lifecycle. * Act as a role model for documentation, communication, scripting and adherence to established Information Technology governance standards and procedures. QualificationsEducation: * Bachelor Degree or equivalent experience. Specialty: Relevant degree pertaining to the essential duties of this role. (Required) * Bachelor's Degree (Preferred). Experience: * 5 or more years of experience with end-to-end solution architecture for data including data modeling, architecture, processes and controls, and reporting support. * 3 or more years of experience with solutions in cloud environments such as AWS/Azure or with Hadoop. * 5 or more years of experience with Data modeling software, such as ERWin or ER Studio. * Experience with BI Software, such as PowerBI, including semantic layer management * 5 or more years of experience with SQL Server and Oracle including SQL queries and stored procedures. Familiar with data cleansing software. * Experience with ELT/ETL development, patterns and tooling * Experience in real time and batch data ingestion * Experience implementing Data security & masking with encryption, obfuscation, user entitlements by enabling role based access to the data based on PCI, NPPI for compliance with tools like Kerberos & Ranger * Experience with Graph and No-SQL databases * Metadata management, data lineage, data governance, especially as related to Big Data. Structured, Unstructured, Semi-Structured Data techniques and processes * Experience with advanced analytic tools such as Python, R and SAS. * Subject area expertise in Retail Banking, Retail Lending, Commercial Banking or Commercial Lending preferred. * Solid communication skills and proficiency with Excel, Word and PowerPoint. (Required) Certifications: * DAMA Certified Data Management Professional or TWDI Certified Business Intelligence Professional. (Preferred) * DAMA Data Management Body of Knowledge. (Preferred) * TOGAF (Preferred) EEO Statement Fulton Financial Corporation ("Fulton") is an equal opportunity employer and is committed to providing equal employment opportunity for all qualified persons. Fulton will recruit, hire, train and promote persons in all job titles, and ensure that all other personnel actions are administered, without regard to race, color, religion, creed, sexual orientation, national origin, citizenship, gender, gender identity, age, genetic information, marital status, disability, covered veteran status, or any other legally protected status. Fulton Financial Corporation Philadelphia PA

Data Architect (3984-034)

Hagemeyer North America