SENIOR DATA WAREHOUSE ARCHITECT

November 22, 2022
scroll
1 position

SENIOR DATA WAREHOUSE ARCHITECT

location

San Jose, USA

Svitla Systems Inc. is looking for a Senior Data Warehouse Architect for a full-time position (40 hours per week) in the USA. Our client is a pivotal leader in electronic design, building upon more than 30 years of computational software expertise. The company applies its underlying Intelligent System Design strategy to deliver software, hardware, and IP that turn design concepts into reality. The client’s customers are the world’s most innovative companies, providing unique electronic products from chips to boards to systems for the most dynamic market applications, including consumer, hyperscale computing, 5G communications, automotive, aerospace, industrial, and health. The client is looking for a hardworking, highly motivated Data Warehouse Engineer. This high-performing individual should have collaboration skills and the ability to work across multiple domains and software disciplines to achieve results. It is an experienced and hands-on Data Warehouse Developer position that requires research, analysis, design, and development of solutions per the business requirements.

Requirements:

  • 10+ years of experience in DW/BI space designing the model and building analytics. 
  • At least executed two end-to-end implementations. 
  • At least 2 years of experience with  Azure SQL and ADF.
  • 3+ years of experience in building Tableau models, reports, and dashboards.
  • Ability to manage all warehouse data, design architecture, and prepare appropriate documents to develop a schema data model.
  • Solid knowledge of data warehouse systems (star schema, snowflake schema, dimensions, measures, slowly changing dimensions).
  • The advantage is for people who have worked with Tableau and Microsoft Azure.   
  • Experience developing and optimizing stored procedures and functions using T-SQL for data migration and transformation.
  • Proficiency in Azure SQL stack architecture (SQL Server, SQL Warehouse, and Azure Data factory).
  • Technical knowledge of Python, Pentaho, or shell scripting.
  • Experience in administration of Tableau server is mandatory.
  • Ability to interact with business users to understand business requirements, document them, and provide an optimal solution.
  • Production support experience in investigating errors/exceptions and resolving the errors at the root level.
  • Excellent verbal and written communication skills.
  • Self-motivated, passionate about technology, and a strong driver for results and continual improvement.
  • Bachelor’s degree in Computer Science, a related field, or equivalent experience.

Responsibilities:

  • Build the client’s enterprise data platform to support data-driven culture. 
  • Work closely with business users, collect business requirements, prepare design documents, develop ETL logic and validation scripts to ensure 100% data accuracy, design security control, and deploy and monitor solutions in production.
  • Manage all warehouse data, design architecture, and prepare appropriate documents to develop a schema data model.
  • Evaluate all data, perform various tests on the data warehouse, and ensure effective implementation.
  • Coordinate with business users and prepare documents to plan and control various volumes of data.
  • Maintain data warehouse systems and provide production support.
  • Evaluate all data, perform various tests on the data warehouse, and ensure effective implementation.
  • Administer all data and ensure compliance with standards and policies. Maintain high-quality deliverables and provide efficient guidance to all database architecture.

Will be a plus:

  • Functional knowledge of standard business processes like a quote to cash, procure to pay, hire to retire, clickstream analysis, revenue, booking, billing, etc.
  • Knowledge of other analytics platforms like Epiphany, SAP BW, etc.
  • Experience in leading a technical team.
  • Knowledge of predictive modeling & analytics.
  • Experience in applied machine learning and building recommendation engines.
  • Ability to draw data insights.

About Svitla:

Svitla Systems is a global trusted IT solutions company headquartered in California, with business and development offices throughout the US, Latin America, Europe, and Asia. Svitla is an outspoken advocate of workplace flexibility, best known for its well-established remote culture, individual approach to our teammate’s professional and personal growth, and family-like environment.

Since 2003, Svitla has served a wide range of clients, from innovative start-ups in California to mega-large corporations such as Ingenico, Amplience, InvoiceASAP and Global Citizen. At Svitla, developers work with clients’ teams directly, building lasting and successful partnerships, as a result of seamless integration with on-site processes. 

Svitla Systems’ global mission is to build a business that contributes to the well-being of our partners, personnel and their families, improves our communities, and makes a lasting difference in the world. Join us!

If you are interested in our vacancy, please send your CV. We will be happy to see you in our friendly team :)

Why hesitate? Apply now

Send your resume

Thank you for applying for this job position

Your application is received. We will contact you shortly if your resume is a perfect fit for our company.