Senior Data Warehouse Architect
Brooksource
Dice Job Match Score™
📊 Calculating match score...
Job Details
Skills
- Business Process
- Change Management
- DDL
- Promotions
- Servers
- Documentation
- Data Architecture
- Scalability
- Management
- Data Integration
- Extract
- Transform
- Load
- Workflow
- Collaboration
- Patch Management
- Data Profiling
- Data Quality
- Data Cleansing
- Disaster Recovery
- Backup
- Regulatory Compliance
- Auditing
- Teradata
- Training
- Linux
- Decision-making
- Conflict Resolution
- Problem Solving
- Analytical Skill
- Communication
- Business Intelligence
- Cloud Computing
- Amazon Web Services
- Google Cloud
- Google Cloud Platform
- Microsoft Azure
- Leadership
- SAP BASIS
- Project Scoping
- Data Warehouse
Summary
Pay Range: $85-$95/hr.
Location: Hybrid in Lansing - 2 days a week on site
Job Responsibilities:
Responsible for complex Common Batch Framework and Common Scheduler to ensure
current and reliable data is available for critical business processes and decision
making.
Responsible for Data Warehouse change management infrastructure and all promotions
of code and ddl; performing build engineer tasks for both manual and automated
promotion processes.
Responsibility for complex Linux security model on DW ETL servers. (Servers are
administered by another group, but our team is responsible for the security structure and
authorizes user access to the groups and sudos)
Responsibility for Teradata security and access.
Conduct data architecture reviews and audits to ensure alignment with enterprise
standards
Create and maintain comprehensive documentation of data architecture, processes, and
solutions
Responsible for providing support for escalated Data Warehouse issue troubleshooting
and resolution.
Evaluate and recommend new data technologies and tools to improve performance and
scalability
Ensure data quality, accuracy, and effective use of enterprise data assets
Manage and support data integration processes, including ETL workflows across multiple
systems
Collaborate with external vendors and third-party service providers as needed
Support patch management, system upgrades, and ongoing system maintenance
Monitor system performance and troubleshoot technical issues across data platforms
Perform data profiling and implement data quality rules for assessment and validation
Execute data cleansing and standardization using both built-in and custom data rules
Develop and maintain disaster recovery and backup strategies for data systems
Lead efforts to migrate data warehouse processes to standardized/common frameworks
Conduct elevated access reviews and user audits to ensure compliance
Identify and remediate audit findings related to data systems and security
Required Qualifications:
8+ years Teradata experience - top requirement
Experience supporting the loading of data from multiple source systems
Ability to provide targeted training and technical guidance to development teams for
troubleshooting and batch support
Minimum of 5 years of Linux experience
Proven ability to work both independently and collaboratively within a team environment
Strong decision-making skills with the ability to determine appropriate solutions while
adhering to SoM and MDHHS/DTMB policies
Strong problem-solving and analytical thinking skills, particularly in troubleshooting
complex data and system issues
Strong communication skills with the ability to translate complex technical concepts to
both technical and non-technical stakeholders
Preferred Qualifications:
Previous government experience or State of Michigan experience
Experience with cloud-based BI tools
Experience with cloud-native platforms ( AWS, Google Cloud Platform, or Azure ) preferred.
Additional Notes:
Team Environment: The team currently consists of 2 State employees and 6 long-term
contractors. It's a collaborative and well-established group that is looking for a senior-
level resource who can step in and contribute immediately.
Work: Most work comes through one of the MDHHS Data Warehouse development
teams. This role will work closely with developers, leadership, stakeholders, and various
SOM and vendor staff on a day-to-day basis.
Project Scope: The scope is the MDHHS Data Warehouse project, which consists of
Child Support, Child Welfare, Eligibility, and Health Services programs.
#LI-PK1
- Dice Id: 10110651
- Position Id: a1Wcv000000qnFxEAI
- Posted 3 days ago
Company Info
Here at Brooksource, relationships are at the center of everything we do. Since 2000, we have established and maintained long-lasting relationships with our clients and consultants to create an unparalleled experience. Brooksource is a trusted services provider that specializes in delivering Engineering and IT solutions for Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our Workforce Transformation program. As a certified partner for Salesforce, AWS, Microsoft, Google Cloud, and many other technology alliances, we are looking for professionals who want to be on the frontline of the latest trends in the industry.
We offer contract, contract-to-hire, and direct placement consultant opportunities, to provide a career path that can meet anyone's desires. The job search is hard, but you don’t have to do it alone! We know a successful partnership requires a good fit. Your personality, experience, and skill set are all important, contributing factors to that partnership. You can count on us to take the time to understand the type of technical and cultural fit that is right for you. As a Brooksource consultant, you will be provided with a comprehensive benefits plan, competitive compensation, and even paid time off!
Cyber Security Warning: Please be aware that all official Brooksource communications will ONLY come from emails displayed as [name]@brooksource.com. The use of any other domains is NOT an official Brooksource employee and could be fraudulent.
Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.
Benefits & Perks:
Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.
Pay Disclaimer:
The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Partnerships:
- Gold Microsoft Partner – Cloud Platform
- Gold Microsoft Partner – Data Analytics
- Silver Microsoft Partner – Data Platform
- Silver Microsoft Partner – Security
- Silver Microsoft Partner – Application Development
- Silver Microsoft Partner – Data Center
- AWS Partner
- Salesforce Partner
- Salesforce – Authorized Training Provider
- Salesforce Talent Alliance Employer
- Tableau Services Partner
- Snowflake Partner
- Google Cloud Platform (GCP) Services Partner
Awards (Extended):
- Best Places to Work 2022, Charlotte Business Journal, 2022
- Best Places to Work in Jacksonville, Jacksonville Business Journal, 2021
- Best Places to Work in Jacksonville, Jacksonville Business Journal, 2020
- Best Places to Work in Charlotte (#8 Small Business), Charlotte Business Journal, 2019
- 2019 Best Places Work in Kentucky, Kentucky Chamber of Commerce, 2019
- Top Workplaces, Indy Star, 2019
- Best Places to Work in Jacksonville, Jacksonville Business Journal, 2019
- Best & Brightest Companies to Work For in the Nation, Best & Brightest, 2018
- Top Work Places, Indy Star, 2018
- Best Places to Work, Jacksonville Business Journal, 2018
- Best Places to Work, Charlotte Business Journal, 2018
- Best Places to Work in Kentucky (Small/Medium), Kentucky Society for Human Resource Management State Council and the Kentucky Chamber of Commerce, 2018
- Milwaukee’s 2018 Best And Brightest Companies To Work For, Milwaukee's Best and Brightest Place to Work, 2018
- Best Places to Work, Best Places to Work in Kentucky, 2017
- Best Places to Work, Best Places to Work in Kentucky, 2016
- Best Places to Work, Jacksonville Business Journal, 2016
- Top Workplaces, The Indianapolis Star, 2016
- Top Workplaces, Indianapolis Star, 2015
- Best Places to Work, Charlotte Business Journal, 2015
- Best Places to Work Atlanta, Atlanta Business Chronicle, 2014
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs