Data Engineer/Modeler

Job Title: Data Engineer/Modeler
Job Number: 22164
Type of Employment: Permanent Role

Overture Partners client has an exciting opportunity for a Data Engineer/Modeler to work with an industry leader in a fully remote role. The ideal candidate must have excellent communication and collaboration skills.

Opportunity Overview:

• Advocate for well founded data management practices to foster a better understanding of data and analytics.
• Responsible for definition, development and execution of strategies to implement and enhance data ecosystem.
• Interact with stakeholders and subject matter experts to determine project requirements that align with business goals
• Partner with colleagues and relevant subject matter experts on analytical solutions and models to ensure optimization of data quality, security to deploy them production
• Prioritize, scope and manage data engineering projects.
• Discover, understand, and integrate new internal and external data sources, structures, and process pipelines.
• Drive and participate in all tasks associated with design, development, implementation, and support of ETL/ELT processes
• Implement data structures on a variety of databases and platforms, including data lakes, data warehouses, online caches and near-time systems, SQL Server, Oracle, Teradata, Redshift, MongoDB, DynamoDB, and Snowflake.
• Perform various data modeling methodologies like relational 3rd normal form, star schema, snowflake schema, schema-on-read, data vault, etc. to design and implement data models.
• Architect, implement, optimize and maintain reliable data pipelines from source acquisition to integration and consumption while guaranteeing compliance with data governance and data security requirements.
• Use cutting edge tools and methodologies/architectures to automate repeatable tasks to improve productive and limit errors

Qualifications & Required Skills

• Proven experience with data management disciplines.
• Experience with  data integration, data modeling, optimization and data quality that is commensurate with job level.
• Working knowledge of data discovery, analytics, visualization and business intelligence tools.
• Strong experience with scripting languages such as Python, PowerShell, and Linux.
• Understanding of at least one formal programming language Java, or C++.
• Basic understanding of ETL/ELT platforms such a SSIS, DataStage or Informatica.
• Thorough knowledge of relational and non-relational database theory and structured query language (SQL).
• Ability to design, build and optimize data pipelines, ETL processes, and data structures.
• Demonstrated success integrating large, heterogeneous datasets and automating repetitive data preparation tasks.
• Skilled working across multiple deployment environments including cloud, on-premises and hybrid.
• Adept applying software engineering methodologies and DevOps principles to data pipelines to improve the communication, integration, reuse and automation of data flows across the organization.

Educational Requirements:

Bachelor’s degree in data management, computer science, information systems, mathematics, data/analytics or a related field or equivalent work experience is required.