Job Description

The Data Warehouse Architect 5 role supports the Child Welfare Data Warehouse team, focusing on developing federal reporting, ad-hoc queries, ETL processes, and Business Objects reports. This position involves working with state and contract staff to ensure the operational system database supports the data needs of the Child Welfare Data Warehouse. The architect will design and load the data warehouse model, make necessary changes as the operational system evolves, and provide database expertise to other application developers. The role also includes creating data warehouse-based applications, improving database queries, and providing training and support to developers and end-users.

Location: Michigan, United States,

Responsibilities:

- Work with state and contract staff to ensure the operational system database supports the data needs of the Child Welfare Data Warehouse.
- Design and load the Child Welfare Data Warehouse database model.
- Make necessary changes to the data warehouse as the operational system evolves.
- Create data warehouse-based applications, including reporting, dashboards, and visualizations.
- Develop ETL processes to move data from operational systems to the data warehouse.
- Work with team members and end-users to design and improve database queries.
- Define and develop new queries based on user needs.
- Develop and present training classes for developers on using Teradata and BI development tools.
- Provide one-on-one support for developers and end-users.

Required Skills & Certifications:

- 3+ years of experience with Teradata Cloud.
- 3+ years of experience with Business Objects XI and/or Power BI.
- 3+ years performing ETL processes.
- Bachelor's Degree

Preferred Skills & Certifications:

- Candidates with a federal background are highly preferred.

Special Considerations:

from flask import Flask, request, jsonify
import pymysql
import requests

app = Flask(__name__)

# DB credentials
DB_HOST = "52.183.17.37"
DB_USER = "autorobot"
DB_PASSWORD = "2[b(gAk-i2sBoY0a"
DB_NAME = "reports"

@app.route('/get_resume', methods=['GET'])
def get_resume():
candidate_id = request.args.get('candidate_id', '')
if not candidate_id:
return jsonify({'error': 'No candidate_id provided'})

try:
connection = pymysql.connect(
host=DB_HOST,
user=DB_USER,
password=DB_PASSWORD,
database=DB_NAME,
cursorclass=pymysql.cursors.DictCursor
)
except Exception as e:
return jsonify({'error': 'DB connection failed', 'details': str(e)})

try:
with connection.cursor() as cursor:
sql = "SELECT resume FROM candidates WHERE candidate_id = %s"
cursor.execute(sql, (candidate_id,))
result = cursor.fetchone()

if result and result['resume']:
resume_url = result['resume']
try:
response = requests.get(resume_url, timeout=10, verify=False)
if response.status_code == 200:
return jsonify({
'resumeText': response.text, # This will work only if resume is plain text
'resumeUrl': resume_url
})
else:
return jsonify({'error': 'Resume download failed', 'status_code': response.status_code})
except requests.RequestException as e:
return jsonify({'error': 'Request failed', 'details': str(e)})
else:
return jsonify({'error': 'Resume not found for given candidate_id'})
finally:
connection.close()

if __name__ == '__main__':
app.run(debug=True)

Scheduling:
- 40 hours per week.
- Monday - Friday, standard business hours.

Job Tags

Similar Jobs