CE Strategy is a rapidly growing business intelligence firm recently named by Adweek Magazine as the 87th fastest-growing agency in the world, based in Rochester, New York. Established in 2015, CE Strategy has evolved into a business intelligence firm that leverages data science to develop strategies that achieve client goals for increasing top-line revenue and decreasing bottom-line costs. We do this by focusing on four core services: the aggregation and visualization of data, insight through data science, development of business strategy, and continuous optimization.

Position Summary

The Data Architect position is a member of the CE Strategy BI & analytics team and, as such, plays an important role in maintaining and growing existing client relationships. This role is both strategic and operational in nature, and an ideal candidate will possess the following:

  • A solid foundation in systems development:

    • The candidate should understand the system development life cycle; software project management approaches; requirements, design, and test techniques.
  • Depth in data modeling and database design:

    • As a core skill for this position, an ideal candidate is sound across all phases of data modeling, from conceptualization to database optimization.
    • The required skills also extend into SQL development and perhaps database administration.
  • Breadth in established and emerging data technologies:

    • An ideal candidate is either experienced or conversant in emerging tools like columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data.
      • While not necessarily deep in these technologies, the candidate is experienced in one or more, and understands them sufficiently enough to guide clients in understanding and adopting them.
  • The ability to conceptualize, understand, and articulate the big data picture:

    • This position initiates, evaluates, and influences projects from the perspective of the entire organization.
    • While mapping systems and interfaces used to manage data, sets standards for data management, analyzes current state and conceives future state, and owns/executes projects needed to close the gap between current state and future goals.

This position reports directly to the Director of Analytics & BI and indirectly to the V.P. of Client Service and has potential for advancement within the organization.

Primary Responsibilities:

  • Evaluate current data systems

    • This position is responsible for evaluating the current state of a client’s databases and other data systems. They will analyze these databases and identify new solutions to increase efficiency and performance.
  • Define database structures

    • Define the overall database structure, including recovery, security, backup, and capability specifications. This definition provides a way for data architects to determine overall requirements for database structure.
  • Propose solutions

    • After analyzing, evaluating, and defining current database structures, data architects create and propose solutions to upper management and stakeholders. This often includes designing a new database and presenting it to interested parties.
  • Implement database solutions

    • Responsibilities include implementing the database solutions that are proposed as part of the larger project. This entire process includes developing process flows, coordinating with data engineers and analysts, and documenting the installation process.
  • Train new users

    • As an expert in the new database solutions they design and implement, train new data analysts, engineers, or other client stakeholders.

Technical Skills Required:

  • Application server software (e.g., Oracle)

  • Database management system software (e.g., Microsoft SQL Server)

  • User interface and query software (e.g., IBM DB2)

  • Enterprise application integration software (e.g., XML)

  • Backup/archival software

  • Agile methodologies and ERP implementation

  • Knowledge of predictive modeling, NLP and text analysis

  • Data modeling (e.g., erwin DM, Enterprise Architect, Visio, and others)

  • Data mining

  • UML

  • ETL Tools

  • Python, C/C++ Java, Perl

  • UNIX, Linux, Solaris, and MS Windows

  • Hadoop and NoSQL databases

  • Knowledge of data visualization tools 

Familiar Tools

  • Data visualizationTableau, Power BI, Sisense, Looker, and others

  • Database management Microsoft SQL Server, phpMyAdmin

  • Data modeling Oracle SQL Developer, Database Workbench, ER/Studio

Experience, Education, and Essentials for Success

Experience

  • 3-5 years in a similar role

  • The ideal candidate has experience consulting with multiple clients across several verticals and lines of business

Education

  • Bachelor’s degree in related discipline (including data science, data engineering, MIS, analytics, or others) and master’s degree preferred

Essentials for Success

  • Well respected and influential

  • Able to emphasize methodology, modeling, and governance

  • Technologically neutral and diplomatic in nature

  • Enthusiastic, articulate, and persuasive

  • Interest and ability to thrive in a “startup” atmosphere

  • Excellent time management skills; ability to manage multiple details and deadlines in a multitasked environment; good oral and written presentation skills

  • A highly motivated self-starter

  • A strong commitment to the Customer Experience

  • Entrepreneurial spirit challenged by the mission to help to grow a company

  • Superior professional presence and business acumen

  • Embraces a team and collaborative atmosphere

  • “Whatever it takes” approach to solving complex business scenarios

All employees benefit from a highly competitive compensation and benefit structure. Interested applicants should forward a resume and cover letter to employment@causeandeffectstrategy.com for immediate consideration. Qualified applicants will be contacted to schedule interviews.

CAUSE + EFFECT Strategy provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, CAUSE + EFFECT Strategy complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Ready For Your New Job?