Job description

This position will be part of the development team that owns all aspects of data processing including data warehouse architecture, modeling and ETL Processing from beginning to end including opportunity identification, problem scoping, framing analysis, execution of analysis, and presenting results in a tangible and digestible way to stakeholders and executives.

• Partner with business stakeholders to gather requirements and translate them into technical specifications and process documentation for IT counterparts (on-prem and offshore)
• Design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata, and workload management
• Develop a deep understanding of operations, data, data sources, and data integration with a view to creating deep and meaningful insights that drive business value
• Work with the Data Product team to identify and import data from a variety of ERP sources into our cloud-based environment to support future analytics needs
• Develop and ensure adherence to published system architectural decisions and development standards

•
EDUCATION

• Bachelor's degree in a quantitative field with 7 years of experience or master’s with 5 years of experience.

EXPERIENCE (and Other Qualifications)

• 7+ years' experience working in ETL positions in operational environments or business consulting organizations
• Excellent communication skills with a track record of successfully advocating turning insights into action
• ETL/ELT, data replication/CDC, message-oriented data movement, API design and access.
• Hands on experience in Matillion as the ETL tool

• Experience with Snowflake cloud data platform including Snowflake utilities like Snow SQL, Snow Pipe. Snowflake certification is a plus.

• Strong expertise in data modeling and building Logical Data Model (LDM), and Physical Data Model (PDM), Star/Snowflake Schema to assist in fast reporting and BI dashboards.
• Must have exposure with development, configuration, and deployment on Azure Cloud technologies

o Experience with programming languages, including Python, R and Java, SQL, PL/SQL for relational databases

Job Type: Full-time

Pay: $110,000.00 - $130,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Compensation package:

• Bonus pay
• Yearly pay

Experience level:

• 6 years

Schedule:

• Monday to Friday

Experience:

• Snowflake: 5 years (Required)
• SQL: 6 years (Required)
• Cloud architecture: 3 years (Preferred)

Work Location: Remote

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.