A Business Analyst III job in Bothell, WA is available courtesy of Adecco Engineering and Technical.
•This role will be responsible for designing, building and maintaining databases for a fast paced reporting team. They will have the ability to work with large and complex volume data sets and must have a clear understanding of the full database systems. This position demands both business analysis and reporting expertise with ownership of the business need for data quality assurance processes required to support critical business intelligence initiatives.
8+ years of experience in SQL programming in T-SQL building stored procedures and jobs
5+ years data integration and ETL experience with SQL Server Integration Services (SSIS) or other industry leading tools including ability to configure SQL Server agent
5+ years of experience in designing and developing ETL processes including naming conventions, connection to variety of systems and processing of large volume of data
5+ years of experience in identifying and mapping data elements across multiple systems including creating templates and best practices to maintain the mapping information
Strong understanding of data integration, quality and validation
Experience with SQL Reporting Services (SSRS) and Reporting tools (Excel, PowerPivot)
4+ years of experience extracting data from Salesforce.com database objects using API calls via SSIS, DataLoader, and other ETL tools; familiarity with SOQL (Salesforce SQL)
Understanding of MDM, Data warehouse / Data mart
Experience with SQL Server in a VMWARE or AWS environment
Experience moving data across different types of databases
Excellent performance tuning and TSQL skills
SQL Automation experience
Good with Data Warehousing Concepts
2-3 years of Tableau experience
Excellent written and verbal communication skills and be able to interact with multiple IT teams and business partners both formally and informally
Clear understanding and experience with Microsoft platforms, including Windows operating systems for both desktop and server.
Knowledge of physical database administration with SQL Server a plus
Experience in logical and physical data modeling
If you are interested in this Business Analyst job in Bothell, WA then please click APPLY NOW. For other opportunities available at Adecco Engineering and Technical go to www.adeccousa.com.
Equal Opportunity Employer Minorities/Women/Veterans/Disabled
A little about us:
We partner with people to improve skills, teams and lives every day, and we help them achieve more than they ever thought possible.