Job Description :
The incumbent should have a strong focus on defining data solutions, data management, and analytic environments that will enable more efficient and effective decision making. Partner with stakeholders to support strategic services including feasibility studies, data modeling, project estimation and data governance. Design and drive Extract Transformation and Load (ETL) solutions on multi-terabyte databases, data warehouse, data mart(s), lead ETL development, system integration design, application design, interoperability, process integrity across multiple platforms and resolving technical issues. Need to be well-versed in architectural and modeling principles that support data management.
Job Requirements:
? BS/MS in Computer Science, Engineering, Statistics, Mathematics, or related
? Minimum 8 years of progressively responsible work experience in data architecture
? Minimum 5 years of experience in working as Solution/Data Architect
? Minimum 5 years of experience with ETL design and development using Talend, Informatica or equivalent tools
? Minimum 5 years of experience with data warehouse/mart development using an IBM Netezza/Sailfish/DB2 appliance
? Minimum 5 years of experience with SQL/PL SQL, SQL query optimization.
? Experience with Data Modelling/Database Design (from conceptualization to database optimization) to support marketing databases and marketing automation capabilities (preferably IBM Campaign)
? Proficient in Data Warehouse like Star schemas, snow flake , dimensions, facts, OLTP, OLAP concepts
? Familiarity with XML/JSON schemas
? Understanding of established and emerging data technologies such as columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data
? Experience in Erwin or other Modelling tools
? Experience in creating technical design and implementing MDM/ETL solutions
? Experience and willingness to mentor and coach technical team members
? Proficient verbal and written communication skills.
? Experience working in an agile methodology
Preferred:
? Health Insurance subject area model experience
? Big Data Experience. Hadoop, Hive, Linux
IBM Solution Architect:
? Minimum 10 years of consulting/practitioner experience with marketing automation and data solutions
? Minimum 7 years of experience with IBM marketing automation solutions; specifically IBM Campaign and Interact
? Minimum 5 years of experience working with data models to support marketing solution
? Minimum 10 years of project management experience
? Strong working experience architecting marketing automation solutions
? Ability to work with multiple teams to gather requirement, confirm design and build solution to meet needs
? Ability and experience playing multiple roles to support project
? Experience operationalizing solution and ensuring transition to business is successful
? Ability to talk with all levels of the organization
? Ability to provide direction and guidance as needed
Can you please confirm the work location Would prefer Minneapolis, but would consider remote employees based in the US.
I assume this will be an in person interview Would prefer in person.
Hours: Business Hours