**Required skills ** Bachelor’s degree 15-20 years developing analytics information architectures and supporting modern visualizations and or modeling capabilities 5-10 year of audit compliance as it pertains to information and application development 10-15 year of deployment management as it pertains to information and application development ETL Development Expert knowledge of relational databases (preferably SQL Server) Expertise in using data quality and profiling tools Knowledge of dimensio
About the role
**Required skills **
Bachelor’s degree
15-20 years developing analytics information architectures and supporting modern visualizations and or modeling capabilities
5-10 year of audit compliance as it pertains to information and application development
10-15 year of deployment management as it pertains to information and application development
ETL Development
Expert knowledge of relational databases (preferably SQL Server)
Expertise in using data quality and profiling tools
Knowledge of dimensional data architecture concepts.
Working knowledge of AWS infrastructure and products such as RedShift, Matillion
Working knowledge of MongoDB
Excellent team player with strong verbal and written communication skills
Must be able to work with internal and external clients in understanding their strategic needs and communicate in a business acumen
BS degree in Computer Science or proven relevant experience
Strong motivation to learn and grow
Experience with tools such as Tableau, Spotfire or SAS and imbedding applets into the above frame work and ETL development
Knowledge of relational databases (preferably SQLServer), Big/Unstructured Data model design
Excellent problem solving skills
Manages and makes recommendations shifting priorities, demands and timelines through analytical and problem-solving capabilities.
Ability to elicit cooperation from a wide variety of sources, including upper management, clients, and other departments.
Strong written, interpersonal, and oral communication skills.
Adept at conducting research into project-related issues and products.
**Responsibilities **
Integration of strategic, digital, unstructured and social intelligence information
Understanding of Audit requirements and best practice
Understanding of deployment best practices
Information architecture design and development within an AWS Redshift environment
Contribute to the development of CMI Compas overall information architecture
Identify, analyze and architect CMI/Compas strategic data sets
Develop process requirements and implement data loading/update processes
Develop requirement and implement validation, QC and data governance processes
Develop and follow standards and guidelines for all ETL design and development. This includes workflow architecture, naming conventions for source and targets, maps, sessions and parameters.
Develop and follow standards and guidelines for all audit compliance across design and development. This includes workflow, architecture, naming conventions for source and targets, maps, sessions and parameters.
Develop and follow standards and guidelines for all deployment compliance across design and development. This includes workflow, architecture, naming conventions for source and targets, maps, sessions and parameters.
Maintain our databases both from ETL perspective and DBA
Follow developments in open source and research for ideas to borrow and contribute.
Take an active role in making CMI/Compas a better place by helping to hire great engineers, collaborating, leading, mentoring, and most importantly getting things done.
Lead product development and delivery of information based applications based product
Make recommendations and update senior management with respect to product development approach, methodology, technology, changes, enhancements and overall vision for technology direction.
Lead detailed design, prototype, coding, testing, deployment, maintenance
Collaborate with product development team to deliver a compelling platform and product.
Take an active role in making CMI/Compas a better place by collaborating, leading, mentoring, and delivering projects per investment strategy.
Ensure requirements are complete and adhere to PMO best practices
Ensure that project management, investment management and communication plans are in place to support product development and delivery.
Provide guidance and adapt PMO best practices to projects including long term initiatives, short term capability enhancements and individual project requests.
Direct and oversee product development and delivery from beginning to end, ensuring proper project management and execution and ensuring risk management throughout.
Monitor and react to changes in product development timelines, milestones, action plans, deliverables and deadlines using appropriate tools that support business goals in collaboration with senior management and stakeholders.
Analyze and make recommendations to Information Architecture in support of GUI/Analytics
Research and make recommendations for application architecture improvements specifically in the area of modern dynamic analytics visualization
Influence discussions with product stakeholders on an ongoing basis.
Ensure the realistic setting of priorities in consideration of development capacity and ROI.
Proactively adjust development resources as necessary to ensure meeting business priorities.
Monitor development and delivery team members and contractors progress, and discuss positive action and accountability for their assigned work.
**About the Project **
A full-service media agency focused solely on health, wellness, and pharmaceutical marketing, offering Audience Strategy, Planning, Development, and Insights; Data and Analytics; Buying and Investment; and Direct Response and Customer Experience.