Data Engineer

Troy (2-3 Days) / Remote (3-2 Days) - Local candidates preferred

Actively seeking a Data Engineer who possesses a strong passion for designing, optimizing, refactoring, and upgrading complex data solutions. The Insights team is a new team with an exponential growth opportunity – both in terms of technology and personnel, and they are looking for someone to share their mission that will transform their company’s future. With this position, you will have a rare opportunity to use your talents, passions, and expertise to help drive this massive change in how we build, organize, and optimize our backend systems and processes across all product lines. This position offers excellent career growth and promotional opportunities, and stellar compensation.

Required Experience (Must have)

• Minimum 5+ years’ data engineering experience working with designing data models in both column store and relational databases, incorporating disparate data to solve complex business needs.
• Minimum Bachelor’s degree or Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
• Experience building and optimizing data pipelines, architectures, database modeling and data sets that meet business requirements.
• Experience in building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources in ‘big data’ technologies or similar. Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.
• Experience in building processes supporting data transformation, analytics tools, data structures, metadata, dependency, and workload management. Assist Data Science team that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and optimizing our product into an innovative industry leader.
• Experience in using Azure DevOps, or Jira project management/requirements management.
• Experience with big data tools: Hadoop, Spark, Kafka, or a related technology.
• Proficient in programming languages such as SQL, Python, R, Shell Scripting

Desired Experience (Nice to have)

• Experience with NoSQL databases, including Postgres and Cassandra is a plus
• Strong working experience with technologies like AWS/Databricks and (minimum 3+ years’ experience) working with big data, including expertise designing data models in both column store and relational databases, incorporating disparate data to solve complex business needs
  • AWS lambda functions (Python preferred)
  • AWS databases (Aurora, DynamoDB, or Redshift preferred)
  • AWS storage services (EC2, S3 preferred)
  • Data Lake experience or similar (AWS preferred)

Primary Responsibilities

• Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development, implementation and management of data warehouses and data analytics systems.
• Identifying data sources, both internal and external and work out a plan for data management that is aligned with organizational data strategy.
• Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system.
• Managing end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.
• Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
• Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.