As a Data Engineer, you will play a critical role in designing, developing, and maintaining our organization's data infrastructure. You will work closely with others in the Information Technology department: analysts, developers, administrators and engineers to extract, transform, and load data from various sources into our data repositories. You will also work with others within the business (e.g. business process) to drive and deliver improvements.
The ideal candidate will have advanced expertise in SQL, including JSON parsing skills, as well as extensive knowledge of stored procedures, JavaScript/Python integration, and advanced database-table relationship processing techniques.
You will be empowered with the opportunity to go above and beyond to simplify our user experiences while enhancing our data posture to improve our products and services we deliver. Behind the scenes, this dedicated individual's focus will follow a continuous improvement model on refining solutions, improving experiences of every user and make data accessible and usable for our business to make informed decisions.
Pay Range: $85,000-100,000 depending on experience
Full Time Location: Centennial, CO
DUTIES & RESPONSIBILITIES
General
- Participate in design and architecture of software solutions with focus on ETL data management
- Design, develop, and optimize complex queries to support data discovery, analysis, and reporting. Leverage databases to ensure accurate data staging and transformation processes that align with business requirements
- Develop and implement data staging strategies to prepare data for analysis and reporting
- Conduct thorough data discovery to identify and address data quality issues (including handling of structured or unstructured data in data lakes, data warehouses or other data repository types), ensuring that the data is accurate, complete, and accessible for business needs
- Partnering with our business, business process group and key stakeholder teams to create effective solutions
- Embrace challenges and seek innovative solutions to enhance the performance and scalability of data systems and applications
- Drive improvements and push the boundaries of existing processes to elevate data engineering efforts and impact
Data Engineering
- Design, develop, and maintain robust data pipelines to ingest, process, and transform raw data from various sources (e.g., databases, APIs, connectors, cloud storage) into actionable insights
- Optimize data pipelines for performance, scalability, and reliability
- Implement and ensure data quality and reliability checks and monitoring to ensure data accuracy and consistency
- Collaborate with analysts to understand data needs and translate them into technical solutions
Data Modeling
- Design and implement data models (e.g., hierarchical, network, relational, entity-relationship, dimensional, star schema) to efficiently store and retrieve data
- Optimize data models for query performance and scalability
- Manage and maintain data repositories, data warehouses and data lakes, including structured and unstructured data, data loading, indexing, and partitioning
- Implement data security and privacy measures to protect sensitive information
Data Governance
- Contribute to the development and implementation of data governance policies and standards
- Ensure compliance with data regulations and industry best practices
MINIMUM QUALIFICATIONS
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Minimum 5 years experience as a Data Engineer
- Experience with data engineering tools and technologies (e.g., SQL, Power BI, Tableau)
- Knowledge of cloud platforms (e.g., Snowflake) and cloud-native data services
- Experience with data repositories, data warehousing and data modeling concepts
- Understanding of data quality and data governance principles
- Strong analytical and problem-solving skills
- Excellent communication and collaboration skills.
- Worked with and/or delivered in house custom solutions
- Experience with Enterprise Service Bus (ESB) platforms (e.g., iPaaS, Tray.io a plus) used to integrate applications
- Strong technical writing capabilities
- Strong analytical, problem-solving, and troubleshooting skills
PREFERRED QUALIFICATIONS
- Certifications in cloud platforms or data engineering
- Experience delivering and supporting custom and SaaS applications
- Demonstrated knowledge of scripting languages (e.g., .NET using C#, PowerShell, Python, etc.)
- Proven skillset in SQL or other enterprise database query languages
- Knowledge of machine learning and artificial intelligence concepts
- Demonstrated experience with Source Control solutions such as GitHub
- Demonstrated continuous improvement of application solutions and business processes
- Front line leadership, management skills to lead a technical team and be the voice across all levels of the organization
Job Type: Full-time
Pay: $85,000.00 - $100,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Schedule:
- 10 hour shift
- 8 hour shift
- Monday to Friday
- On call
- Weekends as needed
Education:
Experience:
- Data engineering: 5 years (Required)
Work Location: In person
