The Senior Production Data Analyst (Senior DA) is a SQL and ETL expert, able to quickly and accurately develop complex database queries, scripts, tools, and methods to manage data according to client requirements. The Senior DA has a thorough understanding of and experience with relational databases, SQL programming, complex ETL, complex data structures, SDLC and related tools and practices, and is able to design and develop complete, effective solutions. May design and document solutions which other analysts code and implement. Serves as a knowledgeable resource and mentor to less experienced analysts. The Senior DA participates in developing and documenting technical standards, guidelines, templates, patterns - best practices - and reviews designs and code for compliance. You will work as part of a dedicated team, supporting both internal and external stake-holders in their quest for information and answers to their business questions. Your success comes from your focus on quality, accuracy and timeliness of your deliverables, as well as your ability to be a team player.
Senior Data Analyst Responsibilities
Design, build, and maintain complex ETL procedures and solutions according to client requirements.
Participate in definition and application of departmental best practices - technical standards, processes, templates, patterns, SDLC, etc.
Create and maintain technical and system documentation.
Provide technical guidance and mentorship to less experienced analysts.
Troubleshoot and solve database performance issues, programs returning incorrect or unexpected results, difficult design or programming problems.
Conduct design reviews and code reviews to ensure departmental standards are maintained and enforced.
Interact and correspond professionally with team members, project management, clients, and other stakeholders.
Account for and accurately log time against project work.
Senior Data Analyst Qualifications
BS Computer Science or related discipline, or equivalent industry experience.
5+ years hands-on experience as developer with MS SQL Server, 2012 or higher.
4+ years SSIS or other ETL tool experience developing and supporting complex ETL procedures.
Expert understanding of relational database concepts, tools, performance, techniques, industry standards and best practices.
Strong design and coding skills; demonstrated ability to develop and support complex, mission-critical database systems.
Experience evaluating and improving database performance.
Strong problem-solving and analysis skills.
Ability to work in an environment with deadlines and shifting priorities.
Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluency in English.
Prefer broad knowledge of or background in software development and data tools, such as: .Net, object oriented programming languages, SSRS, SSAS, BI, data warehousing, data visualization tools, etc.
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?