Data Architect (Remote)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 strategyEnsures that database and data storage technologies support the data management needs of the enterpriseDevelops, communicates, supports, and monitors compliance with Data Modeling standardsEvaluates proposals for development projects to ensure they adhere to all data architecture standardsDevelops and maintains standard patterns for data layers, data stores, and utility data management processes (e.g. data movement, data integration) for application across the enterpriseAssists 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 architectureParticipates 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 curatedSkills 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 valueStrong organizational skills.
Able to multi-taskAbility to think creatively, highly-driven and self-motivatedAbility to work and adjust to changing deadlinesAbility to quickly adapt to changes, enhancements and new technologiesAble to perform in a fast paced, dynamic and innovative work environment and meet aggressive deadlinesCreative problem-solving skills.Must be able to develop relationships across the organization, working cross functionally to get resultsAbility to present complex information in a simplified fashion to facilitate understandingCan effectively manipulate and analyze large amounts of dataThe ability to understand data relationships, write and execute SQL queriesProficient with MS Office productsProficiency with SQLBachelor's degree in Bachelor's Degree in Business Administration, Computer Science, CIS or related field3-5 years of experience with data projectsAdditional qualifications:Experience with data and enterprise modeling tools, such as Erwin.Experience with ETL/Data Quality tools such as Informatica IDQ and TrilliumTechnical 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 databases5 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 databases3+ years of experience with developing databases in an Agile framework with constantly changing technical requirements3+ years of experience with designing, developing, and administrating a data warehouse preferred.3+ years of experience with designing, developing, and administrating Microsoft Access databases3+ 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 Server1+ years of experience with connecting a Microsoft Access front end to a Microsoft SQL Server back endExperience with NoSQL, including Mongo DB, Neo4j, Cassandra, or others.Experience with at least one scripting language, including Python, Perl, or others