Data Engineer

 

Advantage Tech is looking for a Data Engineer for a growing client of ours.

II. Summary                                                                                                               

The client is seeking a Data Engineer to join a dynamic and fast-paced development team in the Kansas City area with some telecommuting available. The client is a first-class data technology company and offers outstanding benefits and competitive salaries. They have the experience, market-leading position, and financial strength of a 90-year-old company with the attitude and environment of a startup!

This is a senior-level position requiring a minimum of five years of experience. The client is quick to adopt new and emerging information technologies to solve real-world business problems. Candidate must be a fast starter, excellent communicator, accept technical direction, work with minimal oversight and, most importantly – feel comfortable working in a small group environment where contributions to the team are critical to the overall success of the project.

 

III. KEY RESPONSIBILITIES                                                    

  • Work with a diverse and innovative team to provide support on research data management, quality control, and analysis.
  • Integrate data from multiple sources to produce requested or required data elements.
  • Work with internal teams to establish ETL and data cleansing processes.
  • Develop and enhance ETLs across various database products, product development research & testing, to drive improved client services, rapid, effective ingestion of data, and business growth.  Help refractor data models as needs and direction change.
  • Work with IT application staff to define source-to-target mappings. Facilitate collection and documentation of the source-to-target transformation and business rules.
  • Identify and define data quality improvements.
  • Assist with database management in the full SDLC for new and existing products. Serve as a database subject matter expert and partner with developers on performance tuning and best practices, assessing new cloud-based data opportunities as they evolve and become available
  • Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis.
  • Plan data migration and conversion strategies.
  • Wrestle with problems associated with database integration and messy, unstructured data sets. The goal is to provide clean, usable data to whomever may require it.
  • Optimize batch processing and efficient loads from daily data collection.
  • Design and develop schema and ETL procedures in service of new data warehouse, designed to service traditional BI scenarios, operational reporting, and data science endeavors.
  • Perform other duties as requested.

 

IV. QUALIFICATIONS AND SKILLS

  • Bachelor’s or master’s degree in Mathematics, Computer Engineering, or related technical field.
  • Advanced T-SQL development experience – ability to write, troubleshoot, and design (stored procs, functions, tables, views, triggers, indexes, constraints) with demonstrated ability to write complex SQL to query OLTP and OLAP databases.
  • Performance tuning, query optimization, using Performance Monitor, DMVs, and reading execution plans.
  • Data Modeling including management of both structured and unstructured data sets — must be versed in different approaches to data architecture and applications including traditional data warehousing concepts and data lakes.
  • Experience with data reconciliation and migration between data environments (e.g. dev, test, staging, prod, etc.).
  • Experience with SQL Server Integration Servers (SSIS) required, experience with Azure Data Factory a plus
  • Experience with traditional data warehouse schema design (star/snowflake schema, dimensional modeling, etc.).
  • Knowledge of software applications such as Word, Excel, etc.
  • Ability to write clean, readable, and easily maintainable code and documentation.
  • Experience with code versioning tools, such as Git a plus.
  • Knowledge of data architecture, data staging, and ETL/ELT concepts and tools.
  • Experience with Data Visualization tools such as Tableau or Power BI.
  • Strong business acumen with an aptitude to learn the business.
  • R and/or Python for statistical modeling a plus.
  • Effective interpersonal, verbal, and written communication skills.
  • Demonstrated success in a team-oriented work environment with a balance of collaboration and individual contribution.
  • Innately curious, strong critical thinker and a growth mindset.
  • Strong attention to detail, problem-solving skills and ability to work in a fast-paced environment.
  • Ability to manage multiple tasks/projects and deadlines simultaneously with limited supervision.

 

 

Submit Resume