Mid-Level Data Engineer

Job Title: Mid-level Data Engineer
Visa: USC,GC
Location - 100% remote position - company located in Madison,WI Preferably East or West coast .
Client: Exact Science.
Estimated Duration: 6 month with potential to go long term or permanent
Rate Range - $60-65/hr. /c2c
Years of Experience: 6+ YEARS
Interview: Phone and Teams
Skill Matrix:
Tech
Year of Experience
Databricks(required)
Python(required)
Snowflake
AWS(required)
SQL(required) (***expert level**)
Epic Clariy (required)
Epic Caboodle (required)
Epic Cogito (required)
Required:
The primary tech skills we're looking for are Databricks, Python, Snowflake, AWS/cloud infrastructure services, and experience building data integrations/ETL's and analytic data structures.
Solid SQL experience is absolutely required for all Data Engineering levels.
Epic Cogito/Clarity/Caboodle experience is required.
Candidates must have at least 8yrs of each for Sr. Data Engineer:

• Databricks (required)
• Python (required)
• Snowflake (not required)
• AWS/Cloud ETL's- building data integrations/ETL's and analytic data structures (required)
• SQL (***must be expert level**)
• Epic Cognito/Clarity/Caboodle (required)

Job Description:
The Sr. Data Engineer provides technical expertise, enables data analysis, and is an expert of the data generated by business systems. This role will contribute to meaningful, effective, and performant data visualizations and reports, and analyze, troubleshoot, and tune performance.
Essential Duties
Include, but are not limited to, the following:
• Provide expertise in data management for the purpose of analysis, reporting, and visualization.
• Partner with analysts and other data stakeholders to design and develop complex solutions.
• Develop and automate data pipelines.
• Clean and prep data.
• Improve monitoring, automated testing, and deployments.
• Be a resource for providing insight, recommendations, and assistance with technical and non-technical questions.
• Monitor and recommend enhancements to the technical architecture to keep pace with changing business demands and scale.
• Stay informed of technology industry trends and solutions with ability to analyze for possible application in our environment.
• Work with Information Technology management and staff to develop and maintain standards, processes, and documentation.
• Promote the role and capabilities of IT to enhance the professional development of all staff through example, recommendation, and accommodation.
• Work independently with little oversight and direction.
• Special projects as business needs require.
• bility to work in a fast-paced, cross-functional team environment.
• bility to work independently with little oversight and direction.
• daptable, open to change and able to work in ambiguous situations and respond to new information or unexpected circumstances.
• Proactive, self-starter.
• Excellent interpersonal and communication skills with the ability to operate in a cross cultural and complex matrix environment.
• bility to build consensus across functions.
• Strong analytical, problem solving, and trouble-shooting skills.
• Support and comply with the company's Quality Management System policies and procedures
• Uphold company mission and values through accountability, innovation, integrity, quality, and teamwork.
• Regular and reliable attendance.
• bility to work on a mobile device, tablet, or in front of a computer screen and/or perform typing for approximately 90% of a typical working day.
Minimum Qualifications
• Bachelor's Degree in Computer Science, Information Systems, or related field as outlined in the essential duties; or High School Diploma/General Education Degree and 4 years of relevant experience as outlined in the essential duties in lieu of Bachelor's Degree.
• 8+ years of experience in data and/or software engineering or related field as outlined in the essential duties.
• Demonstrated expert experience querying disparate data sources, including relational structures, OLTP systems, and dimensional data models.
• Demonstrated expert experience working with SQL for data exploration, debugging, and performant data access.
• Demonstrated expert experience designing and developing reports, dashboards, and visualizations, preferably including with Tableau.
• bility to translate business requirements to technical specifications.
• Proven ability to work in a fast-paced, cross-functional team environment.
• daptable, open to change and able to work in ambiguous situations and respond to new information or unexpected circumstances.
• Excellent interpersonal and communication skills, ability to operate in a cross cultural and complex matrix environment, and ability to build consensus across functions.
• Demonstrated ability to work within an Agile development environment and strong understanding of the Agile framework.
• Proficient in Microsoft Office applications to include Word, Excel, PowerPoint, and Visio.
• Demonstrated ability to perform the essential duties of the position with or without accommodation.
Preferred Qualifications

• Experience with Tableau, ideally including performance optimize

• Experience with Databricks and Apache Spark
• Experience with Snowflake or other cloud database systems.
• Experience with Python development.
• Experience working in life sciences, biotechnology, or related industry.
• Experience with or knowledge of Cloud Infrastructure services (i.e., AWS, SQS, S3, and GitLab).
• Experience using Agile development tools; including, but not limited to, JIRA and Confluence.
• Experience with RestAPI development.
• Experience working with CRM systems.
• Experience as an Epic BI Developer (BID); Epic Cogito, Clarity Data Model experience.
• Experience developing dashboards and reports on data from sales, call center, and custom software applications.