Sr. Data Warehouse Developer

Position Summary:

The Senior Data Warehouse Developer designs, develops and manages solutions for storing, managing, and accessing company-wide data and analytics. This role provides primary development, support and management of the exchange, transformation, and delivery of data between internal and external business systems. To ensure business needs and technical requirements are met, the Senior DWH Developer will partner with customers and vendors to manage the flow of data. In addition, this staff member serves on the team which provides daily operational production support and on-call support on a rotating basis. As a senior level member of this team, this role is responsible for research and management of issue tickets and mentorship of less experienced developers.

Essential Duties and Responsibilities:

  • As an experienced member of the team, the Senior DWH Developer will perform the full slate of development responsibilities including considering solutions, collaborating on design, developing solutions, code review, testing, and implementation.

What you should show up ready to teach anyone on your first day:

  • In collaboration with business teams and technology colleagues, participate in solving problems through the application of advanced, innovative, and eloquent IT solutions.
  • Design and develop data transformation solutions, with expertise in ETL, data transformations, and data quality tools.
  • Ability to read and write SQL and a strong understanding of database concepts, preferably with Azure Synapse Analytics.
  • Curiosity and ability to ask appropriate probing and diagnostic questions to ensure understanding of the business needs and priorities for the project.

Within your first month, you'll:

  • Document requirements, design solutions, create technical specifications, processes, etc.
  • Conduct design reviews with technical staff and end users and lead them through solution implementations.
  • Develop and migrate code through development, test, and production for new requirements or identified issues.

Within your first year, you'll:

  • Maintain database quality, performance, and costs by identifying and resolving data conflicts, monitoring load processes, and identifying areas for improvement.
  • Work closely with business teams to gain and maintain knowledge of business subject areas and with the Manager of Data Solutions to ensure alignment. Provide technical guidance to ensure business needs are met.
  • Research, analyze, and stay current with existing and emerging IT technologies, tools, systems, features, and methodologies, with thought to the justification and practical adoption of enhanced solutions.
  • Serve as a member of the rotating on-call support team

Supervisory Responsibilities:

  • None.

Education and Experience:

  • Bachelor's degree in Information Technology or equivalent combination of education and experience.
  • Five or more years of relevant experience.
  • Experience in all facets of Azure SQL Data Warehouse or Azure Synapse Analytics database administration, including database design, tuning, optimization and security is strongly preferred.
  • Required experience with MPP databases (massively parallel processing) and their specific performance tuning, data distributions, and optimizations.
  • Required experience in programming languages (.Net, REST API, R, Python, etc.).
  • Required experience with ETL tool(s), preferably Databricks, Logic Apps, Dell Boomi, SSIS.
  • Experience in one or more of the following is preferred: Data Factory, Data Lake, Blob Storage and Data Lake Analytics
  • Experience with Data Quality tool(s), preferably 360Science.
  • Data modeling experience, particularly dimensional modeling is preferred.
  • Experience with Agile methodology is preferred.

Qualifications:

  • Excellent interpersonal, written and verbal communication skills, including ability to develop and maintain strong relationships with colleagues.
  • Knowledge of Data Warehouse concepts, architecture, and design is required.
  • Demonstrated ability to execute complex research assignments, including critical thinking, logical and comprehensive problem analysis and resolution.
  • Primary database and data transformation design and development responsibilities.

Ability to work independently and cooperatively to solve complex problems.


Category

Software Developers


Education

Bachelor's Degree


Experience

5 to 20+ years


Job type

Full time

Posted
10/02/2021
Salary Range
$68,000.00 - 95,000.00
per Year
Salary range estimated by
Location
Columbus, OH 43085, US
Apply Now