Sr Cloud Data Engineer- hybrid in Pittsburgh, PA

Location: Remote but prefer local candidates

Job Type: Contract/Full- Time

Work Authorization: No Sponsorship

The A.C.Coy Company has an immediate need for a Sr Cloud Data Engineer. Ideal candidate will be qualified with designing, developing, and implementing data models.

Strategy & Planning

• Execute long-term strategic goals for data architecture vision and standards in conjunction with data users, department managers, clients, and other key stakeholders
• Develop short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
• Collaborate with third-parties, product/platform teams and business subject matter experts to enable company strategic imperatives that require secure and accessible data cloud capabilities or assist in accessing data required to enrich models
• Collaborate with IT Enterprise Architecture, Business Intelligence, Data Engineering, Data Quality and Data Governance stakeholders to:
  • Adhere to and advocate for processes for governing the identification, collection, and use of corporate metadata
  • Take steps to assure metadata accuracy and validity
  • Tracking data quality, completeness, redundancy, and improvement
  • Contribute to cloud consumption cost forecasting, optimizations, usage requirements, proof of concepts, proof of business value, feasibility studies, and other tasks
  • Actively participate in the creation of strategies and plans for data security, backup, disaster recovery, business continuity, and archiving
  • Comply with data strategies, architecture best practice to ensure regulatory compliance

Acquisition & Deployment

• Participate in technical proposals with vendors, cloud providers, and service providers to select the solutions or services that best meet company goals as required

Operational Management

• Ensure that Data Engineering processes follow best practices for SDLC including proper use of source control, branching strategies, deployment pipelines, and change management
• Assisting to maintain artifacts that represent the current-state, and future-state, system design as part of the technical roadmap for Data
• Perform regular peer reviews of code and contribute to the success of all data team members
• Contribute to and promote data management methodologies and standards
• Investigate and implement the appropriate tools, software, applications, and systems to support data technology goals
• Ensure the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
• Work with project managers and business unit leaders on project assignments involving enterprise data
• Assist with data-related problems regarding systems integration, compatibility, and multiple-platform integration
• Develop key components as needed to create testing criteria to guarantee the fidelity and performance of data architecture
• Update the data architecture and environment to maintain a current and accurate view of the implemented structure
• Identify and develop opportunities for data reuse, migration, or retirement
• Contribute to the maintenance of data engineering code by identifying and advocating for paying down tech-debt

Education: Bachelor’s degree in computer science, information systems, or computer engineering- In lieu of a bachelor's degree, an equivalent combination of education and experience may be considered

Experience:

• Seven (7+) or more years related experience required
• Five (5+) or more years in a data engineering role preferred
• Two (2+) or more years' experience as a project or team lead preferred

 Technical Knowledge & Experience Utilized in this Role Include:

• Knowledge of data architecture concepts, data mining, large-scale data modeling, cloud data storage, and analytics platforms
• Experience with Azure, AWS, or Google data capabilities
• Working experience with one or more cloud data platforms, such as Databricks, Synapse, Foundry, or Snowflake
• Advanced experience with one or more Cloud Based ELT/ETL services, such as Azure Data Factory or AWS Glue
• Experience performing data profiling
• Working knowledge or experience with one or more reporting and/or analytics platforms, such as PowerBI, Tableau, or Looker
• Direct experience in implementing data solutions in the cloud
• Experience in deploying infrastructure as code
• Advanced knowledge of relational data structures, theories, principles, and practices
• Strong familiarity with metadata management and associated processes
• Experience with business requirements analysis, entity relationship planning, database design, reporting structures, and so on
• Ability to work with data owners in support of a data catalog
• Experience with database management systems, including Oracle RDBMS and SQL Server
• Understanding of Web services (SOAP, XML, UDDI, WSDL)
• Understanding of object-oriented programming principals
• Excellent client/user interaction skills to determine requirements
• Project management, Product Management and/or Agile Product Team experience preferred
• Awareness of applicable data privacy practices and laws