Enterprise Data Warehouse Solutions Architect Location: Kennesaw, GA - Hybrid Remote: 2 days onsite, 3 days remote Hiring Terms: Direct Hire Salary: $130,000 - $140,000 + 5% bonus + equity + benefits + unlimited PTO
Vaco is working with a biotechnology research organization seeking to hire for a EDW Solutions Architect to design and architect SSIS ETL solution including SQL Server development, T-SQL, and gather requirements for functional specifications for BI reporting. Great opportunity to work with a growing organization who offers 5% bonus, equity, and unlimited PTO on hybrid remote work setup!
Gather functional requirements to create specifications for ETL solution, enterprise data warehouse, and reporting.
Create data storage solution for housing data analytics reporting to support data driven insights.
Analyze data structure and data sources to understand proper data profiling and mining techniques.
Optimize ETL workflow with scheduled SSIS packages.
Setup ETL logging and monitoring including factoring necessary information to include in logs.
Factor data governance, data security, and privacy in your ETL solution design.
Provide backup DBA responsibilities including replication, backups, indexing, and SQL monitoring.
Wriite SSIS packages for automation data integration.
Interact with various data sources such as SQL Server, Oracle, Teradata, MS Excel, MS Access, and flat files.
3+ years of SSIS ETL development.
Skills: SSIS, SQL Server, T-SQL, data modeling, Qlik
B.S degree in IT, Computer Science, MIS, Data Science, Mathematics, or Statistics.
Help us improve CareerBuilder by providing feedback about this job:
Job ID: ENTER68593
privacy and protection,
when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn more.
By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder
Terms and Conditions
for use of our website. To use our website, you must agree with the
Terms and Conditions
and both meet and comply with their provisions.