Data Warehouse Architect 5 - Sr. ETL/BI Developer

Lansing, MI, US • Posted 5 hours ago • Updated 4 hours ago

Contract Independent

Contract Corp To Corp

Contract W2

On-site

CCS Global Tech

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Communication
Writing
Effective Communication
Database Administration
Database Modeling
Auditing
System Documentation
PMO
Project Estimation
Budget
Team Leadership
Management
Disaster Recovery
Change Management
System Requirements
Test Plans
Data Warehouse
Extract
Transform
Load
Data Marts
Dashboard
Data Analysis
PMM
Agile
SQL
Teradata
Business Intelligence
End-user Training
Facilitation
Physical Data Model
Reporting
Analytical Skill
Oracle Linux

Summary

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.

we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.

We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.

If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Roles/Responsibilities:

Communicate effectively, verbally and in writing, with programmers, analysts, immediate
supervisor, management, system users, operations, other State agencies and the private sector.
Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise
solutions and alternatives and make appropriate recommendations.
With the Business Analyst, presents the information gathered to the Project Review Board and/or
Project Sponsors during project review meetings, project workgroups and to the Technical
Review Board providing clarification and answers to questions.
Consult with agency clients to explain complex IT processes and solutions, developing and maintaining an effective communication plan with DTMB and agency clients relating to project level metrics, bureau level project reporting, etc.
Assist Architect or DBA to draft technical database model that:
Complies with audit separation of duty requirement.
Captures requirements of data elements
Designs data elements to best meet application needs
Reviews and approves updates to systems documentation.

Gather, review, and analyze potential impacts of changes and inform DTMB management andsupported client agency of impact and risks to existing IT solutions due to proposed legislation,
enhancement requests, changes in government requests, changes in governmental processes or procedures.
Provide professional technical expertise to the DTMB AS PMO Managers and client agency managers and supervisors in IT project estimating, and budgeting.
Serves as a team lead and resource, directing the code development, providing advice and guidance to other development staff.
Evaluate and identify opportunities for programming process or tools standardization.
Perform disaster recovery planning and implementation.
Provide input to procedures and ensure proper change management for all requested fixes to production systems.
Review and approve test plans. Incorporate all levels of security, which were identified as system requirements, into test plans.

Mandatory Skills:

Bachelor's degree or equivalent technical study
6+ Years Creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery system.
2+ Years Child Welfare Services, Juvenile Justice, Juvenile services, or other related experience
SQL Assistant/Teradata Studio Experience, BI applications

Desirable Skills:

Experience with the State of Michigan PMM/SUITE/Agile methodology
SQL Assistant/Teradata Studio Experience, BI applications
End user training experience
Must be able to work independently with little direction
Experience working with Data Modelers and developers, facilitating modification of the logical
design to create a physical design most suited to the reporting needs of the customer.
Ability to design applications taking into consideration data reconciliation, (to the source system)
query/reporting performance, and analytical business value.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10290999
Position Id: 2026-6766
Posted 5 hours ago

Company Info

About CCS Global Tech

Headquartered in Poway, California and eight international offices, CCS Global Tech is a Certified Minority Business Enterprise (MBE) and a leading provider of enterprise solutions. We provide solutions that cover the full business spectrum from application development, data warehouse software, real time data warehousing, business analysis software, and web-based application development. Our clients span the globe and benefit from our comprehensive support capabilities.

Our tools and technical expertise have repetitively proven to reduce the time and costs associated with software and custom solution development. CCS Global Tech begins each project with quality analysis and business due diligence in order to deliver quality solutions for our clients. Our team of international talent asks critical questions that illuminate the fine details of the project scope. Once we have a clear and comprehensive view of the objectives sought, we set to work to bring your vision to life.

We have a complementary matrix of skills and talents across multiple platforms that allow us to identify, target and bridge technical gaps. Regardless of the size and scope of your business application, data warehouse initiative, or enterprise-wide project, our team supports service, technical capabilities and cost effective solutions that are unmatched by our competition. We focus on delivering state-of-the-art technology, application development, warehousing and support to our clients. With the scope and flexibility to optimize development schedules and products to fit any budget requirements, CCS Global Tech is aptly positioned to not only meet unique, strategic IT objectives of diverse organization, but also complement organizational goals.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.