Sr SQL Dev

Job Summary:

Dexian is seeking a Sr SQL Dev for an opportunity with a client located in Charlotte, NC.

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

Requirements:

• 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)
• 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

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals.To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.