Data Engineer

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

Data Engineer

Business Intelligence | Houston, TX

alliantgroup is currently in search of a full-time employee to execute visionary changes to the way we provide data analytics to create competitive edge solutions for improving our customer service and client deliverables.

alliantgroup (www.alliantgroup.com) is an independent national specialty tax services firm that delivers government sponsored tax incentives (federal and state) to the middle-market. alliantgroup's national office is in Houston, Texas with regional offices in Orange County (CA), Chicago, New York, Miami, Seattle, San Francisco, Atlanta, Los Angeles, Denver, San Diego, Phoenix, Washington D.C., and Boston.

alliantgroup is currently in search of a full-time employee to execute strategic projects to create competitive edge solutions combining design, data, and software engineering while providing superb customer service. The ideal candidate will have experience cleaning data, reporting and dash boarding, ETL, excellent SQL skills, performance tuning, database architecture and design and all the other random lessons learned in a long career working with data. Fantastic Azure Synapse and Azure Spark & SQL skills are preferred for this role.

Responsibilities:

• Collaborate with data scientists, product management, and web engineers to deliver value and project outcomes
• Convert prototype models and data pipelines built by data scientists for use in production.
• Work closely with the Architect and offer suggestions on Datawarehouse & pipeline designs
• Work with Application Team/IT to improve workflows in the source apps to improve quality of feeds into the warehouse
• Able to create internal reports/dashboard in SSRS/Power BI for custom monitoring of ETL pipelines/Warehouse health
• Balance long-term code health and maintainability with business needs.
• Profiling and performance tuning of production code.

Qualifications:

• Experience working on projects within the cloud ideally Azure
• Strong development background with experience in T-SQL
• 2+ Years working with Azure Synapse (formerly Azure DW) in a Production environment, using both Spark pools & SQL pools
• 2+ Years Building pipelines/ETL using Azure Data Factory in a Production environment
• 7+ years with ETL (SSIS or above preferred) using multiple sources
• Had a major role in 1+ Migrations/Conversions between one data source and another
• Ability to work across structured, semi-structured, and unstructured data, extracting information and identifying linkages across disparate data sets