The Data Architect will lead database management, conduct data analysis, and work with stakeholders to align data requirements with business objectives.
Job Description – Data Architect
Lextech is a group of inventive thinkers who care deeply about our clients. We create user experiences that achieve their most important business results. Our superpower is using technology to help employees thrive at work. For more info, visit http://lextech.com.
Lextech is looking to add a Data Architect to the team. A Data Architect brings value and leadership throughout the organization and will be expected to serve in the following areas. This contract is expected to 5 months, with a possible extension through the end of year.
Skills/Competencies & Education
These are the characteristics that we look for in people who can effectively fill the role:
Must Have Technical Skills
- 7+ years progressively complicated database experience
- Experience with writing SQL, Python, performing data analysis
- Experience working with relational databases like Microsoft SQL Server, MySql, and RDS Aurora
- Experience with data modeling, creating tables, indexes, views, and have a solid understanding of how relational databases work
- Experience loading data from source files into relational databases
- Experience migrating database changes between environments
Required Analysis Skills
- Experience working with business users, project stakeholders, and technical system experts to map data requirements back to the application source systems
- Experience creating data requirements derived from screen designs, user stories, and desired scope requests, and mapping the data needs to application source systems
- Ability to analyze and interpret data from reports, source systems, and data source files
- Experience managing and creating data mapping documentation between systems
- Ability to work with the project team, product owners to prioritize business and data needs
Bonus Technical Skills
- Familiar with AWS Glue, and/or other cloud based ETL tools
- Experience with JSON files and formats
- Experience using API testing tools like Postman
- Experience querying SalesForce using Workbench
- Experience with AWS services such as S3, Lambdas, and Athena
- Experience with Python
Responsibilities:
Every day, these are the things that the person in this role will do successfully:
- Work with product stakeholders and technical SMEs to understand the relation between business objectives, workflow and enterprise data
- Create and present technical proposals to a client Architecture Control Board
- Data sourcing and mapping with a focus on data quality, security, integrity
- Explore and analyze enterprise data sets
- Evaluate changes and updates to source production systems, assess risks
- Provide technical expertise to troubleshoot data-related issues, translating technical challenges into business context
- Communicate data needs and issues to the project team and product stakeholders
Similar Jobs
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Lead the software and data architecture for diverse defense programs; ensure technical direction and mentor staff while developing complex IT solutions from proof-of-concept to production.
Top Skills:
.NetAgileArtificial IntelligenceC/C++DevsecopsGoMachine LearningMatlabPythonRRust
Fintech • Software
The Cloud Data Architect will design scalable data architectures for SaaS solutions, set data standards, collaborate with engineering, and ensure data governance and optimization. Requires advanced SQL and cloud platform proficiency.
Top Skills:
Apache AirflowAzureAzure Data FactoryAzure SynapseDatabricksOciOraclePysparkPythonSnowflakeSpark SqlSQL
Design
The Data Architect will design and implement data solutions, manage projects, integrate data systems, and lead teams to meet client needs.
Top Skills:
Aws GlueAzureAzure Data FactoryBigQueryDatabricksDbtFivetranJenkinsMatillionPower BIPythonRRedshiftSnaplogicSnowflakeSQL ServerTableauTerraform
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
