Data Architecture - Analyst II & Analyst III

As an EEO/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, or veteran status.

Waste Management (WM), a Fortune 250 company, is the leading provider of comprehensive waste and environmental services in North America. We are strongly committed to a foundation of operating excellence, professionalism and financial strength. WM serves nearly 25 million customers in residential, commercial, industrial and municipal markets throughout North America through a network of collection operations, transfer stations, landfills, recycling facilities and waste-based energy production projects.

I. Job Summary
This experienced position is part of a team responsible for the HR Organization’s reporting and analytics needs. Most specifically this position will be aligned with the HR Data Architecture team and will assist with creating the HR Organization’s data architecture within the Enterprise Data Warehouse (Snowflake). With experienced team members, may provide input for delivering data products both internal to the HR Organization as well as external to the broader organization at WM. Will be responsible for analyzing and interpreting data to define requirements for new or existing data pipelines as relates to HR data, understand meaningful patterns, and will work closely with the HR Data Architects to document the HR data lineage and provenance. 

II. Essential Duties and Responsibilities

• Monitor HR Reporting and Analytics daily tasks, troubleshoot data related issues and report to Data Management Team for resolution as needed
• Analyze requirements and translate to technical specifications
• Manage ETL pipeline tickets with cross-functional teams, reviews open cases and troubleshoots as needed
• Create test plans and test scenarios for ETL pipeline
• Execute unit/integration/acceptance testing
• Collaborate with data engineers, data architects and business stakeholders to ensure data quality and integrity
• Design and maintain data models that support business needs and assist as-needed with ad-hoc report requests
• Create and maintain documentation related to data models, data products, data catalogs, dataflow diagrams and transformation diagrams
• Create and maintain data definitions and data catalogs.
• Collaborate with HR stakeholders and Digital teams to ensure alignment between HR data architecture and the organization's overall data infrastructure and strategy.
• Provide technical expertise and guidance to HR teams on data-related issues and solutions.
• Participate in cross-functional projects and initiatives to ensure the integration and alignment of HR data with other business functions.
• Remain current with industry trends and emerging technologies related to data architecture.
• Provide training to team on new technologies as needed/desired.

Data Governance

•  Assist with data governance/stewardship activities (i.e., data retention/purge, access, data integrity, security, etc.
• Manage data governance practices and ensuring compliance with data privacy regulations and security standards.
• Ensure data integrity and governance by supporting data imports and extracts and validating accuracy through reporting and queries. Supports integrations/file transfers
• Train and mentor HR Technology staff on data management best practices, data governance, and data handling procedures.

III. Supervisory Responsibilities

• No formal supervisory responsibilities in this position. 
• Provides informal assistance such as technical guidance and/or training to coworkers.
• May lead project teams and/or plan and supervise assignments of lower level employees.

IV. Qualifications
The requirements listed below are representative of the qualifications necessary to perform the job.

A. Education and Experience

• Education: Bachelor’s Degree (accredited), or in lieu of degree, High School Diploma or GED (accredited) and four (4) years of relevant work experience. 
• Experience: 2 Years to 3 Years - Previous experience with managing ETL pipelines, and/or experience with designing data models and reports specific to HR in a data warehouse, experience with Oracle Cloud HCM

B. Certificates, Licenses, Registrations or Other Requirements

• None required.

C. Other Knowledge, Skills or Abilities Required

KSAs Proficiency Strong project management and organization skills   Critical thinking   Adaptable   Strong multi-tasking skills   Execution mentality   Self-starter   Excellent written and verbal communication skills   Strong analytical skills   Ability to provide efficient, timely, reliable and courteous service to business partners   General HRIS system experience   Knowledge of HR data   Strong Microsoft product experience   Knowledge of data modeling, relationship database, data warehousing, database architecture, and SQL   Knowledge on data stewardship/governance   Strong troubleshooting and problem solving skills   Some experience in business intelligence tools a plus (PowerBI, Tableau)  

V. Work Environment
Listed below are key points regarding environmental demands and work environment of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.

• Required to use motor coordination with finger dexterity (such as keyboarding, machine operation, etc.) most of the work day;
• Required to exert physical effort in handling objects less than 30 pounds rarely;
• Required to be exposed to physical occupational risks (such as cuts, burns, exposure to toxic chemicals, etc.) rarely;
• Required to be exposed to physical environment which involves dirt, odors, noise, weather extremes or similar elements rarely;
• Normal setting for this job is: office setting.
• Must be available to work standard business hours, as well as be available to work non-standard hours in case of emergency (natural disasters, power outages, etc.). May need to attend after hours calls with the offshore team.

Benefits
At Waste Management, each eligible employee receives a competitive total compensation package including Medical, Dental, Vision, Life Insurance and Short Term Disability. As well as a Stock Purchase Plan, Company match on 401K, and more! Our employees also receive Paid Vacation, Holidays, and Personal Days. Please note that benefits may vary by site.

If this sounds like the opportunity that you have been looking for, please click "Apply.