Data Engineer III

About the Role

Key Responsibilities

• Architect, build, and maintain data pipelines through acquisition, ingestion, staging, and modeling
• Provide architectural input to program leadership for project teams to develop solutions that align with long-term data warehouse strategy
• Responsible for the identification and qualification of source data to satisfy master and transactional data requirements for the target warehouse
• Lead data assessment and mapping activities, and develop the underlying migration framework to extract, transform, validate, enrich, and load the source data
• Define reusable solution architectures using standard modeling practices
• Design and deliver solutions that are reliable and scalable and focused on driving automation and improving productivity
• Apply fundamental understanding of data warehousing principles
• Assess impacts of solution architecture on design, build, and test efforts

Requirements

• HS Diploma or equivalent required; bachelor's degree in business with MIS or technology related degree (C.S.) preferred
• 3-5 years experience with cloud data warehouses such as Snowflake
• Experience working with complex SQL code
• Experience with DevOps capabilities like version control, automated builds, testing, and release management using tools like Git
• Moderate experience with message queuing technologies such as Azure Service Bus, Apache Nifi, Apache Kafka, etc., and with replication software like Fivetran or HVR
• Experience with SQL Server 2008+, SAP Hana, Tableau, Power BI, R/Python, and Dbt preferred
• Strong experience with Data Management architectures like Data Warehouse, Data Lake, Data Hub, Data Vault and related processes
• Experience working with large, heterogeneous datasets using ETL/ELT, data replication/CDC, message-oriented data movement, and API-based data acquisition
• Ability to think big picture, manage multiple demands in a fast-paced environment, demonstrate good judgment, and communicate effectively

Nice to Have

• Experience with open-source or commercial message queuing technologies
• Experience with data visualization tools like Tableau and Power BI
• Knowledge of data governance and metadata management

Qualifications

• HS Diploma or equivalent; bachelor's degree in business with MIS or technology related degree (C.S.) preferred

Benefits & Perks

• Fuel Your Growth with Love's - company funded tuition assistance
• Paid Time Off
• 401(k) - 100% Match up to 5%
• Medical/Dental/Vision Insurance after 30 days
• Competitive Pay
• Career Development