Job Information
Insight Global INTL India - Lead Data Engineer in Bristol, Connecticut
Job Description
Evergreen is looking for a strong Lead Data Engineer to lead a challenging effort to replace an in-house proprietary billing process with one based on Azure Data Factory, SQL Server, and T-SQL, supported with reporting in Power BI. This role will require a highly skilled individual capable of effectively balancing hands-on development responsibilities with leadership and support of the development team. Must possess a high degree of personal initiative and superior problem-solving capabilities. If you like challenging work in a fast-moving team-oriented environment this is the opportunity for you!
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Skills and Requirements
10+ years of experience with Microsoft SQL Server with at least 5 years of that time being with SQL Server on Azure. Must possess a high degree of mastery in the following:
Relational Database Design principles related to transaction processing systems
TSQL Stored Procedures & Functions
Table and View Design including Common Table Expressions
Temporary Table and Table Variable use and management
Query Performance tuning including demonstrable ability to generate and read a Query Plan
Deep understanding of the design factors and practices associated with efficient use of large (> 2 million) row tables
Comprehensive knowledge of Structured Query Language, especially Joins and Derived Tables
5+ years of experience with Azure Data Factory, including data copy operations, executing and capturing stored procedures outputs, variables, and data pipeline creation. Must also show clear understanding of scheduling and running pipelines based on events. Must be able to integrate pipeline notifications with messaging systems like email.
Must have a deep understanding and practical experience building Medallion-style ELT processes and pipelines
Must be able to formulate and execute detail plans from high-level designs with minimal oversight or handholding
Must be comfortable with and willing to write stories and tasks in JIRA
5+ years of experience as a technical lead of a Data Engineering team or similar 3+ years of hands-on experience designing and building Power BI reports
Azure Architect Certification with 2+ years of hands-on experience creating and configuring Azure services