Data Architect

3 weeks ago

San Francisco, United States Francisco Partners Full time

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 & Requirements 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

Qualifications

  • Data Architect I

    3 days ago

    San Francisco, United States eTeam Inc. Full time

    Job Title: Data Architect Duration: 3 Months Location: CA Pay Rate - $65/hr. - $70/hr. on W2 Job Description: Minimum 8 years of recent experience in database development, relational databases, data lakes, data analytics solutions, and data warehousing, including cloud-native databases and modern cloud-based data warehouse systems. Strong hands-on experience...

  • Data Architect

    3 days ago

    San Francisco, United States Unreal Gigs Full time

    Job Description Job Description Company Overview: Welcome to the forefront of data architecture! At our company, we're dedicated to leveraging the power of data to drive insights and innovation. Our mission is to develop scalable and efficient data architecture solutions that enable organizations to unlock the full potential of their data. Join us and be...

  • Data Architect

    2 weeks ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data architecture! At our company, we're dedicated to leveraging the power of data to drive insights and innovation. Our mission is to develop scalable and efficient data architecture solutions that enable organizations to unlock the full potential of their data. Join us and be...

  • Data Architect

    5 days ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data architecture! At our company, we're dedicated to leveraging the power of data to drive insights and innovation. Our mission is to develop scalable and efficient data architecture solutions that enable organizations to unlock the full potential of their data. Join us and be...

  • Lead Data Architect

    3 days ago

    San Francisco, United States Unreal Staffing, Inc Full time

    Company Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and analytics. Join us and lead our...

  • Lead Data Architect

    2 weeks ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and...

  • Lead Data Architect

    5 days ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and...

  • Enterprise IT Architect

    7 days ago

    San Francisco, United States Mindlance Full time

    Summary of Work: The mission of the EA program is to facilitate business and IT alignment by creating, communicating, and improving the key principles and models that describe the branchs future state and enable its evolution. As new technologies are contemplated for adoption to support mission critical applications, an Enterprise Architect leads teams of...

  • Senior Data Architect

    4 days ago

    San Francisco, United States Unreal Gigs Full time

    Job Description Job Description Company Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and...

  • Senior Data Architect

    2 weeks ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and...

  • Senior Data Architect

    5 days ago

    San Francisco, United States Unreal Gigs Full time

    Job DescriptionJob DescriptionCompany Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and...

  • Data Architect

    23 hours ago

    San Francisco, CA, United States Outdefine Full time

    As a skilled professional seeking career growth, you deserve access to the best job opportunities available. Join Outdefine's Trusted community today and apply to premier job openings with leading enterprises globally. Set your own rate, keep all your pay, and enjoy the benefits of a fee-free experience. Data Architect Outdefine Partner Web3 10-50 San...

  • Data Lake Architect

    4 days ago

    San Francisco, United States FreightVerify Full time

    FreightVerify is a supply chain technology company that provides real-time transportation visibility and business intelligence for global enterprise clients. Utilizing the latest IoT, big data, and AI technologies, FreightVerify provides a neutral platform that simplifies complex global supply chains through a common design language to leverage new and...

  • Data Architect

    1 month ago

    San Francisco, CA, United States hims & hers Full time

    About the Role: We're looking for an experienced Data Architect to join our Data Platform Engineering team. Our team is responsible for enabling Hims & Hers business (Product, Analytics, Operations, Finance, Data Science, Machine Learning, Customer Experience, and Engineering) by providing a platform with a rich set of data and tools to leverage. As...

  • Data Architect

    3 weeks ago

    San Francisco, California, United States Francisco Partners Full time

    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...

  • Lead Data Architect

    24 hours ago

    San Francisco, CA, United States Unreal Staffing, Inc Full time

    Company Overview: Welcome to the forefront of data-driven innovation! Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building cutting-edge data architecture solutions that enable efficient data management, storage, and analytics. Join us and lead...

  • Data Center Architect

    2 weeks ago

    San Francisco, United States K-Tek Resourcing LLC Full time

    Title : Data Center Architect (NETWOR ARCHITECT) Location : San Francisco Bay , CA Rate : 65/h 100% onsite. Need good resume don't submit just like that, Make sure candidate has required skills. Job Description Modern data center needs are changing and require a multi-disciplinary approach to design and management. Automation, High-Performance Computing,...

  • Principal Data Solutions Architect

    1 week ago

    San Francisco, California, United States Pacific Gas and Electric Company Full time

    Requisition ID # Position SummaryThe Digital Utility runs on data and information. PG&E believes that one of the most critical drivers of our future success depends on our ability to extract insights and information from the data we manage. The Principal Solution Architect fills a critical role in PG&E's success building the Digital Utility.The Principal...

  • Principal Data Solutions Architect

    6 days ago

    San Francisco, United States Pacific Gas and Electric Company Full time

    Requisition ID # 155115  Position Summary The Digital Utility runs on data and information. PG&E believes that one of the most critical drivers of our future success depends on our ability to extract insights and information from the data we manage. The Principal Solution Architect fills a critical role in PG&E's success building the Digital...

  • AWS Data Architect

    1 month ago

    San Francisco, CA, United States Saxon Global Full time

    Must haves:Expert knowledge of Syndicated Data Platforms (IRI/Nielsen) and its capabilities as utilized in Marketing / Sales domain including how to architect and design syndicated data platforms.Experience with Azure Cloud (Snowflake Cloud Database would be major plus)7-10 years of experience; okay with 100% REMOTE candidates - must work EST hours; open to...