Schaedler Yesco
Data Architect
Schaedler Yesco, Harrisburg, Pennsylvania, us, 17124
Reference #: 3275968 Join the Schaedler Yesco Distribution Team! Why You'll Love Schaedler Yesco Distribution: At Schaedler Yesco Distribution, we've been illuminating the electrical industry since 1924! As a family- and employee-owned company, we take pride in providing innovative solutions and exceptional customer service. With 29 locations across Pennsylvania, Ohio, and New York, we provide comprehensive solutions in lighting, datacomm, automation, and industrial services. What Sets Us Apart are our Core Values:
Commitment to Integrity
Teamwork
Accountability
Profitability Where we work hard and go home happy! Electrifying Benefits:
Health Coverage: Choose from 2 PPO options for Medical, Dental, Vision, and RX-coverage kicks in just 60 days after the 1st of the month!
401K with company match.
Flexible Spending Account (FSA) & Health Savings Account (HSA).
Employee Stock Ownership Plan (ESOP): Become a stakeholder in our success!
Quarterly bonuses.
Company-paid disability and life insurance.
Generous paid holidays and paid time off.
Opportunities for continuing education and professional development. Position Overview: The Data Architect is responsible for ensuring that the data assets of SYD are supported by a data architecture designed to achieve the company's strategic objectives. This role manages data architecture, schema design, databases, data integration, and the technology platforms for data retrieval, reporting, dashboards, and analytics. The Data Architect works with business stakeholders and cross-functional teams to create enterprise data standards. In this role, you will be responsible for extracting, transforming, and loading (ETL) data into a data warehouse, ensuring data quality and integrity across various sources. Participates in a team that defines the overall data policy, data standards, and best practices for the enterprise. Ensures the accuracy and accessibility of all significant data. Works with business stakeholders in the creation and maintenance of enterprise data models. Responsible for the documentation of data dictionaries, data models, data drawings, data process flows, and other artifacts. Manages the development of complex data models and logical database design and develops policies, standards, and procedures for the database environment. Responsibilities:
Design, develop, and maintain ETL processes to pull data from multiple sources (e.g., databases, APIs, spreadsheets) into the data warehouse.
Ensure data is accurately transformed, cleaned, and structured according to business needs and reporting standards.
Design, create and maintain SQL database needs for the company.
Design, develop, and maintain APIs to support web and mobile applications.
Support the creation, management, and enhancement of the company's data warehouse
Develop and drive acceptance of an enterprise view of data and its use across the enterprise. Ensure a common vocabulary and understanding of business entities' relationships.
Provide thought leadership for the definition & maintenance of complex enterprise data models, data dictionaries, and master data management
Capture requirements for new data sources, reports, queries, or dashboards.
Develop, improve, and support enterprise data standards and data architecture policies and procedures.
Monitor and enforce compliance with data standards to minimize data redundancies and enhance information quality throughout the organization.
Document the company data dictionaries, architecture, & schema.
Lead the analysis, design, development & implementation of logical data models; physical databases, data conversions, data integrations, query & reporting functions, data management, data governance, and data quality assurance processes
Provide support and consulting for new projects, to ensure that new applications and data stores integrate with overall enterprise and data architectures.
Par icipate in data, data dictionary, and data process flow documentation to create current state and future state documentation, flowcharts, and plans.
Proactively monitor the various data platforms' performance and reliability to identify and resolve issues.
Coordinate any data, middleware, or BI tool license updates/upgrades, as needed, and approved by management.
Participate in the evaluation of BI technology tools that align with our company's objectives and meet the needs of our team members, customers, and/or suppliers.
Stay updated with industry trends and advancements in data or BI technology to identify opportunities for system enhancements and improvements. Participate in virtual user groups and recommend applicable conferences.
Design, develop, test, and implement automated extract, transformation, and load (ETL's) routines using tools such as SQL, Eclipse Basic, Kore, Query. Qualifications:
Experience in a similar data technology role in a company of similar size preferred
Data warehouse architecture, schemas, data mining, data design and implementation
Strong proficiency with SQL and query building between multiple software platforms
Experience in API design and support.
Proficient in BI tools such as Phocas, Power/BI, Tableau, QlikView or Cognos
Proficient in EDW platform, such as AWS, IBM Netezza, Snowflake, Teradata, or Eclipse PDW
Experience in middleware such as Kore, IBM MQ, Apache Hop, Mulesoft
Ability to resolve complex issues related to enterprise-wide data architecture concerns
Excellent analytical and problem-solving skills.
Strong understanding of data architecture methodologies, schemas & frameworks, and their practical application. Additional Information:
Travel Requirements: Minimal travel may be required. Should travel be required a valid driver's license with a clean driving record is required for this position.
Work Shift and Hours: Monday to Friday: 8 AM - 5 or 7 AM - 4 PM
Physical Requirements: * Ability to use a keyboard and type proficiently. * Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Work Environment: This job operates as a hybrid home / office setting with the balance of the time split between visiting various branches/warehouses and attending meetings. This position requires the use of standard office equipment such as computers, internet, smartphones, and photocopiers.
Other Duties: *Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee, for this job. Duties, responsibilities, and activities may change at any time without notice.
Schaedler Yesco Distribution, Inc. is an Equal Opportunity and Affirmative Action Employer. Schaedler Yesco maintains policies and practices that are designed to prevent discrimination against any qualified employee or applicant on the basis of race, color, religion, ancestry, national origin, sex, age, marital status, sexual orientation, gender identity, protected veteran status, disability, and medical condition to the extent protected by law. This policy of nondiscrimination applies to all employment practices, including hiring, compensation, benefits, promotion, training, and terminatio
Commitment to Integrity
Teamwork
Accountability
Profitability Where we work hard and go home happy! Electrifying Benefits:
Health Coverage: Choose from 2 PPO options for Medical, Dental, Vision, and RX-coverage kicks in just 60 days after the 1st of the month!
401K with company match.
Flexible Spending Account (FSA) & Health Savings Account (HSA).
Employee Stock Ownership Plan (ESOP): Become a stakeholder in our success!
Quarterly bonuses.
Company-paid disability and life insurance.
Generous paid holidays and paid time off.
Opportunities for continuing education and professional development. Position Overview: The Data Architect is responsible for ensuring that the data assets of SYD are supported by a data architecture designed to achieve the company's strategic objectives. This role manages data architecture, schema design, databases, data integration, and the technology platforms for data retrieval, reporting, dashboards, and analytics. The Data Architect works with business stakeholders and cross-functional teams to create enterprise data standards. In this role, you will be responsible for extracting, transforming, and loading (ETL) data into a data warehouse, ensuring data quality and integrity across various sources. Participates in a team that defines the overall data policy, data standards, and best practices for the enterprise. Ensures the accuracy and accessibility of all significant data. Works with business stakeholders in the creation and maintenance of enterprise data models. Responsible for the documentation of data dictionaries, data models, data drawings, data process flows, and other artifacts. Manages the development of complex data models and logical database design and develops policies, standards, and procedures for the database environment. Responsibilities:
Design, develop, and maintain ETL processes to pull data from multiple sources (e.g., databases, APIs, spreadsheets) into the data warehouse.
Ensure data is accurately transformed, cleaned, and structured according to business needs and reporting standards.
Design, create and maintain SQL database needs for the company.
Design, develop, and maintain APIs to support web and mobile applications.
Support the creation, management, and enhancement of the company's data warehouse
Develop and drive acceptance of an enterprise view of data and its use across the enterprise. Ensure a common vocabulary and understanding of business entities' relationships.
Provide thought leadership for the definition & maintenance of complex enterprise data models, data dictionaries, and master data management
Capture requirements for new data sources, reports, queries, or dashboards.
Develop, improve, and support enterprise data standards and data architecture policies and procedures.
Monitor and enforce compliance with data standards to minimize data redundancies and enhance information quality throughout the organization.
Document the company data dictionaries, architecture, & schema.
Lead the analysis, design, development & implementation of logical data models; physical databases, data conversions, data integrations, query & reporting functions, data management, data governance, and data quality assurance processes
Provide support and consulting for new projects, to ensure that new applications and data stores integrate with overall enterprise and data architectures.
Par icipate in data, data dictionary, and data process flow documentation to create current state and future state documentation, flowcharts, and plans.
Proactively monitor the various data platforms' performance and reliability to identify and resolve issues.
Coordinate any data, middleware, or BI tool license updates/upgrades, as needed, and approved by management.
Participate in the evaluation of BI technology tools that align with our company's objectives and meet the needs of our team members, customers, and/or suppliers.
Stay updated with industry trends and advancements in data or BI technology to identify opportunities for system enhancements and improvements. Participate in virtual user groups and recommend applicable conferences.
Design, develop, test, and implement automated extract, transformation, and load (ETL's) routines using tools such as SQL, Eclipse Basic, Kore, Query. Qualifications:
Experience in a similar data technology role in a company of similar size preferred
Data warehouse architecture, schemas, data mining, data design and implementation
Strong proficiency with SQL and query building between multiple software platforms
Experience in API design and support.
Proficient in BI tools such as Phocas, Power/BI, Tableau, QlikView or Cognos
Proficient in EDW platform, such as AWS, IBM Netezza, Snowflake, Teradata, or Eclipse PDW
Experience in middleware such as Kore, IBM MQ, Apache Hop, Mulesoft
Ability to resolve complex issues related to enterprise-wide data architecture concerns
Excellent analytical and problem-solving skills.
Strong understanding of data architecture methodologies, schemas & frameworks, and their practical application. Additional Information:
Travel Requirements: Minimal travel may be required. Should travel be required a valid driver's license with a clean driving record is required for this position.
Work Shift and Hours: Monday to Friday: 8 AM - 5 or 7 AM - 4 PM
Physical Requirements: * Ability to use a keyboard and type proficiently. * Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Work Environment: This job operates as a hybrid home / office setting with the balance of the time split between visiting various branches/warehouses and attending meetings. This position requires the use of standard office equipment such as computers, internet, smartphones, and photocopiers.
Other Duties: *Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee, for this job. Duties, responsibilities, and activities may change at any time without notice.
Schaedler Yesco Distribution, Inc. is an Equal Opportunity and Affirmative Action Employer. Schaedler Yesco maintains policies and practices that are designed to prevent discrimination against any qualified employee or applicant on the basis of race, color, religion, ancestry, national origin, sex, age, marital status, sexual orientation, gender identity, protected veteran status, disability, and medical condition to the extent protected by law. This policy of nondiscrimination applies to all employment practices, including hiring, compensation, benefits, promotion, training, and terminatio