Lead a two-month project to assess the current data environment and design, build, and optimize a scalable cloud data warehouse, implement automated ETL/ELT pipelines, develop dimensional analytics-ready datasets, ensure data quality and performance, document architecture and deliverables, and report progress to the CEO.
LearnTastic is looking for an experienced Data Engineer to lead a two-month project to assess our current data environment and design, build, and optimize a scalable cloud data warehouse. This role will be responsible for recommending the overall data architecture, building reliable ETL/ELT data pipelines, and creating analytics ready data sets that enable business intelligence and reporting. You will work closely with data analysts, and business stakeholders, and the CEO to establish and deliver a scalable foundation for future data and analytic initiatives.Responsibilities:
- Assess the current data environment and recommend a scalable cloud data warehouse architecture.
- Design, build, and optimize a cloud data warehouse and supporting data models.
- Build and maintain automated ETL/ELT pipelines from multiple data sources.
- Develop analytics ready data sets using dimensional modeling (star/snowflake schemas).
- Ensure data quality, integrity, and performance, and governance.
- Optimize SQL queries and database performance.
- Partner with data analytics and business stakeholders to support business intelligence and reporting.
- Document the data architecture, pipelines, and data models, and provide recommendations for future scalability.
- Provide regular project updates and recommendations to the CEO.
- 5+ years of experience in Data Warehouse Engineering or Data Engineering, or a similar role.
- Strong SQL skills with experience optimizing complex queries and database performance.
- Hands-on experience with ETL/ELT pipelines.
- Experience designing and implementing cloud data warehouse solutions (e.g., Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse).
- Solid understanding of dimensional data modeling (e.g. star and snowflake schemas).
- Experience with Git and version control.
- Experience designing scalable data architectures.
- Experience with Python.
- Knowledge of dbt and data orchestration tools such as Apache Airflow, Azure Data Factory, or AWS Glue.
- Experience with AWS, Azure, or Google Cloud.
- Familiarity with BI tools such as Power BI, Tableau, QuickSight or Looker.
- Experience integrating data from APIs, SaaS applications, and relational databases.
- Strong analytical, problem-solving, and communication skills.
Expected Deliverables:
- Production-ready cloud data warehouse
- Automated ETL/ELT pipelines for agreed upon data sources
- Documented data models
- Optimised reporting datasets
- Technical architecture diagrams and documentation
- Data dictionary and pipeline documentation
- Knowledge transfer and handover
- Recommendations for future scalability
Location: Remote
Contract Duration: 2 months
Reporting Line: CEO
Contract Duration: 2 months
Reporting Line: CEO
Similar Jobs
Artificial Intelligence • Cloud • Security • Software • Cybersecurity
Serve as a trusted technical advisor for enterprise customers, driving product adoption, analyzing IT operations, recommending configurations and best practices, supporting renewals, conducting business reviews, and collaborating with product and engineering teams to improve customer outcomes.
Top Skills:
AWSAzureChefDatadogDockerGCPGitlabGoJavaScriptJenkinsKubernetesPerlPHPPuppetPythonRancherRuby
Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
Lead the design for a critical product area, collaborating with teams to craft effective user experiences while leveraging AI tools for prototyping and testing. Influence product strategy and uphold design standards while mentoring junior designers.
Top Skills:
Ai-Assisted Prototyping ToolsCode-Generation ToolsFigma
Fintech • Payments • Software
Lead Flywire’s South African regulatory compliance and AML/CTF program in a remote fintech role. Responsibilities include localizing FICA-compliant policies and risk programs, monitoring NPS and fintech regulations, assessing licensing requirements, managing relationships with FIC, SARB and FSCA, overseeing regulatory filings, supporting payment partners and product launches, assisting with sanctions, transaction monitoring and KYC/CDD, preparing executive and regulatory reporting, conducting acquisition due diligence, and supporting AI initiatives related to AML and sanctions.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
