SQL/DB Dev - Apex Systems

Job#: 2057453

Job Description:

This role is responsible for leading efforts to develop and deliver complex data solutions to accomplish technology and business goals. Key responsibilities include code design and delivery tasks associated with the integration, cleaning, transformation, and control of data in operational and analytics data systems. They guide stakeholders, Product Owners, and Software Engineers through the design and execution processes. Provide technical thought leadership based on the significant experience they have built through implementing multiple complex data solutions, and their knowledge of the interaction across multiple data flows and systems. 
Location: Chicago, Atlanta, Richmond, Charlotte
Duration: 24 months
Rate: $65hr+ on direct w2
We are unable to work c2c or provide sponsorship now or in the future. All candidates must be able to work on Apex Systems direct w2. 
Candidates are expected to sit 3 days on site, non negotiable. 
 
Key Responsibilities:
Ensure that the design and engineering approach for complex data solutions is consistent across multiple flows and systems.
Collaborate amongst team members to assist with knowledge gaps and or provide instructional training when needed.
Assist other work groups in application development using python or writing advanced SQL queries when deemed necessary.
Conduct research, designs prototyping and other exploration activities such as evaluating new toolsets.
Utilize multiple architectural components in design and development of client requirements.
Maintain, improve, clean and manipulate data for the operational and/or analytics data systems.
Constantly looking for better ways of solving technical problems and designing the solution without being afraid of challenging the status quo.
Collaborate with development teams to understand data requirements and ensure the data architecture is feasible to implement and subsequently implemented accurately.
Assemble large, complex data sets that meet functional/ nonfunctional requirements.
Build processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management.
Define and build data pipelines that enable faster, better, data informed decision making within the business.
Contribute to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause.
Document and communicate required information for deployment, maintenance, support, and business functionality.
Adhere to team delivery/release process and cadence pertaining to code deployment and release
Identify gaps in data management standards adherence and work with appropriate partners to develop plans to close gaps.
Lead concept and experimentation testing and synthesize the results to validate and improve analytical solution.
Strong experience using a variety of data mining/data analysis methods, using a variety of data tools, building and implementing models, using/creating algorithms and creating/running simulations.
Operational support monitoring and maintaining daily ETL jobs (Autosys/SQL Agent)
 
Qualifications:
Strong problem solving skills with an emphasis on product development.
Experience using statistical computer languages (Python, SQL, hive, etc.) to manipulate data and draw insights from large data sets.
Experience working with and creating data architectures.
Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests and proper usage, etc.) and experience with applications.
Excellent written and verbal communication skills for coordinating across teams.
Experience with distributed data/computing tools: Hadoop, Hive, MySQL, etc.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.