Position Summary
The Data Engineer will be responsible for the design, development, implementation, and continuous improvement of reporting platform and architecture. This position will be responsible for Business Intelligence (BI) and Data Analytics, providing high-value, timely data solutions to internal and external data stakeholders. Regular collaboration will occur with business, technology, and software development teams to ensure we exceed expectations for data, information, and reporting.
Essential Duties and Responsibilities
· Data Warehouse/Data Lake Architecture and Development
· Data Modeling & Architecture
· Design and maintain the architecture in reporting platforms, including the QuickSight
· Synthesize many disparate data sources into one centralized data platform
· Lead efforts to design, develop and implement database enhancement to improve efficiency and streamline the use for analytics, business analysis
· Scope out and develop data enhancement plans for company initiatives
· Implement and enforce data validation procedures.
· Make suggestions for improvements to the data team and team processes
· Produce complete and accurate reports to business entities and users.
· Other duties as assigned
Required Knowledge, Skills, and Abilities
· Expert level in AWS data tools (QuickSight)
· Expert level user of Microsoft SQL Server tools and SQL
· Expert level working knowledge of The Python language
· Experience validating databases for accuracy
· Experience working with API and event-driven architectures.
· Experience working with ETL/ELT Pipelines
· Knowledge of how data entities and elements should be structured to assure accuracy, performance, understanding, operational, analytical, reporting, and data science efficiencies
· Applied knowledge of cloud computing and RPA programming/machine learning
· Applied knowledge of data modeling principles (e.g., dimensional modeling and star schemas)
· Must be a self-directed professional with the ability to work effectively in a fast-paced demanding environment, handle multi-tasks, problem solve and effectively follow-through
· Work collaboratively with internal partners/departments
Education and Experience
· Bachelor’s degree required in Data Science, Software Engineering, Information Technology, or a related field
· Minimum 5 years hands experience. with AWS Data Tools
· 2+ years of experience as a technical lead on data and analytics projects
· 5+ years of experience architecting and maintaining enterprise data platforms
Requirements
- hands-on experience with modern data lake/lakehouse patterns, S3-based pipelines, Glue, Step Functions, Athena, or event-driven orchestration.
- real-world implementation experience to be able to articulate tradeoffs between architectural approaches like snapshotting vs diffing vs time-travel
- Solid experience in traditional OLAP environments
- high level of comfort and willingness to be working at the infrastructure or , writing Python-based ELT logic, using SDKs like Boto3 or CDK, or contributing to CI/CD automation and platform tooling
- able to contribute to foundational platform design or reusable framework development
- comfortable working in ambiguity-heavy environment that requires creating new patterns and processes.
- Ability to collaborate with other data engineers on SQL transformation logic and business rules in parallel with establishing core pipeline and platform
- someone who can help drive the modernization of our platform, through IaC, scalability, and NAWS automation
- demonstrated taking initiative on own (self-directed) in past roles (e.g., manually deploying CloudFormation templates, standing up some automation).
Job Type: Contract
Pay: $60.00 - $65.00 per hour
Work Location: Remote
