ATCC Business System Analyst – Data Warehouse & Business Intelligence in Manassas, Virginia
Founded in 1925, ATCC is a non-profit organization with a mission to acquire, authenticate, preserve, develop, standardize, and distribute biological materials and information for the advancement and application of scientific knowledge.
The Business System Analyst – DW & BI will be responsible for interacting with business stake holders and collecting requirements to support their operational, tactical and strategic reporting as well as other analytical business needs. He should be able to process and analyze information stored in the data warehouse. Their job duties include designing and managing the data warehouse, troubleshooting issues as they arise. The resource should be able to work with developers and guide them in completing business requirements. He should also analyze and evaluate data to make recommendations to management about ways to improve data storage, reporting, and other business issues.
This position must work and think independently; duties of this position are to be completed under minimal guidance. Discretion in handling assigned responsibilities, including the ability to resolve problems and exercise good judgment while maintaining confidentiality. Functions are to be completed in a timely manner with acceptable quality.
Ability to interact with business stake holders and gather requirements.
Design and execute an innovative reporting system for processes.
Monitor efficient transition of business requirements to technical specifications.
Ability to translate business requirements correctly into technical specifications. Should be able to write ETL and report requirements.
Design, build & test, ETL processes (using SQL Server Integration Services packages) to move and transform data based on defined data architectures Participate in the definition of best practices, standards and optimization techniques to enhance the DWH/BI solution.
Design and implement various reports and prepare dashboards.
Ability to work with developers in explaining requirements and should also test there code before implementing in production.
Monitor compatibility of all data delivery tools and warehouse and ensure effective resolution for same.
Evaluate all training programs for end users and provide support for same.
Provide technical support in database implementation and deployment.
Analyze and recommend improvements to processes.
Participate in various project meetings and prepare applications for database.
Education and Experience:
Bachelor's degree or equivalent experience and a minimum of five (3) years’ experience in the data warehouse and business intelligence.
Minimum of three (3) years working with SQL Server Data warehouse.
Knowledge, Skills and Abilities:
Working knowledge of SSIS, SSRS, SSAS and Power BI.
Ability to design, develop & test ETL and reports.
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Proficient in SQL and ability to analyze data.
Self-starter, motivated and takes initiative; strong interpersonal and problem-solving skills; able to work collaboratively with all levels of staff to resolve problems to maximize performance, creativity, problem solving and results.
Excellent written and verbal communication skills, including excellent listening skills to communicate clearly, concisely and effectively.
Seek, learn, and apply new skills/knowledge to perform job responsibilities.
Attentive to detail with a high level of accuracy; exercise sound judgment.
Resourceful, diplomatic and professional; deliver outstanding customer service while managing relationships; a can-do attitude and work style that supports teamwork, collaboration and positive relationships.
Adaptable; be able to shift priorities and focus as departmental and/or business demands change (including, but not limited to early/late hours and/or weekend hours).
Strong analytical skills and organized; completes tasks ahead of schedule.
Position-relevant computer experience including Microsoft Office.
Follow all company safety practices, Standard Operating Procedures (SOP’s) and policies.
Knowledge of Dynamics AX and CRM is a plus.
Experience working with or for Federal Contractors.
Experience in manufacturing.
ATCC is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.