Tek Tron IT ยท 1 day ago
Data Engineer
United States
Full-time
Remote
Senior Level
6+ years exp
Maximize your interview chancesIT Services and IT Consulting
Insider Connection @Tek Tron IT
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design, develope, and maintain ELT pipelines using Python, Airflow, and SQL in an AWS environment.
Create and manage a data lake and data warehouse solutions on AWS.
Develop and maintain data-driven dashboards and reporting solutions in PowerBI.
Connect PowerBI to SQL Server and PostgreSQL Aurora databases using a gateway.
Perform data profiling and source system analysis to ensure data quality and integrity.
Collaborate with business stakeholders to capture and understand data requirements.
Implement industry best practices for data engineering and visualization.
Participate in architectural decisions and contribute to the continuous improvement of data solutions.
Follow agile practices and a Lean approach in project development.
Optimize SQL queries for performance and ensure efficient database operations.
Perform database tuning and optimization as needed.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Expert-level proficiency in SQL (TSQL, MS SQL) with a strong focus on optimizing SQL queries for performance.
At least 6 years of experience will be preferred.
Extensive experience with Python and Airflow for ELT processes.
Proven experience in designing and developing data warehousing solutions on the AWS cloud platform.
Strong expertise in PowerBI for data visualization and dashboard creation.
Familiarity with connecting PowerBI to SQL Server and PostgreSQL Aurora databases.
Experience with REST APIs and JSON.
Agile development experience with a focus on continuous delivery and improvement.
Excellent problem-solving skills and a proactive 'can-do' attitude.
Strong communication skills and the ability to work collaboratively in a team environment.
Curiosity and eagerness to learn and adapt to new technologies and methodologies.
Ability to perform database tuning and optimization to ensure efficient data operations.
Company
Tek Tron IT
TekTron is an award-winning full-service executive search firm, direct-hire, and temporary staffing agency that provide clients with extraordinary talent for hire.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
