Preferred start date: As soon as possible
Duration: 3 * 4 months
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, AWS and Azure * big data* technologies.
Identifying data quality issues and supporting data governance initiatives by participating in necessary activities including data profiling, data mining, and clean up
Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
3+ years of experience in applied data warehousing methodology, analysis, and development
3+ years of experience developing ETL packages including scheduling and automation
3+ years of SQL coding and tuning experience
3+ years of SQL Server SSIS/SSAS/SSRS development experience
Solid experience transforming business
requirements to technical solutions Strong conceptual, analytical, and problem-solving skills
Dimensional Modeling Experience
Proven ability to communicate effectively with both technical and non-technical staff
Proven experience with both Multi-Dimensional and Tabular Analysis Services development
Understanding of and experience in ETL performance tuning
Positive attitude and initiative
Education Preferred: Bachelor* s Degree in Computer Science, Information Systems, Math or another related field
Education Required: High School Diploma
Preferred Skills (not required):
Experience with data transformation from SQL to AWS.
Experience uploading JSON and other flat files to Amazon S3 buckets.
Experience supporting and working with cross-functional teams in a dynamic environment
Experience with Azure common services used in development.
Working knowledge of data platforms such as Redshift, Glue, Matillion, Snowflake, Tableau, Alteryx, Power BI
Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
Solid understanding of SDLC and experience using Source Control systems
Will they contractor be expected/allowed to work from home? Yes allowed.
Will there be remote work (at a non-Koch site)? No
Please include a detailed description of the contractor* s work schedule:
Will the role include:
Monday - Friday ( 8 AM * 5 PM CDT )
Travel - No
2nd or 3rd Shift Work - No 3rd shift, sometimes after 5 PM
On Call Duties - No
Additional Details: This work is for the Shared Reporting project connected with MyHR project
Nitin Raj | Senior Resource Co-ordinator | Veritis Group, Inc.
1231 Greenway Drive, Suite 1040, Irving, TX 75038
Email address : | | A Certified MBE
VMware Professional Partner | Oracle Gold Partner - provided by Dice SQL Server SSIS/SSAS/SSRS, Redshift, Glue, Matillion, Snowflake, Tableau, Alteryx, Power BI, scripting languages: Python, Java, C++, Scala, etc.