What are the responsibilities and job description for the Data Engineer position at Lutz?
Lutz Tech is an information technology firm that partners with local businesses to simplify the complex world of tech. Our team believes in saying it straight, pushing ourselves to be the best, and serving our teammates as well as our clients.
Role Summary: We are seeking a highly skilled and versatile Data Engineer to join our team. This individual will be instrumental in connecting to various data sources, understanding and interpreting data structures from a business perspective, and developing efficient data pipelines that feed into our Power BI reports. The ideal candidate will have a strong background in relational databases, experience with cloud and API data integration, and the ability to manage multiple projects across different industries.
Responsibilities Include:
- Design and implement data integration solutions to connect with various source systems, including custom applications and off-the-shelf software.
- Understand and interpret data structures, mapping source data to common data tables and developing reporting models to support Power BI report development.
- Work with relational databases (SQL Server, Azure SQL), familiarity with NoSQL environments a plus.
- Utilize Microsoft Fabric pipelines or individual components such as Synapse and Data Factory for data processing and management.
- Optionally, administer Power BI environments, including setup, security, and maintenance.
- Monitor capacity metrics and determine potential efficiency gains on the Power BI data flows or pipelines.
- Collaborate with teams to understand business requirements and translate them into technical specifications.
- Manage multiple data engineering projects simultaneously, effectively context-shifting between different industries and client needs.
Requirements:
- Minimum of 3 years of experience in data engineering or a closely related role.
- Bachelor’s degree in Computer Science, Information Technology, Business Analytics, Engineering, or a related field.
- Experience in managing multiple projects with the ability to shift contexts effectively between different industries and client needs.
- Familiarity with Power BI or similar business intelligence tools, including report development and, ideally, administration.
- Experience in working with NoSQL databases is desirable but not mandatory.
- Proven experience with SQL Server, Azure SQL, and other relational databases.
- Demonstrated ability in developing and implementing data integration solutions with various source systems.
- Hands-on experience with Microsoft Azure Data Services (e.g., Data Factory, Azure Synapse Analytics) or similar cloud data services.
- Strong understanding of data structures and the ability to map source data to common data tables for analytics purposes.
- Excellent problem-solving skills and the ability to understand complex business requirements and translate them into technical solutions.
- Strong communication and collaboration abilities.
