Sign upLog in
IT Architect Jobs in San Francisco, CA

Data Architect (Remote)

Francisco Partners
  • San Francisco, California
  • Remote
    30+ days ago

    Job Description

    First San Francisco Partners is a business advisory and enterprise information management (EIM) consultancy dedicated to helping companies leverage their data to improve strategic decision-making, reduce risk, create operational efficiencies and fuel unprecedented business success. Our services span data governance, data quality strategies, data management architecture, master data management strategy and implementation, analytics and big data. 

    Job Responsibilities and Duties 

    We have an immediate opening for a Data Architect to who will have a hands-on role with responsibility to develop data architecture and modeling strategies, design, implement and support data architecture deliverables for multiple data integration, data management, data warehousing, business intelligence and analytics projects. They will also be able to deliver solid, extensible, highly-available data models and data environments that supports the current and future business and technical requirements.
    • Develops and maintains architectures for the high-level data environments of the enterprise, at the reference, conceptual, and logical levels, ensuring that these align to overall business strategy
    • Ensures that database and data storage technologies support the data management needs of the enterprise
    • Develops, communicates, supports, and monitors compliance with Data Modeling standards
    • Evaluates proposals for development projects to ensure they adhere to all data architecture standards
    • Develops and maintains standard patterns for data layers, data stores, and utility data management processes (e.g. data movement, data integration) for application across the enterprise
    • Assists development projects, either directly or indirectly by liaising with a solution architect, to ensure that good data architecture is implemented in these projects.
    • Evaluates currently implemented systems to determine their viability in terms of data architecture
    • Participates in the oversight of setting data standards, for reference data, data formats, and similar needs.
    • Identifies standard metadata for describing data assets.
    • Develops standards for the semantic needs of data, including different kinds of models (e.g. subject areas models, data classification schemes, standards for ontologies).
    • Ensures all documentation for data architecture is of high quality and properly curated


    Skills and Qualifications:
    • Excellent communication skills, presentation and interpersonal skills are required.
    • Ability to communicate clearly with both business and technical resources.
    • A demonstrated track record of making a difference and adding value
    • Strong organizational skills. Able to multi-task
    • Ability to think creatively, highly-driven and self-motivated
    • Ability to work and adjust to changing deadlines
    • Ability to quickly adapt to changes, enhancements and new technologies
    • Able to perform in a fast paced, dynamic and innovative work environment and meet aggressive deadlines
    • Creative problem-solving skills.
    • Must be able to develop relationships across the organization, working cross functionally to get results
    • Ability to present complex information in a simplified fashion to facilitate understanding
    • Can effectively manipulate and analyze large amounts of data
    • The ability to understand data relationships, write and execute SQL queries
    • Proficient with MS Office products
    • Proficiency with SQL
    • Bachelor's degree in Bachelor's Degree in Business Administration, Computer Science, CIS or related field
    • 3-5 years of experience with data projects
    Addition qualifications:
    • Experience with data and enterprise modeling tools, such as Erwin.
    • Experience with ETL/Data Quality tools such as Informatica IDQ and Trillium
    • Technical expertise with analytical tools including SQL, SAS, SPSS, R, and Tableau preferable.
    • 3+ years or more years of experience in design, development, modification and testing of Hadoop solutions.
    • Experience in Oozie, Hive, Pig, Impala, Sqoop, Flume, Hbase & Solr a plus.
    • Minimum 7-10 yrs. of experience in Oracle databases
    • 5 or more years of experience in developing complex SQL queries using tools such as Oracle, MySQL.
    • Understanding of Pentaho or other ETL tool.
    • Experience with RedHat Enterprise Linux preferred.
    • Experience with designing, developing, and administering SQL Server databases
    • 3+ years of experience with developing databases in an Agile framework with constantly changing technical requirements
    • 3+ years of experience with designing, developing, and administrating a data warehouse preferred.
    • 3+ years of experience with designing, developing, and administrating Microsoft Access databases
    • 3+ years of experience with t-SQL and writing stored procedures, functions, and triggers.
    • 1+ years of experience with migrating a Microsoft Access database to a Microsoft SQL Server
    • 1+ years of experience with connecting a Microsoft Access front end to a Microsoft SQL Server back end
    • Experience with NoSQL, including Mongo DB, Neo4j, Cassandra, or others.
    • Experience with at least one scripting language, including Python, Perl, or others

    Numbers & Facts

    LocationSan Francisco, California (
    Remote
    )

    Skills

    • Agile Programming Methodologiesunmatched
    • Analysis Skillsunmatched
    • Apache Cassandraunmatched
    • Apache HBaseunmatched
    • Apache Hadoopunmatched
    • Apache Hiveunmatched
    • Apache Pigunmatched
    • Apache Sqoopunmatched
    • Application Integrationunmatched
    • Big Dataunmatched
    • Business Administrationunmatched
    • Business Intelligenceunmatched
    • Business Strategyunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Cross-Functionalunmatched
    • Data Administrationunmatched
    • Data Analysisunmatched
    • Data Formatsunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Modeling Toolsunmatched
    • Data Qualityunmatched
    • Data Storageunmatched
    • Data Warehousingunmatched
    • DataArchitect Data Modeling Toolunmatched
    • Database Administrationunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Programmingunmatched
    • Documentationunmatched
    • High Level Architecture (HLA)unmatched
    • IBM SPSS Statistical Packageunmatched
    • Informaticaunmatched
    • Interpersonal Skillsunmatched
    • Maintain Complianceunmatched
    • Management Strategyunmatched
    • Master Data Management (MDM)unmatched
    • Metadata Identificationunmatched
    • Microsoft Access Databaseunmatched
    • Microsoft Officeunmatched
    • Microsoft SQL Serverunmatched
    • Microsoft SQL Server DBA (Database Administration)unmatched
    • Microsoft Transact-SQL (T-SQL)unmatched
    • MongoDBunmatched
    • Multitaskingunmatched
    • MySQLunmatched
    • Neo4junmatched
    • NoSQLunmatched
    • Ontologyunmatched
    • Operational Strategyunmatched
    • Oracleunmatched
    • Oracle Databaseunmatched
    • Organizational Skillsunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Procedure Developmentunmatched
    • R Programming Languageunmatched
    • Red Hat Linux Operating Systemunmatched
    • Risk Managementunmatched
    • SOLRunmatched
    • SQL (Structured Query Language)unmatched
    • Standards Developmentunmatched
    • Statistical Analysis System (SAS)unmatched
    • Stored Proceduresunmatched
    • Tableauunmatched
    • Technical Supportunmatched
    • Testingunmatched
    • Time Managementunmatched
    • User Interface/Experience (UI/UX)unmatched
    • erwin Data Modelerunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder