Job description

This is a hybrid role which requires you to be in our Richardson office 2 days a week. As an Azure Data Engineer, you will be responsible for developing Data Engineering workloads as part of our solutions. As part of a small, dynamic team, you will have the opportunity to contribute to multiple phases of the solution life cycle including designing and implementing models and processes for large scale datasets used for analytics and AI. Key Responsibilities: • Use Azure Data Factory extensively for ingesting data from disparate source systems. • Use Azure Data Factory as an orchestration tool for ingesting data from upstream to downstream systems. • Automate jobs using different triggers (Event, Scheduled and Tumbling) in ADF. • Perform T-SQL and Workflows performance tuning and optimization of queries for reports that take longer execution time. • Use T-SQL to develop DDL, DML and dynamic SQL daily. • Extract data from heterogeneous sources (OLTP, Flat Files, and Microsoft Excel) and transferred to OLAP using ADF pipeline/SSIS Package. • Maintain code version in the repository with Git/VSTS. • Use Pull Request to Create/ Review/Merge scripts in Git repository in Azure Repos. • Involve with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance. • Write complex stored procedure, views using T SQL using SQL management studio. Skills, Knowledge and Expertise: • 3+ years of general technology experience of which 2 years of programming experience (T-SQL, Python, PySpark) • 2 years leveraging cloud-based architectures (Azure) • Nice to have - integration experience with all or any of the following: Azure Data Factory, Databricks, Azure Synapse Analytics, SQL Server Integration Services, Informatica, Microsoft Fabric, etc. • Must possess exceptional analytical and troubleshooting abilities • Highly motivated individual with strong sense of ownership • Must be proactive with solid organizational and time management skills • Strong written and verbal communication skills • Must be eligible to work in the US indefinitely (without the need for visa or sponsorship) Benefits: • A culture that both wows our customers and employees; • Variety of challenging projects, and the ability to work with leading-edge technologies; • Competitive salary & group benefits; • Generous training and education opportunities; • Diverse team social events; • Be part of a team that believes in diversity, inclusion, and a fun atmosphere! Company DescriptionAs a premier IT professional services firm, we specialize in helping organizations envision, implement, and run Microsoft technologies to achieve AI excellence. At Lantern, our company culture stands as the bedrock of our success and a source of pride for our teams. We firmly believe that a culture founded on trust forms the basis for enduring relationships with clients, colleagues, and partners. Within this culture, we nurture an environment of respect, inclusion, and belonging, fostering collaboration among inspired teams. We prioritize the well-being of our colleagues, the success of our clients, and our positive impact on society. As a Microsoft services partner, we hold ourselves to the highest standards of technical excellence. This commitment to quality is evident not only in our work but also in how we support and empower our employees. At Lantern, our culture mirrors our core values and unwavering dedication to realizing our purpose and vision, making it a dynamic and fulfilling workplace. Together, we transcend the ordinary and achieve extraordinary results.

Requirements