Previous Job
Previous
Data Engineer
Ref No.: 17-06143
Location: Coppell, Texas
Position Type:Direct Placement
Start Date: 07/10/2017
My client in Coppell, TX is looking for a Data Engineer to join their growing team for a 6 Month Contract-to-hire.

Title: Data Engineer
Location: Coppell, TX
Type: 6 Month Contract-to-hire
Rate: DOE

Responsibilities
  • Create end-to-end analytics and reporting solutions.
  • Create data integration and technical solutions around Microsoft SQL Server, Azure Data Lake and Azure Data Warehouse.
  • Develop ETL processes using SQL, SSIS, Azure Data Factory with consideration to fault-tolerance, error logging, auditing and data quality.
  • Write sophisticated SQL queries to extract data and build complex models (Excel/R/etc.)
  • Build/automate reports/dashboards (in Power BI and Microsoft Analysis Services) that allow the business leaders to get a clear snapshot of their operations
  • Design and analyze A/B tests to quantify impact of customer-facing changes
  • Perform complicated analyses to extract learnings and drive insights
  • Perform technical walk-through as needed to communicate design/coded solution and to seek input from team lead and members
  • Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for landing data successfully into the appropriate destinations
  • Data Modeling and Requirements Analysis
  • Prepare storage logical and physical models based on requirements
  • Work closely with Data Science team to provide datasets necessary for experiments and creating machine learning models
  • Understand, articulate and present business requirements into technical solutions
  • Analyze and profile current data to ensure no requirements are missed
  • Work with quality assurance team to build test plans to validate that new systems meet business requirements
Requirements
  • Experience in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Azure Data Lake, Azure Data Lake Analytics, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc.)
  • SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Data Quality Services
  • Strong Data Modeling skills to include data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high volume data loads
  • Excellent communication skills
  • Experience working in an agile team environment. Understanding of code promotion, code turnover to operations, version control, and QA procedures. Conduct code walkthroughs, peer reviews, and produce technical documentation
Desired Experience
  • Background in FP&A and Accounting
  • Sr. level understanding of warehousing architectures including ETL design, staging, transformations, delta/change data capture, star-schemas, cubes, and history loading
  • Experience leveraging ETL frameworks to develop scalable solutions using SSIS. Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions;
  • Understand database platform layouts and configurations
  • Understand reusability, parameterization and workflow design
  • Ability to efficiently balance multiple projects in a rapidly changing environment
  • Experience in a professional services environment with exposure to senior functional leaders