MSC Industrial Supply Co. ETL Developer (Business Intelligence) in Davidson, North Carolina
Build a better career with MSC.
Serving customer and community starts with the very best people doing their very best work. That is precisely what we have at MSC Industrial Supply Co., a leading North American distributor of metalworking and maintenance, repair, and operations (MRO) products and services. Watch HERE to find out why you should work at MSC and join us as we continue to build a diverse and inclusive workplace.
Requisition ID : 3576
Employment Type : Full Time
Job Category : Information Technology
Work Location : Davidson, NC (CSC)
State or Province : North Carolina (US-NC)
Potential Work Location : United States : New York : Melville || United States : North Carolina : Davidson
BRIEF POSITION SUMMARY:
The position of Data Architect is responsible for developing information management strategies, assessing the flow of data, including how it is processed and stored. Designs effective and efficient processes for managing the data flow.
DUTIES and RESPONSIBILITIES:
Assumes direct responsibility for the design, development and validation of MSC’s Enterprise Data Model ensuring accurate, consistent and comprehensive information is securely available to MSC associates across multiple business areas.
Interacts directly with IT business stakeholders to define structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects.
Establishes data/information architectural standards, a process for maintaining the standards and a process of monitoring compliance to those standards across the enterprise.
Operates across multiple projects simultaneously and assumes responsibility for the appropriate data/information architecture, design and quality.
Performs impact, system, and data analysis based on business requirements.
Supports the development of information architectures and technology validation strategies leveraging industry standard best practices
Builds and maintains enterprise data model, associated meta-model, ontologies and taxonomies, which will be used to guide software development.
Develops and maintains the metadata management repository and data lineage for source data, intermediate data and target repositories including common information models that will be directly used by business power users
Requires an understanding of regulatory considerations as it relates to database design and security, such as PCI compliance, consumer privacy, HIPAA and SOX, and designs data/information architecture that adheres to these regulations.
Develops, maintains and shares data/information architectural documentation on all data-related technology patterns.
Leverages and applies direct experience in business analysis, data acquisition, data analysis/design, Database Management System optimization, archiving and recovery strategy, data load optimization, security, and data entitlements.
Serves as a technology advocate throughout the IT organization to promote the effective use of the data/information architecture to meet business needs and to build sustained competitive advantage for the enterprise.
Forms, maintains and strengthens relationships with key external technology suppliers to prioritize, evaluate and accelerate the adoption of promising new technologies with high business value.
Provides support for existing systems and processes for standard and custom solutions.
Uses and promotes established Software Development Life Cycle (SDLC) standards, QA and change control procedures.
Partners with Project Manager/Project Leader on all assignments.
Maintains and follows all MSC standards.
Participates in IT technical design and development meetings to evaluate and recommend optimal solutions designed for high levels of data quality, integrity, performance, availability and reliability.
Provides weekly status updates based on projects and maintains weekly time sheets.
Fosters the MSC Culture in the department and throughout the company to ensure unity of vision and fulfillment of MSC’s mission.
Participates in special projects and performs additional duties as required.
EDUCATION and EXPERIENCE:
Bachelor’s Degree in Computer Science, Information Systems, or other related field. Master’s degree is preferred.
Minimum of 7 years of experience designing, developing and tuning complex, large (TB) database management systems in support of operational reporting, decision support, complex data analysis and system integration
Minimum of 7 years experience working with and tuning Microsoft SQL Server or other similar relational database management systems.
Minimum of 7 years experience leading, mentoring and directing the work of others in data modeling, database design (multi-dimensional and data warehouse), data integration and ETL.
Minimum of 7 years experience in logical and physical data architecture design using database modeling tools required.
Supply chain industry experience preferred.
Ability to integrate with custom and third party packaged applications required.
Good project management skills required.
Excellent verbal and written communication and presentation skills required.
Excellent organizational and time management skills required.
Ability to establish and build relationships with the business community required.
Proficient in Microsoft Project, Word, Excel, PowerPoint and Visio.
Proficient in developing SQL-based programs and scripts as well as stored procedures.
- Travels as required to other MSC facilities.
People. Collaboration. Insight. That’s how you build something that works.
Built on a foundation of trust, MSC works side by side with our customers to help them drive business results. With more than one million product offerings and 75+ years of experience across industries, MSC strives to help our customers achieve greater productivity, profitability, and growth through inventory management and other innovative supply chain solutions.
We care about our associates and have programs in place to help our 6,500+ team members achieve their potential. When you join our team, you will receive rewards and recognition for your contributions, training and professional development opportunities, as well as a variety of benefits to support you and your family's health, well-being, and financial future.
If you are inspired to learn, take risks, and succeed as a team, you can build a better career at MSC.
Equal Opportunity Statement
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation or gender identity.