Maxsys Solutions is currently searching for a Senior ETL Developer to join a global and well-recognized company in Dallas, TX for a 3 month contract to hire opportunity! Our client is well recognized for their products, dynamic work environment and proven leadership within the retail/furniture space!  They need to hire an ETL Developer responsible for creating data integration and technical solutions around Microsoft SQL Server, Azure Data Lake and Azure Data Warehouse.  You will be developing ETL processes using SQL, SSIS, Azure Data Factory as well as writing sophisticated SQL queries to extract data and build complex models (Excel/R/etc.). 

Technical Requirements:

· Build and automate reports/dashboards in Power BI and Microsoft Analysis Services

· Work closely with the Data Science team to provide datasets necessary for experiments and creating machine learning models

  • Work closely with QA team to build test plans to validate that new systems are meeting business requirements

· Perform technical walk-throughs when needed to communicate design/coded solutions

· Design and analyze A/B tests to quantify impact of customer-facing changes

· Perform complicated analyses to extract learnings and drive insights

· Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for landing data successfully into the appropriate destinations

· Prepare storage logical and physical models (based on requirements)

· Conduct code walkthroughs, peer reviews and produce technical documentation

· Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions


Other Requirements:

· Bachelor’s degree in Computer Science/MIS or related field preferred

· 5 years’ experience with SSIS, SSRS, SSAS and SQL Server Data Quality Services

· Experience 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 and Stream Analytics)

· Prior experience with data modeling and requirements analysis

· Must possess a senior level understanding of warehousing architectures (includes ETL design, staging, transformations, delta/change data capture, star-schemas, cubes and history loading)

· Background in FP&A and Accounting

· Must possess strong leadership/mentoring skills

· Excellent communication and conceptual skills required


No 3rd party vendors or agencies at this time.  All applicants applying for U.S. job openings must be authorized to work in the United States.  Relocation assistance is not provided.  You may apply for this position online or by sending an email to Krista@maxsyssolutions.comMaxsys Solutions is committed to being an equal employment employer offering opportunities to all job seekers.