Junior/Mid Data Engineer

Turnberry Solutions is a consulting company that provides insights into company data and advanced analytics solutions. As a Junior/Mid Data Engineer, you will join the Data Strategy and Intelligence practice to assist in building data solutions and improving data management processes.

Responsibilities:

• Assemble large, complex data sets that meet functional/non-functional business requirements
• Perform complex data analysis and investigation for customer requests to explain results and to make appropriate recommendations
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management
• Analyze business objectives and develop data solutions to meet customer needs
• Improve and customize current data solutions to meet business functional and non-functional requirements
• Research new and existing data sources in order to contribute to new development, improve data management processes, and make recommendations for data quality initiatives
• Perform periodic data quality reviews for internal and external data
• Ensure timely resolution of queries and data issues
• Look for new ways to find and collect data by researching potential new sources of information
• Work with data and analytics experts to strive for greater functionality in our data systems

Requirements:

• 3–5+ years of experience in data engineering
• Experience building and maintaining scalable data pipelines and data platforms
• Strong problem-solving and data troubleshooting skills
• Detail-oriented with focus on data accuracy and traceability
• Ability to work across data, BI, and governance teams
• Strong knowledge of SQL required
• Ability to identify sets and subsets of information across multiple joins or unions of tables is preferred in addition to writing and troubleshooting SQL queries for data mining
• Strong understanding of data modeling concepts
• Problem solver with the initiative to think critically to identify improvement opportunities (error detection, error correction, root cause analysis)
• Understand ETL that will aid in verification and testing of data
• A successful history of manipulating, processing, and extracting value from large disconnected datasets
• Demonstrated ability to effectively participate in multiple, concurrent projects
• Education: Bachelor's degree in Computer Science or Engineering from an accredited University or College - OR Associate's degree in Computer Science or Engineering from an accredited University or College with two (2) years of experience
• Technical Skills: Strong proficiency in SQL, Python
• Experience with ETL/ELT development, Data ingestion and transformation frameworks
• Understanding of Delta Lake/modern data storage formats, Medallion architecture (Bronze/Silver/Gold layers)
• Data and Platform Expertise: Strong understanding of data transformations (cleaning, shaping, aggregating, and preparing data for downstream use), Data lineage (ability to track where data comes from, how it is transformed, and where it is consumed), Data quality and governance concepts
• Experience supporting reporting and analytics (Power BI preferred)
• Familiarity with data security and access controls (RBAC)
• Microsoft Fabric experience
• Data catalog/lineage tools (Purview or similar)
• CI/CD (Azure DevOps, Git)
• Basic streaming or real-time ingestion exposure