Data Warehouse Engineer

BeaconFire Inc; Denver (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

BeaconFire Inc. in Denver is seeking a data-focused professional to design and implement data solutions that meet business needs. You will collaborate with analytics to deliver reliable ETL/ELT processes and ensure data quality.

The role involves data extraction, manipulation, and production from databases, plus building utilities and tests. You will work with architecture and engineering leads to promote engineering best practices and scalable data flows.

Qualifications

• Master’s Degree in Computer Science/Information Technology, Data Analytics, or related discipline.
• Passion for data and a strong desire to learn.
• Intermediate Python and experience with data processing.
• Experience with relational databases (SQL Server, Oracle, MySQL).
• Strong written and verbal communication.
• Ability to work both independently and as part of a team.

Responsibilities

• Collaborate with the analytics team to find reliable data solutions to meet the business needs.
• Design and implement scalable ETL or ELT processes to support the business demand for data.
• Perform data extraction, manipulation, and production from database tables.
• Build utilities, user-defined functions, and frameworks to better enable data flow patterns.
• Build and incorporate automated unit tests, participate in integration testing efforts.
• Work with teams to resolve operational & performance issues.
• Work with architecture/engineering leads and other teams to ensure quality solutions are implemented, and engineering best practices are defined and adhered to.

Skills

Data analysis

Teamwork

Independent work

Education

Master’s degree in Computer Science/Information Technology/Data Analytics

Tools

Python

SQL Server

Oracle

MySQL

Job description

Qualifications

• Passion for data and a deep desire to learn.
• Master’s Degree in Computer Science/Information Technology, Data Analytics/Data Science, or related discipline.
• Intermediate Python. Experience in data processing is a plus. (Numpy, Pandas, etc)
• Experience with relational databases (SQL Server, Oracle, MySQL, etc.)
• Strong written and verbal communication skills.
• Ability to work both independently and as part of a team.

Responsibilities

• Collaborate with the analytics team to find reliable data solutions to meet the business needs.
• Design and implement scalable ETL or ELT processes to support the business demand for data.
• Perform dataextraction, manipulation, and production from database tables.
• Buildutilities, user-defined functions, and frameworks to better enable data flow patterns.
• Build and incorporate automated unit tests, participate in integration testing efforts.
• Work with teams toresolve operational & performance issues.
• Work with architecture/engineering leads and other teams to ensure quality solutions are implemented, and engineering best practices are defined and adhered to.