Overview
Skills
Job Details
Hi,
Greetings from DIA SOFTWARE SOLUTIONS LLC!
We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?
Direct client Req:: Need Sr Database Architect Leve(Databricks), TX, Remote
PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !
Job Description:
- The Data Architect Level III will serve as a senior technical advisor supporting the agency s initiative to modernize its data ecosystem, with a specific focus on evaluating and planning the migration of data assets and workloads to Databricks. This role will work closely with ODSI staff, IT staff, and business stakeholders to assess current environments, define architectural strategies, and guide the implementation roadmap for Databricks adoption.
Work may involve the following:
- Performs advanced (senior-level) data analysis and architecture work. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment. Employees at this level may be considered technical experts in the field.
- Lead assessment of existing on-premises and cloud-based data platforms, identifying readiness and suitability for migration to Databricks.
- Develop architectural strategies and target-state designs to support scalable, secure, and high-performing data solutions in Databricks.
- Provide expert-level guidance on Databricks capabilities including data lake architecture, Delta Lake, and Spark-based processing.
- Define best practices and standards for data modeling, ETL/ELT processes, and pipeline development in Databricks.
- Collaborate with cross-functional teams to define a phased migration roadmap, including data governance and security considerations.
- Assist in developing proof-of-concepts or pilot projects that demonstrate value and feasibility of the Databricks platform.
- Mentor and advise internal DFPS staff on Databricks architecture and development approaches.
- Produce documentation including architectural diagrams, migration strategies, technical assessments, and recommendations.
- Coordinates and gathers data model requirements, and assists with the analysis, design, modification, and maintenance of database structures, models, and architectures.
- Supports data analytics and business intelligence systems and coordinates the implementation of database changes to support new and modified applications, ensuring that new designs conform to standards and guidelines.
- Recommends and develops standards, procedures, and guidelines on creating and maintaining data models and governed data, ensuring completeness and quality.
- Assists with other duties as assigned.
SKILLS MATRIX
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | |||
Actual | Years | Required/ | Skills/Experience |
| 8 | Required | Experience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture |
| 8 | Required | Experience in database administration, data analysis, research, or architecture work in Oracle database |
| 8 | Required | Experience in data architecture, database design, and enterprise data systems. |
| 8 | Required | Proven experience with data security, master data management, meta data management and support for creation of data dictionaries, data lineage flows and other documentation |
| 8 | Required | Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization |
| 8 | Required | Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models |
| 8 | Required | Experience with identifying and documenting data sources, risks and data controls and ability to translate privacy and information security policies into operational procedures |
| 8 | Required | Engage with various business groups and technology to research, define and document proper governance and stewardship practices |
| 8 | Required | Enterprise data warehouse and storage design experience on both on-premise and cloud platforms |
| 8 | Required | Exposure to data classification, clustering, deduplication methodologies |
| 8 | Required | Knowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence/analytics tools, frameworks and infrastructure |
| 8 | Required | Knowledge of SQL, data modeling, normalization/denormalization techniques, and database performance tuning. |
| 8 | Required | Knowledge of database software and technologies, cloud technologies, and engineered systems and enterprise software products, including Microsoft Azure AWS and Oracle |
| 8 | Required | Experience in designing data pipelines, ingestion frameworks, and batch/streaming ETL solutions using Spark in Databricks. |
| 8 | Required | Excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge |
| 8 | Required | Skill in monitoring projects, and establishing measurement and tracking for project tasks |
| 8 | Required | Ability to analyze, evaluate, and summarize data and information for accuracy and conformance to standards |
| 8 | Required | Ability to document policies, procedures, and processes |
| 8 | Required | Ability to exercise sound judgement, critical thinking and analytical skills |
| 8 | Required | Ability to establish and maintain effective working relationships at all levels of the organization |
| 5 | Required | Experience designing and implementing data lakehouse architectures using Azure Databricks |
| 5 | Required | Experience with Databricks, including experience with both Databricks SQL and Delta Lake. |
| 3 | Required | Experience architecting or implementing solutions using Databricks. |
| 3 | Preferred | Experience integrating Databricks with Informatica, or Tableau + for data cataloging, MDM, or reporting. |
| 1 | Preferred | Strong working knowledge of the following DFPS systems/programs (including but not limited to): IMPACT, PACES, ABCS, PEIRS, NEICE, e-Report, e-Travel, General Placement Search and Community Based Care. |
| 1 | Preferred | Knowledge of the Texas Project Delivery Framework |
DIA SOFTWARE SOLUTIONS LLC.
Austin, TX 78727| Direct:
DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Diasoft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer