The Production Data Analyst (DA) develops database queries, scripts, tools, and methods to manage data according to client requirements, within defined technical standards, and within time constraints. Emphasis is on ETL procedures. The DA is proficient with relational database concepts and practices, is able to evaluate and write complex SQL queries, and can create and maintain common database objects such as views, stored procedures, and user-defined functions. The DA should be familiar with and able to utilize code management and/or revision control tools and follow standard software development practices. The majority of time is spent developing and refining ETL processes, writing update queries, and writing ad-hoc queries on behalf of clients and stakeholders.
Data Analyst Responsibilities
Develop and maintain ETL procedures according to client specifications and within defined technical standards.
Develop and maintain database stored procedures, user-defined functions, views, triggers and other common database objects.
Write custom and ad-hoc SQL queries and update queries.
Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions.
Interact and correspond professionally with team members, project management, clients, and other stakeholders.
Account for and accurately log time against project work.
Data Analyst Qualifications
BS Computer Science or related discipline, or equivalent industry experience.
2+ years hands-on experience with MS SQL Server, 2008 R2 or higher, as a developer or DBA.
Strong SQL skills, able to create and to evaluate complex SQL statements involving numerous tables and complex relationships.
Ability to work in an environment with deadlines and shifting priorities.
Basic understanding of and experience with query performance tuning.
Experience developing and maintaining ETL procedures.
Experience with SSIS preferred.
Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluency in English.
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
Not Ready to Apply?